GOOGLEFINANCE stuck on “Loading...”?
Cells that say Loading... or Getting dataand never finish usually aren't broken — Google is throttling them. Here's why it hangs, and how to fix each cause.
Free · no sign-up needed · real-time on every plan.
September 12, 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 have too many GOOGLEFINANCE calls (the #1 cause)
GOOGLEFINANCE isn't built for hundreds of live cells. When a sheet fills with calls — a big watchlist, a value column, a change column — Google rate-limits them and the extras sit on Loading... until earlier ones clear. Trim the number of calls, or consolidate (one price per row instead of five attributes) and the hang usually clears.
2. Historical (date-range) queries are far heavier
A single price is light; a historical query like =GOOGLEFINANCE("AAPL","close",DATE(2024,1,1),TODAY()) pulls a whole series and is many times heavier. A few dozen of those in one sheet can hang it on their own. Keep historical pulls to a single scratch tab, not sprinkled across the workbook.
3. A recalculation storm
If your recalculation setting is On change and every minute and the sheet also has volatile formulas (NOW(), RAND(), big ARRAYFORMULAs), every tick re-runs every GOOGLEFINANCE call at once — which triggers the throttling above. Set calculation back to On change (File → Settings → Calculation) and let it settle.
4. It's a temporary Google-side hiccup
Sometimes the data service is just slow or briefly down, and every sheet on the internet shows Loading...at once. There's nothing to fix on your end — wait a few minutes and reload. If a single cell is stuck while others work, re-enter that cell to nudge it.
Why it hangs at all — and how to skip it
Every fix above is really the same fix: fewer, lighter calls. That's because GOOGLEFINANCE works by having your sheet ask Google for each value on every recalculation — so more cells means more requests, and past a point they queue up as Loading....
The other approach is to have the price pushed to you. Stealth Quotes streams each quote from a server straight into the cell — there's no formula recalculating, nothing to throttle, and no Loading... state. A hundred tickers load the same as one.
Tired of watching cells load? Type a ticker and the price is just there — a hundred at once, no formulas to throttle. Free, no sign-up.
Try it free →Keep reading
Frequently asked questions
Why is GOOGLEFINANCE stuck on "Loading..."?
Almost always throttling. When a sheet has many GOOGLEFINANCE calls — especially historical (date-range) ones — Google rate-limits them and the cells sit on "Loading..." until they clear. A recalculation storm, a volatile array formula, or a temporary Google outage can do the same.
How many GOOGLEFINANCE formulas is too many?
There's no published cap, but hundreds of live calls in one sheet routinely trigger throttling. Historical queries are much heavier than a single price, so even a few dozen of those can hang a sheet.
How do I force GOOGLEFINANCE to reload?
Re-enter the cell, or toggle the spreadsheet's recalculation setting (File → Settings → Calculation). But if the cause is too many calls, forcing a recalc just restarts the throttling — the fix is fewer calls, not more refreshing.
Is there a way to get prices that never hang?
Yes — a server-streamed tool like Stealth Quotes pushes each price to the cell instead of recalculating a formula, so there's nothing to throttle and no "Loading..." state. You type a ticker and the price is just there.
No formulas means nothing to load.
Type a ticker, get a real-time price — a whole watchlist at once, no throttling, no spinner. Stocks and crypto. Free, no sign-up.