Spreadsheet stock tracking: how to track stocks in a spreadsheet
A spreadsheet is the calmest way to watch a list of stocks — no ads, no noise, just your names and their prices. Here are the four real ways to get prices into one, and honestly when each makes sense.
Free to start · no sign-up needed · real-time on every plan.
July 18, 2026 · 6 min read
How do you track stocks in a spreadsheet?
The shape is always the same: put your tickers in column A, and pull each stock's price into column B. What differs is how you get that price — and that choice decides whether it's real-time or delayed, free or paid, and full of formulas or none.
There are four realistic ways to do it:
Option 1 — GOOGLEFINANCE (free, but 20 minutes behind)
In Google Sheets, =GOOGLEFINANCE("AAPL") pulls a price for free. It's the default and it works — with two catches. The price is exchange-delayed by ~15-20 minutes, and it only updates while the sheet is open. Crypto support is limited to a handful of major coins, and there's no dividends or portfolio math — you build all of that with more formulas.
Best for: a free, slow-glance watchlist where a 20-minute lag doesn't matter.
Option 2 — Excel STOCKHISTORY / the Stocks data type
Excel (Microsoft 365) has STOCKHISTORYand the linked "Stocks" data type. Same idea as GOOGLEFINANCE, and also delayed — STOCKHISTORY is often end-of-day rather than intraday, and crypto coverage is thin. Fine for a static tracker you refresh now and then, less so for watching prices move.
Option 3 — a paid Sheets add-on
Add-ons like Finsheet or Wisesheets can stream real-time prices into Google Sheets. The catch: the tiers that actually do real-time run around $45/month, you install an extension and grant permissions, and you're still writing functions to assemble a tracker.
Best for: power users who already live in Sheets and want real-time data feeding their own formulas.
Option 4 — a live spreadsheet with no formulas
The last option skips the function entirely: a tool that looks and works like a spreadsheet, but fills the prices in for you. Stealth Quotes is exactly that — type a ticker in column A and the real-timeprice appears, for US stocks and crypto, with no GOOGLEFINANCE, no formulas, and nothing to install. It keeps a built-in portfolio tracker too (cost basis, gains, dividends), and it's free to start.
Best for: anyone who wants the calm of a spreadsheet with prices that are actually current — without paying $45/mo or writing a single formula.
So which should you use?
If a 15-20 minute delay is fine and you like tinkering with formulas, GOOGLEFINANCE is free and does the job. If you need prices that are actually current, it comes down to a paid add-on (real-time, but formulas + a monthly bill) or a no-formula live spreadsheet. For most people who just want to glance at a watchlist and see the real number, the no-formula route is the least fuss.
Tracking a portfolio (shares, cost basis, realized P&L, dividends) is a related but bigger job — a spreadsheet can do it, with a lot of formulas. See the guide below for that.
Keep reading
Frequently asked questions
How do you track stocks in a spreadsheet?
Put your tickers in one column and pull each stock's price into the next. In Google Sheets that's the GOOGLEFINANCE function; in Excel it's STOCKHISTORY or the Stocks data type. Both are free but delayed ~15-20 minutes. For real-time prices you either add a paid Sheets add-on (and still write formulas), or use a live spreadsheet tool like Stealth Quotes where you just type a ticker.
Can you get real-time stock prices in a spreadsheet?
Not for free with the built-in functions — GOOGLEFINANCE and Excel's STOCKHISTORY are delayed. Real-time options are paid Sheets add-ons (roughly $45/mo for the tiers that actually stream) or Stealth Quotes, which is real-time and free to start, with no formulas.
Is Google Sheets good for tracking stocks?
It's great for a calm, custom watchlist and it's free — but the prices are ~15-20 minutes behind, crypto support is thin, and there's no built-in dividends or portfolio analytics. You build all of that with formulas yourself.
How do I track stocks without formulas?
Use a tool that fills prices in for you instead of a function. Stealth Quotes looks and works like a spreadsheet, but you type a ticker in column A and the live price appears — no GOOGLEFINANCE, no formulas, no add-on.
Track your stocks in a spreadsheet — live, no formulas.
Type a ticker, see the real-time price. Stocks and crypto, free to start, no sign-up needed.