Developers / Field registry
Field registry
Every field, FRED series, spreadsheet mnemonic and Excel function the API serves, generated from the code that serves it. Each row names its source, the doors that carry it and a live count of its universe. The same list is available as GET /v1/fields and as the MCP tool field_search.
25 matches in Excel. 12 fields whose source terms do not permit redistribution are not listed.
| Field | Description | Type / unit | Source | Doors | Universe |
|---|---|---|---|---|---|
REGIMEExcel · function | KRESMION.REGIME Current Kresmion macro regime label, score, or conviction. | any | Kresmion regime engine | =KRESMION.REGIME(field) | |
SIGNALExcel · function | KRESMION.SIGNAL Latest Kresmion signal for a ticker. | any | Kresmion signal engine | =KRESMION.SIGNAL(ticker, field, days) | 7,968 symbols with a signal |
PRICEExcel · function | KRESMION.PRICE Live last-close price + day delta. | any | a market-data vendor | =KRESMION.PRICE(ticker, field) | |
FREDExcel · function | KRESMION.FRED Latest observation of a curated FRED macro series. Only the series this platform tracks are served. Use FREDH for a past observation. This product uses the FRED API but is not endorsed or certified by the Federal Reserve Bank of St. Louis. | any | FRED (Federal Reserve Bank of St. Louis) | =KRESMION.FRED(series_id, field) | 52 series |
WHALEExcel · function | KRESMION.WHALE Whale-transaction summary for a crypto asset (last 24h). | any | public blockchains (on-chain transfers) | =KRESMION.WHALE(asset, field) | 6 assets |
BISExcel · function | KRESMION.BIS BIS macro indicator for a country. | any | Bank for International Settlements | =KRESMION.BIS(country, indicator, field) | 39 countries |
FILINGExcel · function | KRESMION.FILING SEC filing metadata, or an extracted fundamental, for a company. Since Phase 556 the extractor resolves 36 metrics rather than 6; pass a metric name to read one, or "latest" for filing metadata. | any | SEC EDGAR | =KRESMION.FILING(ticker, metric, field) | 5,755 companies with extracted metrics |
OSINTExcel · function | KRESMION.OSINT OSINT event count matching a keyword (last hours). | any | open-source reports (third-party speech) | =KRESMION.OSINT(keyword, hours) | |
LIQUIDITYExcel · function | KRESMION.LIQUIDITY Fed net liquidity headline (balance sheet less reverse repo less the Treasury General Account, USD trillions). NETLIQ reaches the rest of the same dashboard. | any | FRED (Federal Reserve H.4.1, Treasury) | =KRESMION.LIQUIDITY(field) | |
ONCHAIN_RISKExcel · function | KRESMION.ONCHAIN_RISK On-chain composite risk score for a major asset (higher = more on-chain stress). | any | Kresmion composite over on-chain transfers | =KRESMION.ONCHAIN_RISK(asset, field) | |
SMARTMONEYExcel · function | KRESMION.SMARTMONEY Smart-money composite score for a ticker (signed −100..+100). | any | Kresmion composite over SEC filings | =KRESMION.SMARTMONEY(ticker) | 8,050 tickers |
CONFLUENCEExcel · function | KRESMION.CONFLUENCE Active cross-family confluence/divergence for a symbol. | any | Kresmion signal engine | =KRESMION.CONFLUENCE(symbol, field) | 1,253 compound signals |
HOLDERS13FExcel · function | KRESMION.HOLDERS13F Institutional 13F holders of a ticker at the latest quarter. | any | SEC EDGAR 13F | =KRESMION.HOLDERS13F(ticker, field) | 9,296 tickers |
SHORTINTERESTExcel · function | KRESMION.SHORTINTEREST Short interest as a percentage of FLOAT. Lower bound, and unavailable for most tickers - a blank is UNKNOWN, never zero. Use "pctshares" for the different percentage of shares outstanding. Source: FINRA. Short interest data owned by FINRA. | any | FINRA consolidated short interest | =KRESMION.SHORTINTEREST(ticker, field) | 7,635 tickers |
TRACKRECORDExcel · function | KRESMION.TRACKRECORD Median forward return (%) for a signal type at a horizon. | any | Kresmion published track record | =KRESMION.TRACKRECORD(signalType, horizon) | 54 signal types |
FUNDINGExcel · function | KRESMION.FUNDING Latest per-interval perp funding rate (%) for a crypto symbol. | any | exchange public APIs (Binance, Bybit, OKX, Hyperliquid) | =KRESMION.FUNDING(symbol) | 33 symbols |
CBRATEExcel · function | KRESMION.CBRATE Central bank policy rate for a country. A rate whose source stopped publishing is WITHHELD rather than served stale, so the cell shows a reason instead of an old number. Source: BIS, superseded by a faster official source where one exists. The BIS must be cited as the source of its statistics. | any | BIS policy rates and central bank sites | =KRESMION.CBRATE(country, field) | 38 central banks |
YIELDExcel · function | KRESMION.YIELD One tenor of the US Treasury constant-maturity curve, today or on a past date. The date is RESOLVED to the last session on or before it, so a weekend answers with the prior print; ask for tenor "AS_OF" to see which. A tenor missing on that session returns a reason, never an interpolated value. | any | Federal Reserve H.15 via FRED | =KRESMION.YIELD(tenor, date) | |
MMRATEExcel · function | KRESMION.MMRATE A US money-market rate with the Fed's corridor around it. Administered rates are dated by their EFFECTIVE day and run ahead of the market rates; the corridor position is not clamped; the Treasury bill rows are quoted on a DISCOUNT basis, below the investment-basis yield for the same bill. | any | FRED and the New York Fed | =KRESMION.MMRATE(key, field) | 6 rates |
NETLIQExcel · function | KRESMION.NETLIQ Fed net liquidity and the blocks around it. Net liquidity is a CONVENTION (balance sheet less reverse repo less the Treasury General Account), not a published series. Cadences differ, so a block only moved if its own date moved. | any | FRED (Federal Reserve H.4.1, Treasury) | =KRESMION.NETLIQ(field) | |
FREDHExcel · function | KRESMION.FREDH ONE historical observation of ONE curated FRED series. There is no array history function: this engine is scalar-per-cell with no spill, so build a series by filling a column of dates. Only the series this platform tracks are served; any other id returns a reason. This product uses the FRED API but is not endorsed or certified by the Federal Reserve Bank of St. Louis. | any | FRED (Federal Reserve Bank of St. Louis) | =KRESMION.FREDH(series_id, date, field) | 52 series |
RVExcel · function | KRESMION.RV One relative-value metric for a company against its peer group. A REFUSED CELL RETURNS THE REASON AS TEXT, NEVER 0. Every fundamental is a full fiscal year off one annual filing, nothing is trailing twelve months, and values are in the filer's own reporting currency with nothing converted. A percentile is a position in a population, not a rating. | any | SEC EDGAR XBRL; prices from a market-data vendor | =KRESMION.RV(ticker, metric, field) | |
IPOExcel · function | KRESMION.IPO The newest EDGAR offering filing matching a ticker or company name. One row is one FILING, not one deal. A null is a figure the document did not state, never a zero, so those cells show a reason. A price range stays a range: ask for price_low and price_high, never a midpoint. First-day performance is not available here. | any | SEC EDGAR | =KRESMION.IPO(query, field) | 404 offering filings |
ESIExcel · function | KRESMION.ESI Economic Surprise Index: how data is landing against consensus. POSITIVE MEANS DATA IS BEATING EXPECTATIONS, not that the economy is strong. Read "count" beside the value: a spike on a thin day is a small sample. The per-event economic calendar behind the index is not available through this add-in. | any | Kresmion economic surprise index | =KRESMION.ESI(field) | |
FINExcel · function | KRESMION.FIN One line of a company's standardised financial statements, the same number as its Financials tab and the web sheet's KRM.FIN. In the filer's reported currency, not converted (item "currency" names it). A blank statement cell returns n/a, never 0. | any | SEC EDGAR XBRL | =KRESMION.FIN(ticker, item, period) | 5,755 companies with extracted metrics |
Universe counts are computed against the table each field is read from and refresh every 15 minutes. Bulk row counts are the database planner's estimate. Metadata only; information, not investment advice.