Fundamentals as columns, not filings: statement line items — revenues, margins, cash flow, debt — alongside the ratios computed from them, share structure, short interest and dividends, one row per ticker for every US equity. Read a company, or screen the whole market on any of it in one SQL call; the same columns answer as of any past day.
Free plan. Every ticker, every signal, real-time data, all-time history.
what you get
| Statements | Income, balance-sheet and cash-flow line items as named columns — revenues, gross profit, operating income, long-term debt, free cash flow |
| Ratios | P/E (trailing and forward), EV/EBITDA, price-to-book, margins, ROE, current ratio — computed, not left as an exercise |
| Share structure | Shares outstanding, float, insider and institutional ownership, short interest with days-to-cover |
| Dividends | Yield, amount, frequency, ex-dividend and pay dates — plus an approaching-dividend flag to screen on |
| Screening | Every fundamental is a SQL column: screen the whole market on statements and ratios in one call |
| Growth & TTM | Trailing-twelve-month rollups and year-over-year growth rates, precomputed per ticker |
Every read runs in three tenses: live, as of any past moment (add ?asof=; no look-ahead, no survivorship bias), or on push — the same query as a webhook that fires when the answer changes. Under it sits the computed table: every US equity plus rates, FX and crypto, every signal precomputed and refreshed continuously, all-time history. Data included — there’s no feed to bring.
one call
Cheap relative to earnings, growing, and cash-generative — asked of every US equity at once:
POST /v2/scan
{ "q": "pe_ratio < 20 AND revenue_growth_yoy > 0.15 AND free_cash_flow > 0",
"order": "market_cap", "dir": "desc",
"columns": "ticker,market_cap,pe_ratio,revenue_ttm,gross_margin,dividend_yield" }
// → { "results": [ { "ticker": "GOOGL", "market_cap": …,
// "pe_ratio": 17.2, "revenue_ttm": …, "gross_margin": 0.61,
// "dividend_yield": 0.0024 }, … ] }Add ?asof= and the same screen answers with the fundamentals as they stood on any past day — the schema lists every statement item, ratio and flag by name.
Ready to wire it into something? Build a stock screener walks it end to end. Reference: the schema · the SQL surface · as-of queries.
questions
Over a hundred columns per ticker: income-statement, balance-sheet and cash-flow line items, valuation and efficiency ratios, TTM rollups and growth rates, share structure and float, insider and institutional ownership, short interest, and the dividend fields. The schema names every one — if it’s listed, it’s a column you can read and screen on.
Both, resolved into one row. Line items come from reported financials; ratios, TTM rollups and growth rates are computed from them server-side and kept current as new reports land. You read finished values — there’s no filing to parse and no ratio math to maintain.
Because every action it takes — an alert, a screen result, an order — is a condition over derived values: RSI below 30, price above the 200-day average, volume three times normal. Raw data doesn’t contain those. Something has to compute and refresh them for every symbol, continuously, and keep the history so past answers are reproducible. That’s a data pipeline, not a feature — you either build and operate it, or query one that already runs.
Every call here is also a native tool call: install the MCP server and Claude, ChatGPT, Cursor, or any MCP runtime queries the market directly. Computed state is what makes that work well: hand a model raw data and its context window fills with math to do; hand it computed answers and the context goes to decisions. A scan returns the tickers matching your condition: a list, not a workload.
The Free plan needs no card and carries the full data side: every ticker, every signal, real-time data, all-time history and as-of queries, at 10,000 calls a month and 60 a minute. Paid plans start at $29/mo, remove the monthly cap, and raise the rate limit; webhooks and streaming come with them. Data depth is never a tier lever: every plan sees the same table.
in the wild
What people are saying.
“dude. whoah.”
“Tickerbot is insane. It turns Claude into a quant.”
“Best value for hobbyists and advanced traders alike.”
get started
Free plan. Every ticker, every signal, real-time data, all-time history.