Financial Ratios
get_financial_ratiosPipeline-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
Paste this in your terminal — the free 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_atExample 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 }]Shape only — field names match the live schema; values are placeholders, not real filings. 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.