XIRR from dated transactions
calculate_xirrXIRR (annualised return) on investments made on different dates, such as mutual fund SIP instalments, top-ups and withdrawals, from a list of dated transactions and the holding's current value. Same definition as Excel's XIRR (actual days / 365). Also returns total invested, withdrawn, gain and absolute return.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"transactions": "<transactions>",
"current_value": "<current_value>"
},
"name": "calculate_xirr"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value_date | No | Date of current_value as YYYY-MM-DD (default: today in India) | |
| transactions | Yes | Each investment or withdrawal, in any order | |
| current_value | Yes | What the holding is worth now, in rupees (0 if fully withdrawn) |