What inputs does get_financial_ratios accept?

ticker (string, required): Ticker symbol limit (integer, optional): Number of periods. Defaults to 8. include_ttm (boolean, optional): Include TTM (trailing 12 months) rows. Defaults to true.

Which Valuein plans include get_financial_ratios?

Available on: sample, sp500, full. Not point-in-time safe.

MCP Tools/get_financial_ratios

Financials

Financial Ratios

get_financial_ratios

sample

sp500

full

Pipeline-computed derived financial ratios from ratio.parquet: profitability (gross margin, operating margin, net margin, ROE, ROA, ROIC), liquidity (current ratio), leverage (debt-to-equity), and cash flow (FCF margin, FCF yield). Supports TTM (trailing twelve months) periods.

Example Call

# Using the Valuein MCP server from Python (via MCP SDK)
# Or call directly from Claude / Cursor after setup

result = await client.call_tool(
    "get_financial_ratios",
    arguments={
    "ticker": "EXAMPLE"
}
)
print(result)

Direct tool call:get_financial_ratios(ticker="GOOGL", include_ttm=True)

Try it now

No token required

Paste this in your terminal — the sample tier returns real S&P500 data without authentication.

# No auth required — sample tier covers S&P500 with a 5-year window.
# Add an Authorization: Bearer header for full universe and history.
$ curl -X POST https://mcp.valuein.biz/mcp \
    -H "Content-Type: application/json" \
    -d '{
        "jsonrpc": "2.0",
        "id": 1,
        "method": "tools/call",
        "params": {
          "name": "get_financial_ratios",
          "arguments": {
            "ticker": "AAPL",
            "limit": 3
          }
        }
      }'

Inputs

Parameter	Type	Required	Description
`ticker`	string	required	Ticker symbol
`limit`	integer	optional	Number of periods. Defaults to 8.
`include_ttm`	boolean	optional	Include TTM (trailing 12 months) rows. Defaults to true.

Output Fields

ratio_namecategoryvalueunitperiod_endfiscal_yearfiscal_periodis_ttmcomputed_at

Example Response

[
  {
    "ratio_name": 0.2543,
    "category": null,
    "value": 394328000000,
    "unit": null,
    "period_end": "2024-03-15",
    "fiscal_year": 2024,
    "fiscal_period": "FY",
    "is_ttm": true
  }
]

Returns gross margin, operating margin, ROE, debt-to-equity, and 15+ other ratios for Alphabet.

Notes

Ratios are computed by the pipeline from standardized fact data — not directly reported by companies. Not PIT-safe: computed_at reflects pipeline run time, not filing knowledge.