It starts with a hunch.

You have been investing for months – maybe years.

You check your portfolio and see green.

The numbers are up. Feels good.

But then the question creeps in:

“Am I actually making money? Or am I just watching prices bounce around?”

You dive deeper.

You realize the price alone is lying to you.

It doesn't tell the full story: dividends, reinvestments, splits, taxes.

You're missing layers of performance that no broker dashboard shows.

Not unless you're paying. Not unless you're trained to see it.

This is the moment when smart investors separate from the crowd.

Because total return (not just price return) is what tells you the truth.

It’s what shows you the real compounding.

It’s what lets you compare apples to apples, portfolio to index, fact to fiction.

And you don't need Bloomberg. You don’t need Excel mastery or a subscription that costs more than your rent.

All you need is Google Sheets. And the right approach.

In this guide, we are going to show you exactly how to do a full total return analysis using nothing but Google Sheets and a free tool that makes it fast, clean, and automatic.

What is Total Return Analysis?

Total return is the real return.

It’s not just the rise and fall of a stock’s price…

It’s everything that stock gives back to you:

• Capital gains when the price climbs.
• Dividends that drop into your account, quarter after quarter.
• And sometimes even hidden benefits like stock splits or spin-offs.

Learn how capital gains yield fits into the total return puzzle here.

Price tells you one thing. Total return tells you the truth.

The problem is, most people don't track it.

They see a stock go from $50 to $60 and think, “Cool. That’s 20%.”

But if that stock also paid $2 in dividends along the way, they’re leaving 4% on the table.

This guide explains how to use Google Finance to find and interpret dividend yield.

Multiply that across a portfolio, over years, and suddenly, the numbers you trusted don’t tell the whole story.

And don’t even get started on reinvested dividends. That’s compounding on top of compounding, and it’s invisible unless you’re looking for it.

Total return analysis is the difference between thinking you’re winning and actually knowing it.

And in a game where inches compound into miles, knowing the full picture is essential.

Why Use Google Sheets for Total Return Analysis?

Because sometimes, the best tool is the one you already have open.

Google Sheets is deceptively powerful.

It’s not flashy. It won’t wow you with animated dashboards or slick UI.

But what it lacks in flair, it makes up for in freedom.

You want to track dividend-adjusted performance for 12 stocks across 5 years?

You can.

You want to build your own formulas, tweak layouts, add notes, run what-if scenarios?

Go for it.

There are no gates. No locked features.

No paywalls hidden behind buttons that say “Upgrade to Pro.”

And if you’ve ever used a spreadsheet before, you’re already halfway there.

The interface is familiar, intuitive, and built for customization.

No need to learn a new platform just to analyze your own portfolio.

Plus, it plays nicely with tools like GoogleFinance for pulling basic price data.

The Limits of GoogleFinance

For all its convenience, the GOOGLEFINANCE function has one fatal flaw:

It doesn’t tell the whole story.

Sure, it’ll give you price data – current, historical, even basic metrics like market cap or P/E ratio.

But when it comes to dividends – nothing.

Stock splits? Nope.

Total return over time? Forget it.

To understand what Google Finance can and can’t do inside Sheets, check out this detailed breakdown.

That means if you're relying solely on GOOGLEFINANCE, you're only seeing part of your portfolio’s performance.

It’s like watching a movie with half the scenes missing:

Looks fine on the surface, but you have no idea what’s really going on.

Can you patch those holes manually?

Yes, technically.

You could pull dividend data from Yahoo Finance, scrape websites with IMPORTXML, or tap into APIs (if you know how to write queries and handle data formatting).

But now you're in the weeds.

And unless you're into data engineering on your weekends, that gets old fast.

Introducing Wisesheets: A Smarter Way to Analyze Total Return

This is the fix.

Wisesheets is a lightweight yet powerful Google Sheets add-on built specifically for investors who want more than just price charts and basic data.

It gives you the missing pieces that are crucial when you're measuring real performance.

With Wisesheets, you can pull in:

• Full dividend histories for thousands of stocks and ETFs
• Split data that automatically adjusts your price calculations
• Historical prices and even earnings data, all formatted and ready to use
• Total return inputs without needing to touch a single external site

Want to go further? Try this dividend stock screener to find high-yield stocks worth analyzing.

And it’s all done inside your spreadsheet.

For investors who care about accuracy (and who don’t want to burn hours wrangling data) Wisesheets turns Google Sheets into a fully-fledged total return analysis engine.

Step-by-Step: How to Do Free Total Return Analysis in Google Sheets Using Wisesheets

You don’t need to be a spreadsheet wizard to get this right.

Here’s how to build a clean, automated total return analysis – start to finish – with nothing but Google Sheets and Wisesheets.

Step 1: Set Up Your Google Sheet

First things first – open a fresh Google Sheet or use your existing investment tracker.

Then, install the Wisesheets add-on from the Google Workspace Marketplace.

Once installed, you’ll see a Wisesheets tab appear in your Google Sheets menu bar.

Step 2: Get Historical Price Data

With Wisesheets, pulling historical prices is dead simple.

Just use the WISE function.

Example:

=WISEPRICE("AAPL"; "Close";, "2020-01-01", "2023-12-31")

This fetches the adjusted closing prices for Apple from 2020 through 2023, automatically factoring in stock splits.

Step 3: Add Dividend Data

To grab dividend history, use the same WISE function:

=WISE("AAPL"; "Dividends Paid"; {2020,2021,2022,2023})

Need something prebuilt? Here’s a free dividend tracker spreadsheet for Google Sheets and Excel.

This pulls a clean list of all the total yearly dividend payments for AAPL.

Step 4: Calculate Total Return

Now, it’s time to put the pieces together.

A simple total return formula might look like this:

=((End Value + Total Dividends – Start Value) / Start Value) * 100

Want to get fancy? You can also calculate CAGR (Compound Annual Growth Rate) like this:

=(((End Value + Dividends) / Start Value)^(1/Years)) – 1

This shows your actual return. Not just what the price did, but what the stock paid you along the way.

Step 5: Automate and Update

Wisesheets data is dynamic.

That means your sheet can update automatically. Simply hit the 'Refresh' button and get the latest dividend or price info.

You can also:

• Copy prebuilt Wisesheets templates
• Customize them for your portfolio
• Share them with others, or keep them private

Use Case: How Wisesheets Helped a DIY Investor Improve Portfolio Tracking

The following story is fictional but based on common experiences shared by real investors.

Meet James.

Mid-thirties. Works in tech. Likes his coffee black and his spreadsheets tidy.

He’s been investing for a few years now – mostly dividend stocks and ETFs.

Nothing too wild. Just slow and steady wealth-building.

But something kept bugging him.

Every month, he’d open his Google Sheet and update prices using GOOGLEFINANCE.

He tracked gains. Watched the green numbers climb.

But he couldn’t shake the feeling that something was… missing.

“I know I’ve gotten paid dividends,” he thought, scrolling through old broker emails. “Where is that reflected? What’s my actual return?”

If dividends are a big part of your portfolio, this guide will help you track them like a pro.

So, he tried to fix it. Pulled dividend data manually. Created extra tabs. Tried importing CSVs from Yahoo.

His sheet turned into a labyrinth of formulas, half-working scripts, and broken links.

That’s when he found Wisesheets.

He installed the add-on, ran the WISE function, and within minutes had:

• Clean and up-to-date dividend history for every stock in his portfolio
• Adjusted closing prices that accounted for splits
• A simple total return column that actually made sense

Before Wisesheets:

• His sheet was a mess.
• His numbers were incomplete.
• His “returns” were missing half the story.

After Wisesheets:

• One sheet.
• Clean formulas.
• True performance finally visible.

Now, James checks his sheet once a week, updates with a click, and knows exactly what’s working in his portfolio (and what's just taking up space).

If you want a hands-off way to track your holdings, this Google Finance watchlist template can help.

Frequently Asked Questions (FAQs) About Total Return Analysis in Google Sheets

Can I do this without Wisesheets?

Technically, yes. But it's not pretty.

You’d need to manually pull dividend data (often scattered or buried), account for stock splits yourself, and stitch together total return formulas from multiple sources.

It’s doable, but it’s time-consuming, error-prone, and frankly, unnecessary when Wisesheets automates all of it in one formula.

---

What if I invest in ETFs or mutual funds?

Wisesheets works with most U.S. and Canadian ETFs and stocks. For mutual funds, support may vary depending on the provider and data availability.

That said, if your assets pay dividends and have historical price data, total return tracking is usually possible (you might just need to test a few tickers).

---

How accurate is this method?

Very.

Wisesheets pulls data directly from reputable sources and formats it in a way that minimizes human error.

As long as your formulas reference the right cells, and your tickers are correct, your total return numbers will be as accurate as the source data itself, and often better than what you’ll find on free finance sites.

---

How often should I update the data?

It depends on how closely you monitor your investments. Some users refresh weekly, others monthly.

With Wisesheets, refreshing data is just a click. So, if you're a hands-on investor, updating weekly makes sense.

Long-term holders can do it once a month or even quarterly.

---

Conclusion: Know What Your Money’s Really Doing

There’s a moment, quiet and unassuming, when you stare at your portfolio and realize you’ve been looking at the wrong numbers.

Maybe for months. Maybe for years.

Not because you’re careless.

But because no one told you that price alone doesn’t tell the truth.

That dividends count. That time matters.

That real performance lives in the details most dashboards ignore.

But now you know.

And more importantly, now you’ve got the tools to fix it.

Google Sheets gives you the canvas: familiar, flexible, and free.

Wisesheets gives you the brush: precise, powerful, and built for investors who care about the full picture.

Together, they give you clarity.

So if you’re tired of surface-level metrics…

If you’re ready to see the real story behind your returns…

Now’s the time.

Know Your Real Returns with Wisesheets

The truth was always there.

Now you can see it.