A simple investment tracking spreadsheet for beginners is an essential tool to manage your portfolio, track stocks, and monitor dividends in one place. It typically includes columns for ticker symbols, buy dates, share counts, cost basis, and current value—giving you a clear picture of your investment performance without complex software.
After-Tax, After-Fee Returns Comparator
See the real 10-year impact of fees and taxes on your returns
But if you're thinking, "I have no idea how to track this stuff"—this article is for you.
We're not building anything complicated. No advanced Excel functions. No financial jargon. Just a simple spreadsheet that tells you what you own and whether it's making money.
Why This Matters (Even If It Seems Simple)
You could ignore tracking. Go years without knowing your actual returns. But here's why that's expensive:
You can't manage what you don't measure. If you don't know how your investments are performing, you can't tell if they're good bets or dead weight.
A five-minute weekly update prevents years of "I think my portfolio is doing okay" uncertainty.
Let's build that.
The Absolute Minimum You Need
Open Google Sheets or Excel. Create three columns:
Column A: What I Own
Write the name of each stock or fund you own
Example: Apple, S&P 500 Index Fund, Amazon ETF
Column B: How Many
How many shares do you own?
Example: 10 shares, 50 shares, 3.5 shares
Column C: Current Price
What's the price today?
For stocks, check Yahoo Finance or your brokerage
Write down the number
Column D: Total Value
Multiply column B times column C
Formula in Google Sheets: =B2*C2
Copy that formula down for each row
Column E: What I Paid
How much did you spend to buy all those shares?
If you bought 10 shares at $150 each, that's $1,500
Column F: Profit or Loss
Subtract column E from column D
Formula: =D2-E2
If it's positive, you made money. If it's negative, you lost money.
That's it. You've built an investment tracker.
Real Example (So It's Not Abstract)
Let's say your portfolio looks like this:
What I Own
Shares
Current Price
Total Value
What I Paid
Profit/Loss
Apple
10
$250
=10*250
$2,000
=$2,500-$2,000
Vanguard S&P 500
20
$450
=20*450
$8,000
=$9,000-$8,000
Microsoft
5
$380
=5*380
$1,500
=$1,900-$1,500
TOTAL
—
—
$13,400
$11,500
+$1,900
After the formulas calculate, your spreadsheet shows:
You put in $11,500
It's now worth $13,400
You made $1,900
That's your entire portfolio at a glance.
Next Steps: Level Up Your Tracking
Once you're comfortable with this basic setup, you can explore more advanced options:
If you don't want to manually update prices every week, there's an easy trick.
In Google Sheets, use this formula:
=GOOGLEFINANCE("AAPL")
Replace "AAPL" with any stock ticker. It automatically pulls the latest price.
In Excel, you can:
Use the Stocks data type (if you have Microsoft 365)
Or copy prices from Yahoo Finance manually (2 minutes)
If you're new, manual updates are fine. You'll only need to update prices once a week anyway—maybe Friday evening.
Adding One More Useful Thing: Percentage Gain
Add another column:
Column G: Percentage Return
This shows you what percentage of your original investment you made back.
Formula: =(F2/E2)*100
This is useful because $500 profit on a $50,000 investment is different from $500 profit on a $1,000 investment.
The percentage tells you which investments are actually performing well.
Going Beyond the Basics
If you want to automate price updates and connect multiple brokerage accounts, check out our Investment Tracker for Google Sheets guide. It shows you how to set up automatic imports from brokers like Interactive Brokers.
Expertise: Written by Fynn Schröder, Founder of Treasure Island and investment tracking specialist with 10+ years of experience in personal finance tools and portfolio management. Connect on LinkedIn for more financial insights.
Download your free simple investment tracking spreadsheet template today and start managing your portfolio with confidence.
Frequently Asked Questions
What should a beginner investment tracking spreadsheet include?▾
A beginner investment tracking spreadsheet should include columns for the stock or fund name, number of shares, current price, total value, purchase cost, and profit or loss. This setup lets you see what you own and how it's performing at a glance.
How do I track dividends in an investment spreadsheet?▾
Add a separate column or sheet to record dividend dates, amounts per share, total payout, and whether dividends are reinvested. Summing this column alongside your capital gains gives a complete view of total returns.
Is there a free investment tracking spreadsheet template?▾
Yes. The spreadsheet described in this article is free to build in Google Sheets or Excel using basic formulas. It covers the essential tracking needs for most beginners without requiring paid software.
