Excel and Google Sheets
FinzData for Excel and Google Sheets
Point-in-time market data, straight into the cells you already work in. One formula, the same in Excel and in Google Sheets: prices, dealer gamma, macro vintages, positioning and fundamentals, refreshed from FinzData. Launching soon, free with a FinzData account. Create your free account today and you will be first to get it.
Five formulas, everything you need
=FINZ_BARS(symbol, start, end, bar)— 1, 5, 15, 30-minute, hourly and daily bars for 16,000+ US stocks that have traded on NYSE and Nasdaq since January 2000, delisted included, point in time; 231 ETFs; 139 futures markets with every contract since 2007; crypto since 2015.=FINZ_GEX(symbol, date)— point-in-time dealer gamma for single stocks, ETFs and the major indexes: gamma flip, net, call and put gamma, call and put walls, open interest and put/call ratio, at-the-money implied volatility.=FINZ_MACRO(series, start, end, vintage)— 18,000+ macro series with every vintage kept, so you see the number as it was first published.=FINZ_COT(market, start, end)— CFTC Commitments of Traders since 1986.=FINZ_FUND(symbol, field, as_of)— SEC fundamentals as filed, point in time.
Type symbols the way you already do
FinzData reads three symbol styles and tells you clearly when a symbol is ambiguous, never a guess:
- FinzData symbols:
AAPL,SPY,/ES - Terminal-style tickers:
AAPL US Equity,SPX Index - RIC-style codes:
AAPL.O,.SPX
Built for analysts, quants and AI workflows
Spreadsheets are where models are checked, shared and presented. FinzData brings clean, point-in-time data into them, so the numbers you show reflect what was knowable on each date — no survivorship bias, no restated history passed off as the original. Your results reflect the truth.
Free with a FinzData account
The add-in for Excel and the add-on for Google Sheets will be free with a FinzData account. Free accounts get the last 12 months of daily US stock bars, COT, SEC fundamentals, US macro series and 13F ownership, plus the last 30 days of futures and daily GEX. Need more history? Buy it once and keep it: $19 a ticker, or $195 for 5 years of the whole US market. See the shop.
Create your free FinzData account to be first to get FinzData for Excel and Google Sheets.
Frequently asked questions
When will FinzData for Excel and Google Sheets be available?
Both are in final build and testing now. Free FinzData account holders get them first, and this page will carry the install steps the day they launch.
Is it free?
Yes. The add-in and the add-on are free with a FinzData account. Data follows the usual FinzData plans: free tier included, longer history bought once and kept.
Do the same formulas work in Excel and Google Sheets?
Yes. The five FINZ_ formulas have the same names and arguments in both, so a workbook moves between them.
Which symbols can I type?
FinzData symbols such as AAPL or /ES, Terminal-style tickers such as AAPL US Equity, and RIC-style codes such as AAPL.O.
Is the data point in time?
Yes. Prices include delisted names, fundamentals are as filed, and macro series keep every vintage, so each value is what was knowable on that date.