curatedapi

Excel's answers, in your code

29 of Excel's financial and date functions as an API: XIRR, XNPV, RATE, PMT, YEARFRAC, NETWORKDAYS, PRICE, YIELD and more. Same arguments, same conventions, same results as Excel.

Free plan, no card needed. Test keys are never billed.

POST /v1/calc/excel/xirrRequest
curl https://api.curatedapi.com/v1/calc/excel/xirr \
  -H "Authorization: Bearer $CURATEDAPI_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "values": ["-10000", "2750", "4250", "3250", "2750"],
    "dates": ["2008-01-01", "2008-03-01", "2008-10-30", "2009-02-15", "2009-04-01"],
    "options": {"significant_digits": 7}
  }'
200 OKResponse, shortened
{
  "calculator": "excel/xirr@1",
  "result": {
    "xirr": "0.3733625",
    "all_rates": [
      "0.3733625"
    ]
  }
}
Microsoft's example: five dated cash flows

The problem

When a financial model moves from a spreadsheet into an app, the numbers often stop matching. XIRR gives a different rate, YEARFRAC counts the days another way, or RATE gives up with an error. Then someone has to explain to finance why the app disagrees with Excel.

Each function follows Excel's documented arguments and day-count rules, and is checked against Microsoft's published examples and values saved by Excel. RATE, XIRR and YIELD return proven roots instead of stopping after a fixed number of tries.

What you get

  • Microsoft's examples run before every release and against the live API every five minutes
  • Decimal arithmetic, rounded once, to the digits you choose
  • An MCP tool too, so an AI agent can answer "what would Excel say?"
  • Free to try on this site, without signing up

What a month costs

Each of these function calls is one call. The cheapest plan for each volume, in US dollars (euro plans cost the same number of euros), before any VAT or sales tax your country charges. A spend cap stops calls at the amount you choose.

Function calls a monthPlanPer month
1,000Free$0
50,000Starter$9.00
500,000Pro$29.00
2,000,000Business$99.00

All plans are on the pricing section of the home page.

Endpoints

Each one is a POST endpoint and an MCP tool. Its page shows the inputs, an example and the sources it is checked against.

Missing something you need?

Tell us what you need and the source you trust, such as a regulator's example or a spreadsheet. Most new calculators go live within a week, checked against that source. Write to hello@curatedapi.com.