Every GOOGLEFINANCE attribute: the complete list
Every attribute the GOOGLEFINANCE function can pull — real-time, historical, and mutual-fund — in one place. Plus the honest part: the ~30 fundamentals it can't touch.
Free to start · no sign-up needed · real-time on every plan.
July 18, 2026 · 8 min read
How GOOGLEFINANCE attributes work
The syntax is =GOOGLEFINANCE(ticker, [attribute], [start], [end], [interval]). Only the ticker is required; leave the attribute out and you get price. There are four groups: real-time, historical, mutual-fund, and currency.
Real-time attributes (19)
These return current (well, ~15–20 minute delayed) data for a stock:
| Attribute | Returns |
|---|---|
price | Latest price — delayed up to 20 minutes |
priceopen | The day's opening price |
high | The day's high |
low | The day's low |
volume | Current day's trading volume |
marketcap | Market capitalization |
tradetime | Time of the last trade |
datadelay | How delayed the price data is |
volumeavg | Average daily trading volume |
pe | Price-to-earnings ratio |
eps | Earnings per share |
high52 | 52-week high |
low52 | 52-week low |
change | Price change since the previous close |
changepct | % change since the previous close |
closeyest | Previous day's closing price |
beta | Beta (volatility vs the market) |
shares | Shares outstanding |
currency | The security's trading currency |
That's the entire real-time set — 19 attributes, nothing more.
Historical attributes (6 — daily only)
Add a start date (and optionally an end date or number of days, plus DAILY or WEEKLY) to pull a series:
| Attribute | Returns |
|---|---|
open | Opening price for the date(s) |
close | Closing price for the date(s) |
high | High for the date(s) |
low | Low for the date(s) |
volume | Volume for the date(s) |
all | All of the above in one call |
The smallest interval is a day — there are no intraday (1-minute, 5-minute, hourly) bars.
Mutual-fund attributes (funds only)
Prefix a fund ticker with MUTF:and you get a different set — and notably, funds get return and income data that stocks don't:
closeyest, date, returnytd, netassets, change, changepct, yieldpct, returnday, return1, return4, return13, return52, return156, return260, incomedividend, incomedividenddate, capitalgain, morningstarrating, expenseratio.
Currency and crypto
For FX, use a currency pair like =GOOGLEFINANCE("CURRENCY:USDEUR"). Crypto works the same way (CURRENCY:BTCUSD) — but only for Bitcoin, Ethereum and a handful of top-10 coins. Most altcoins return an error, and there's no crypto history.
What about fundamentals? Only 8 — here's what's missing
This is the part most people don't realize. The only fundamentals GOOGLEFINANCE offers are the eight basic figures above: pe, eps, marketcap, high52, low52, beta, shares and volumeavg.
Everything a real research sheet wants is not available: revenue, net income, gross/operating/net margins, free cash flow, operating cash flow, total debt, total cash, enterprise value, EV/EBITDA, P/S, P/B, forward P/E, PEG, ROE, ROA, current ratio, revenue & earnings growth, book value, short interest, dividend yield/rate/ex-date, payout ratio, sector, analyst estimates, and the income statement, balance sheet and cash flow. None of it comes through GOOGLEFINANCE.
The other things GOOGLEFINANCE can't do
- No dividends for stocks — no yield, no ex-date, no history.
- Not real-time — ~15–20 min delayed, and it freezes when the sheet is closed.
- No options — no chains, strikes, implied volatility or Greeks.
- No intraday history — daily bars are the finest you get.
- No pre/after-market prices.
- No portfolio math — realized P&L, XIRR, vs the S&P, dividends received: you build all of it with formulas.
- Rate limits — sheets with hundreds of calls throw
#N/Aor crawl.
GOOGLEFINANCE is genuinely useful for a free, casual price list — but if you want real fundamentals, dividends, live prices, or portfolio numbers in a spreadsheet, you'll hit these walls fast. Stealth Quotes fills them: real-time prices, ~30 fundamentals from one lookup, dividends, and a built-in portfolio tracker — with no formulas. Type a ticker and it's there.
Keep reading
Frequently asked questions
What attributes does GOOGLEFINANCE support?
GOOGLEFINANCE supports 19 real-time attributes (price, priceopen, high, low, volume, marketcap, tradetime, datadelay, volumeavg, pe, eps, high52, low52, change, changepct, closeyest, beta, shares, currency), 6 historical attributes (open, close, high, low, volume, all — daily/weekly only), a set of mutual-fund attributes (returns, yield, expense ratio, etc.), plus currency pairs. That's the full list.
Can GOOGLEFINANCE pull fundamentals like revenue or margins?
No. The only fundamentals GOOGLEFINANCE offers are pe, eps, marketcap, high52, low52, beta, shares and volumeavg — 8 basic figures. It has no revenue, net income, margins, cash flow, debt, ROE, forward P/E, PEG, P/S, P/B, EV/EBITDA, growth rates, or financial statements.
Does GOOGLEFINANCE have dividend data?
Not for stocks. There is no dividend, yield, or ex-date attribute for equities — you have to enter or scrape those yourself. Mutual funds get some return/income data via their own attributes, but individual stocks don't.
What's the smallest GOOGLEFINANCE historical interval?
Daily. GOOGLEFINANCE historical data supports DAILY or WEEKLY intervals only — there are no 1-minute, 5-minute, or hourly bars.
Want the 30 fundamentals GOOGLEFINANCE is missing?
Real-time prices, ~30 fundamentals, dividends, and a portfolio tracker in a spreadsheet — no formulas. Free to start, no sign-up needed.