Excel Finance MCP

bond_duration

Calculate Macaulay duration for bonds using cash flow timing and yield rates to measure interest rate sensitivity and manage portfolio risk.

Instructions

Calculate Macaulay duration for bond

Input Schema

Name	Required	Description	Default
`cashFlows`	Yes	Array of [time, cashFlow] pairs
`yieldRate`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "cashFlows": {
      "description": "Array of [time, cashFlow] pairs",
      "items": {
        "items": {
          "type": "number"
        },
        "maxItems": 2,
        "minItems": 2,
        "type": "array"
      },
      "type": "array"
    },
    "yieldRate": {
      "type": "number"
    }
  },
  "required": [
    "cashFlows",
    "yieldRate"
  ],
  "type": "object"
}

This server cannot be installed

Other Tools from Excel Finance MCP

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/jeremycharlesgillespie/excel-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server