How to track dividends in a spreadsheet
A spreadsheet is the natural home for a dividend portfolio — until you reach for GOOGLEFINANCE and hit a wall: it has no dividend data. Here's what breaks, the formulas people try, and the no-formula way that just works.
Free to start · no sign-up needed · real-time on every plan.
July 5, 2026 · 6 min read
If you invest for dividends, you want to see a few things at a glance: how much income you're collecting, your yield on cost, and when the next payment lands. A spreadsheet feels like the obvious tool — rows for holdings, columns for the numbers. For prices, Google Sheets' GOOGLEFINANCE function does the job. But dividends are where the DIY spreadsheet quietly falls apart.
Can GOOGLEFINANCE track dividends?
No — it has no dividend attribute. You can pull a live price with =GOOGLEFINANCE("AAPL","price"), but there is no "dividend" or "dividendyield"attribute that returns a stock's payout. So the one function that makes Google Sheets useful for stocks doesn't cover the thing a dividend investor cares about most.
The IMPORTXML workaround — and why it breaks
The common workaround is to scrape a dividend number off another website with IMPORTXML or IMPORTHTML — pointing a formula at a page on Yahoo Finance or StockAnalysis and grabbing the yield from a specific spot on the page.
It can work… until it doesn't. These scrapes break constantly: the moment the source site changes its layout (which they do), your formula returns #N/A or the wrong cell. You end up maintaining brittle formulas instead of tracking your portfolio. And even when it works, it only gives you a currentyield — not the dividends you've actually received over time.
What should a dividend tracker actually show?
A real dividend tracker goes beyond a single yield number. Four things worth seeing:
- Dividends received— the income you've actually collected, based on how many shares you held at each payment.
- Yield on cost (YoC) — annual dividend per share ÷ your average cost. The yield on what you paid, which grows as companies raise their dividends.
- Estimated annual income — forward dividend × your shares.
- Next ex-dividend date — the cutoff for the next payment.
GOOGLEFINANCE gives you none of these.
How do I calculate dividend yield & yield on cost in a spreadsheet?
If you go the manual route, the formulas themselves are simple:
- Dividend yield = annual dividend per share ÷ current price
- Yield on cost = annual dividend per share ÷ your average cost
- Annual income = annual dividend per share × shares held
The hard part isn't the arithmetic — it's getting annual dividend per sharereliably, because GOOGLEFINANCE won't give it to you and scrapes break. You spend your time babysitting data sources instead of investing.
The no-formula way
Stealth Quotes is a spreadsheet-style tracker built for exactly this. Enter your shares (or log your buys and sells) and it computes the dividend numbers for you — dividends received, yield on cost, estimated annual income, and the next ex-date — natively, with no formulas and nothing to scrape.
It looks like an ordinary spreadsheet; the dividend columns are simply there when you want them. Stocks and crypto share one grid, and prices are real-time — not the 15–20 minute delay GOOGLEFINANCE serves.
| GOOGLEFINANCE | IMPORTXML scrape | Stealth Quotes | |
|---|---|---|---|
| Dividend / yield data | |||
| Dividends received (auto) | |||
| Yield on cost | |||
| Next ex-dividend date | |||
| No formulas or scraping to maintain |
Keep reading
Frequently asked questions
Can Google Sheets track dividends automatically?
Not with GOOGLEFINANCE — it has no dividend attribute, so it can't return a stock's dividend or dividend yield. You'd have to scrape the number off another website with IMPORTXML (fragile and prone to breaking), or use a tool that has dividend data built in.
Does GOOGLEFINANCE have a dividend yield attribute?
No. GOOGLEFINANCE supports attributes like price, priceopen, high, low, volume, marketcap and pe — but there is no attribute for dividends or dividend yield.
How do I calculate yield on cost in a spreadsheet?
Yield on cost = annual dividend per share ÷ your average cost per share. The arithmetic is easy; the hard part is getting the annual dividend per share reliably, since GOOGLEFINANCE won't provide it.
What is the ex-dividend date?
The cutoff date to own a stock in order to receive its next dividend. If you buy on or after the ex-dividend date, you miss that payment.
Is Stealth Quotes free?
Yes — the full portfolio tracker, including dividends received, yield on cost and next ex-date, is free on every plan, and there's no sign-up needed to try it.
Track your dividends without the formulas.
See dividends received, yield on cost, and your next ex-date — free, no sign-up needed.