GOOGLEFINANCE won't pull the S&P 500?
Indexes don't use ticker names in GOOGLEFINANCE — they use dotted codes like .INX. Here's the right symbol for each, the ETF workaround, and a no-formula way to track them live.
Free · no sign-up needed · real-time on every plan.
September 14, 2026 · 5 min read
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SYMBOL | NAME | PRICE | Δ% |
| 2 | Apple Inc. | … | ||
| 3 | Bitcoin | … | ||
| 4 |
Those are real, live prices — no formula, no sign-up. Edit any ticker, or type one in the empty row (stocks or for crypto).
Open the full sheet →1. You're using the wrong symbol (the #1 cause)
Indexes have special codes, not ticker names. Use these:
- S&P 500 —
=GOOGLEFINANCE(".INX") - Dow Jones —
=GOOGLEFINANCE(".DJI") - Nasdaq Composite —
=GOOGLEFINANCE(".IXIC")
Typing SPX, SP500, or "S&P 500" returns #N/A— those simply aren't the symbols it knows.
2. Even the right code is limited
The dotted codes get you the level, but index coverage in GOOGLEFINANCE is thinner than for stocks — some attributes (like changepct or historical intervals) can return #N/A or behave oddly for indexes even when price works.
3. The reliable workaround: track the ETF
Most people don't need the index itself — they want to know how the market is doing. The tracking ETFs are ordinary tickers that behave far more reliably:
SPY→ S&P 500DIA→ Dow JonesQQQ→ Nasdaq-100
They're still exchange-delayed in GOOGLEFINANCE, but at least they resolve every time.
Or skip the codes and the delay entirely
Between remembering .INX, dodging #N/A, and the 15–20 minute delay, tracking “the market” in GOOGLEFINANCE is more fiddly than it should be.
In Stealth Quotes you just type SPY, QQQ, or any ticker and the live price streams into the cell in real time — no dotted codes, no formula, and no delay. Add a few index ETFs and you've got a live market dashboard in one sheet.
Want the market at a glance without the .INX guessing game? Type SPY or QQQ and watch it stream live — no formula, no delay. Free, no sign-up.
Try it free →Keep reading
Frequently asked questions
What's the GOOGLEFINANCE symbol for the S&P 500?
Use ".INX" — =GOOGLEFINANCE(".INX"). Typing "SPX", "SP500", or "S&P 500" returns #N/A because those aren't the symbols GOOGLEFINANCE recognizes. The Dow is ".DJI" and the Nasdaq Composite is ".IXIC".
Why does GOOGLEFINANCE return #N/A for an index?
Almost always the wrong symbol — indexes use a dotted code (.INX, .DJI, .IXIC), not the ticker-style names people expect. Even with the right code, index coverage is limited and some data (like intraday change) can be spotty.
Can I track an index with an ETF instead?
Yes, and it's usually more reliable. SPY tracks the S&P 500, DIA the Dow, and QQQ the Nasdaq-100. These are normal tickers GOOGLEFINANCE handles well — and any real-time tool can stream them.
How do I get a live index or ETF price in a spreadsheet?
Track the ETF in a tool that streams real-time prices. In Stealth Quotes you type SPY, DIA, or QQQ and the live price appears in the cell — no formula, no dotted index code to remember.
Track the whole market, live.
Type SPY, DIA, QQQ — or any ticker — and get a real-time price in the cell. No dotted codes, no formulas, no delay. Free, no sign-up.