Guides
Tracking stocks, crypto, dividends and your portfolio in a spreadsheet — the honest limits of the old formula way, and what actually works.
How to Track Dividends in a Spreadsheet (2026)
Google Sheets is the classic place to track a dividend portfolio — until you hit GOOGLEFINANCE's wall: it has no dividend attribute. Here's what actually works.
July 5, 2026 · 6 min read
Why Your Bitcoin (or Crypto) Price Isn't Working in Google Sheets
You typed a crypto ticker into GOOGLEFINANCE and got #N/A or 'no data.' You're not doing it wrong — GOOGLEFINANCE just barely supports crypto. Here's the fix.
July 5, 2026 · 5 min read
7 Discreet Ways to Check Stocks at Work
Following the market during the day is fine; broadcasting it isn't. Seven low-key ways to glance at your stocks and crypto at work without drawing eyes.
July 5, 2026 · 5 min read
How to Fix GOOGLEFINANCE #N/A and 'No Data' Errors
GOOGLEFINANCE throws #N/A more than any other Sheets function. Usually it's one of a handful of causes — here's how to fix each, and when it's a dead end.
July 5, 2026 · 6 min read
How to Track a Stock Portfolio in a Spreadsheet
A spreadsheet is the classic portfolio tracker. Here's what to track, the formulas that get you there, where GOOGLEFINANCE runs out of road, and the no-formula alternative.
July 5, 2026 · 7 min read
Is GOOGLEFINANCE Real-Time? The 20-Minute Delay, Explained
Wondered why your Google Sheets prices lag the market? You're right: GOOGLEFINANCE is delayed 15-20 minutes. Here's why — and how to get live prices instead.
July 5, 2026 · 5 min read