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.

FieldDescriptionType / unitSourceDoorsUniverse
REGIME
Excel · function
KRESMION.REGIME
Current Kresmion macro regime label, score, or conviction.
anyKresmion regime engine
=KRESMION.REGIME(field)
SIGNAL
Excel · function
KRESMION.SIGNAL
Latest Kresmion signal for a ticker.
anyKresmion signal engine
=KRESMION.SIGNAL(ticker, field, days)
7,968 symbols with a signal
PRICE
Excel · function
KRESMION.PRICE
Live last-close price + day delta.
anya market-data vendor
=KRESMION.PRICE(ticker, field)
FRED
Excel · 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.
anyFRED (Federal Reserve Bank of St. Louis)
=KRESMION.FRED(series_id, field)
52 series
WHALE
Excel · function
KRESMION.WHALE
Whale-transaction summary for a crypto asset (last 24h).
anypublic blockchains (on-chain transfers)
=KRESMION.WHALE(asset, field)
6 assets
BIS
Excel · function
KRESMION.BIS
BIS macro indicator for a country.
anyBank for International Settlements
=KRESMION.BIS(country, indicator, field)
39 countries
FILING
Excel · 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.
anySEC EDGAR
=KRESMION.FILING(ticker, metric, field)
5,755 companies with extracted metrics
OSINT
Excel · function
KRESMION.OSINT
OSINT event count matching a keyword (last hours).
anyopen-source reports (third-party speech)
=KRESMION.OSINT(keyword, hours)
LIQUIDITY
Excel · 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.
anyFRED (Federal Reserve H.4.1, Treasury)
=KRESMION.LIQUIDITY(field)
ONCHAIN_RISK
Excel · function
KRESMION.ONCHAIN_RISK
On-chain composite risk score for a major asset (higher = more on-chain stress).
anyKresmion composite over on-chain transfers
=KRESMION.ONCHAIN_RISK(asset, field)
SMARTMONEY
Excel · function
KRESMION.SMARTMONEY
Smart-money composite score for a ticker (signed −100..+100).
anyKresmion composite over SEC filings
=KRESMION.SMARTMONEY(ticker)
8,050 tickers
CONFLUENCE
Excel · function
KRESMION.CONFLUENCE
Active cross-family confluence/divergence for a symbol.
anyKresmion signal engine
=KRESMION.CONFLUENCE(symbol, field)
1,253 compound signals
HOLDERS13F
Excel · function
KRESMION.HOLDERS13F
Institutional 13F holders of a ticker at the latest quarter.
anySEC EDGAR 13F
=KRESMION.HOLDERS13F(ticker, field)
9,296 tickers
SHORTINTEREST
Excel · 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.
anyFINRA consolidated short interest
=KRESMION.SHORTINTEREST(ticker, field)
7,635 tickers
TRACKRECORD
Excel · function
KRESMION.TRACKRECORD
Median forward return (%) for a signal type at a horizon.
anyKresmion published track record
=KRESMION.TRACKRECORD(signalType, horizon)
54 signal types
FUNDING
Excel · function
KRESMION.FUNDING
Latest per-interval perp funding rate (%) for a crypto symbol.
anyexchange public APIs (Binance, Bybit, OKX, Hyperliquid)
=KRESMION.FUNDING(symbol)
33 symbols
CBRATE
Excel · 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.
anyBIS policy rates and central bank sites
=KRESMION.CBRATE(country, field)
38 central banks
YIELD
Excel · 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.
anyFederal Reserve H.15 via FRED
=KRESMION.YIELD(tenor, date)
MMRATE
Excel · 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.
anyFRED and the New York Fed
=KRESMION.MMRATE(key, field)
6 rates
NETLIQ
Excel · 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.
anyFRED (Federal Reserve H.4.1, Treasury)
=KRESMION.NETLIQ(field)
FREDH
Excel · 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.
anyFRED (Federal Reserve Bank of St. Louis)
=KRESMION.FREDH(series_id, date, field)
52 series
RV
Excel · 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.
anySEC EDGAR XBRL; prices from a market-data vendor
=KRESMION.RV(ticker, metric, field)
IPO
Excel · 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.
anySEC EDGAR
=KRESMION.IPO(query, field)
404 offering filings
ESI
Excel · 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.
anyKresmion economic surprise index
=KRESMION.ESI(field)
FIN
Excel · 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.
anySEC 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.

Field registry | Kresmion API