Get Financial Ratios

get_financial_ratios

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)

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.