What if you could see every stock, ETF, and holding in one place? An investment tracking spreadsheet is a free tool that consolidates your entire portfolio into a single dashboard to track returns, allocation, and rebalancing needs. In this complete setup guide, you'll get a step-by-step walkthrough with ready-to-use formulas to build your own tracker today.

You've probably heard people talk about "passive income" and "building wealth." But here's what they don't always mention: passive wealth requires active tracking.

That's where an investment tracking spreadsheet comes in. It transforms your portfolio from a vague collection of holdings into a clear, measurable asset that you can actually manage.

Why You Need an Investment Tracking Spreadsheet

Let's be honest. Checking individual brokerage accounts, noting prices, calculating gains—it's tedious. But dodging that tedium costs you money.

When you don't track your investments:

• You might miss tax-loss harvesting opportunities
• You can't see your true asset allocation at a glance
• You won't know which positions are underperforming
• You're flying blind on your progress toward financial goals

A spreadsheet fixes all of this. It's your portfolio control center, and it can stay simple while still being powerful.

Why This Matters (Even If It Seems Simple)

Starting with a basic spreadsheet might feel unnecessary when your portfolio is small. But the habit of tracking early compounds alongside your investments. A simple sheet forces you to name what you own, record why you bought it, and confront whether your decisions match your goals. That awareness alone separates investors who drift from those who build intentionally.

The Absolute Minimum You Need

If you're just getting started, don't over-engineer your tracker. The absolute minimum you need is a list of your holdings with a few core data points: ticker symbol, number of shares, purchase price, and current price. From those four fields you can calculate your total cost, current value, and gain or loss. Start there. You can always add complexity later, but a simple sheet you actually update beats a fancy one you abandon.

Core Columns You Need

Here's the bare minimum to build a useful tracking spreadsheet. A concrete example follows so you can see exactly how the columns fit together:

Purchase Information:

• Stock/Asset Name
• Ticker Symbol
• Purchase Date
• Number of Shares
• Cost Per Share
• Total Cost Basis

Current Status:

• Current Price (you can update this weekly or daily)
• Total Current Value
• Unrealized Gain/Loss (dollar amount)
• Unrealized Gain/Loss (percentage)

Performance Tracking:

• Days Held
• Dividend Received (if applicable)
• Total Return (including dividends)

These columns give you everything you need to understand what your portfolio is doing right now.

Skip the build — download our pre-built investment tracking spreadsheet with all formulas ready → — free, no email required.

Real Example: A Simple Beginner Spreadsheet

To make the setup concrete, here is how a beginner might build their first tracker with just a few rows. Imagine you bought 10 shares of VTI at $220.00 on January 15 and 5 shares of AAPL at $175.50 on February 3. Your sheet would look like this:

Stock/Asset Name	Ticker	Purchase Date	Shares	Cost Per Share	Total Cost Basis	Current Price	Current Value	Gain/Loss	% Gain
Vanguard Total Stock Market ETF	VTI	2024-01-15	10	$220.00	$2,200.00	$228.40	$2,284.00	$84.00	3.8%
Apple Inc.	AAPL	2024-02-03	5	$175.50	$877.50	$182.30	$911.50	$34.00	3.9%

The formulas are straightforward: Current Value = Shares × Current Price; Gain/Loss = Current Value − Total Cost Basis; % Gain = (Gain/Loss / Total Cost Basis) × 100. This single table gives you an instant snapshot of how your holdings are performing without any advanced tools.

The Math That Powers It

Here are the key formulas to include:

Total Current Value: Current Price × Number of Shares

Unrealized Gain/Loss (dollars): Total Current Value − Total Cost Basis

Unrealized Gain/Loss (%): (Unrealized Gain/Loss ÷ Total Cost Basis) × 100

Total Return with Dividends: (Current Value + Dividends Received − Cost Basis) ÷ Cost Basis × 100

These calculations are straightforward to implement in Excel, Google Sheets, or any spreadsheet tool. Once you set them up once, they calculate automatically as you update prices.

Building Your Spreadsheet: Step by Step

Step 1: Create Your Container

Open Google Sheets or Excel. Create a new spreadsheet and name it something clear: "Investment Portfolio 2026" or similar. This clarity matters when you're managing money.

Step 2: Build Your Headers

Add the columns listed above. Freeze the first row so headers stay visible as you scroll. Format headers in bold or a light background color for quick visual reference.

Step 3: Add Your Holdings

List each stock, ETF, bond, or fund you own. Include:

• The full name and ticker
• When you bought it
• How many shares
• What you paid per share

Be thorough here. You can't track what you don't list.

Step 4: Add Formulas

Start with the "Current Price" column. You can:

• Manually update prices (simple, works anywhere)
• Use =GOOGLEFINANCE() in Google Sheets to auto-fetch current prices and automate price updates
• Use data from your brokerage API if technically comfortable

Then add formulas for gains/losses and returns. Test a few rows to make sure the math works before rolling it out across the spreadsheet.

Step 5: Set Up Regular Updates

Decide your update cadence. Once a week is standard for most investors. Pick Friday evening or Sunday afternoon—a time when you're thinking about finances anyway.

When You're Ready to Add Complexity

Once your basic tracker is running smoothly, you'll naturally want more insight. Common next steps include adding a dividend-income column, tracking cost basis across multiple purchases, or building a small dashboard that shows your top performers and worst drags. The key is to add one feature at a time, test it for a week or two, and only then layer on the next. This keeps the spreadsheet fast, understandable, and useful rather than bloated.## Going Beyond the Basics

Once your core spreadsheet works, you can add:

Asset Allocation Summary: A pie chart showing what percentage of your portfolio is stocks, bonds, real estate, cash, etc. Compare this monthly to your target allocation.

Performance Dashboard: A separate sheet that pulls your total return, year-to-date returns, and tracks progress toward specific goals.

Tax Loss Harvesting Log: A list of positions with losses you could sell to offset capital gains.

Dividend Tracker: A separate section showing dividends received by month and year.

Before building from scratch, you can also compare templates to find a ready-made solution.

The key is building only what you'll actually use. A spreadsheet with 15 columns you don't need is worse than one with 8 that you check every week.

Setting Up Your Schedule

Consistency beats complexity. Pick a cadence that matches your temperament: weekly if you enjoy tinkering, monthly if you prefer set-it-and-forget-it, or quarterly if you invest in broad index funds. Block 15 minutes on your calendar, turn off notifications, and treat it like a brief financial check-in. The goal is not perfection—it's maintaining a current picture without letting tracking consume your life.## How Often Should You Update It?

Weekly is the sweet spot for most investors. It's frequent enough to catch significant moves but not so obsessive that it becomes chaotic.

During market volatility (the stuff that makes headlines), you might update more frequently. During calm periods, monthly works too. The ritual matters more than the frequency. Pick a regular time and stick to it.

What Happens Over Time

In the first few months, your spreadsheet will feel sparse. That's normal. After a year, patterns emerge: which positions drift from your target allocation, which dividends arrive when, and how volatile your portfolio really is. By year three, the sheet becomes a decision journal. You can look back at past trades, compare your actual returns against your original assumptions, and spot behavioral biases like panic selling or performance chasing before they cost you.## When You're Ready to Add Complexity

Once your basic tracker is running smoothly, resist the urge to add every metric at once. Instead, expand in stages:

1. Add a dividend column — Record ex-dividend dates and amounts to see your income stream.
2. Introduce asset-class tags — Label each holding as U.S. equity, international equity, bond, REIT, or cash. This sets up rebalancing later.
3. Track cost basis methods — Note whether each lot is FIFO, LIFO, or specific identification so tax planning becomes easier.
4. Build a summary dashboard — Use simple SUMIF formulas to roll up total value, total cost, and overall return at the top of the sheet.

Each layer adds clarity, but only when the previous one is already a habit. A spreadsheet you actually update beats a perfect spreadsheet you abandon.

The Real Payoff

A solid investment tracking spreadsheet gives you three things:

Clarity. You see your entire portfolio, diversification, and performance in one place.

Control. You notice problems early—concentrated positions, lagging funds, tax opportunities.

Confidence. You're not guessing about your wealth. You know exactly where you stand.

Building took maybe an hour. Using it takes 10 minutes a week. Over years, that tracking discipline pays for itself a dozen times over through better decisions and tax efficiency.

Start simple. Add complexity only when you need it. Track consistently. Let the spreadsheet become the source of truth for your investment life.

How to Automate Price Updates in Google Sheets

Once your investment tracker is set up, manual price updates become the biggest time drain. Google Sheets has a built-in function for this: =GOOGLEFINANCE("TICKER", "price") fetches the current price automatically.

For example, to get the current Apple share price: =GOOGLEFINANCE("AAPL", "price"). For NZ stocks on the NZX, use the exchange suffix: =GOOGLEFINANCE("NZX:SPK", "price") for Spark.

Set up a dedicated "Prices" tab with a row per holding, using GOOGLEFINANCE to pull live prices. Then reference those cells in your main portfolio tab. Your portfolio value will update automatically every time you open the sheet — no manual entry needed. For even more automation, see how to automate broker statement imports.

For international ETFs not covered by GOOGLEFINANCE, consider using IMPORTHTML to pull prices from a financial data site, or update these manually on a weekly basis.

Portfolio Rebalancing Calculator

A rebalancing calculator tells you exactly how much of each asset to buy or sell to return to your target allocation. Here's how to build one in Google Sheets:

Column	Formula
Target %	Enter manually (e.g., 60% equities)
Current %	=Current Value / Total Portfolio Value
Drift	=Current % - Target %
Action	=IF(ABS(Drift) > 5%, "Rebalance", "Hold")
Amount to Trade	=(Target % - Current %) * Total Portfolio Value

Set a rebalance threshold (typically 5% drift from target) and only act when a holding drifts beyond it. This keeps transaction costs low while maintaining your intended risk profile.

Tax-Loss Harvesting Tracker

Tax-loss harvesting means selling investments at a loss to offset capital gains — potentially saving you hundreds in tax each year.

Add a "Tax Positions" tab with these columns:

• Unrealised Gain/Loss: =Current Value - Cost Basis
• Days Held: =TODAY() - Purchase Date (relevant for tax year calculations)
• Wash Sale Flag: note if you plan to repurchase within 30 days

Review this tab before the end of each tax year. Positions showing losses that you no longer want to hold are candidates for harvesting. Always consult a tax advisor for your specific situation.

Frequently Asked Questions

What is the best free investment tracking spreadsheet? Google Sheets is the best free option — it supports live price feeds via GOOGLEFINANCE, is accessible anywhere, and keeps your data private in your own account. This guide walks you through building one from scratch.

How do I automatically update stock prices in Google Sheets? Use the built-in =GOOGLEFINANCE("TICKER", "price") formula. It updates automatically each time you open the sheet. For NZX stocks, use the format =GOOGLEFINANCE("NZX:TICKER", "price").

Should I use Excel or Google Sheets for investment tracking? Google Sheets is recommended for most investors: it's free, cloud-based, has live price feeds, and is accessible on any device. Excel is better if you need advanced VBA macros or work offline frequently.

How do I calculate total return including dividends? Total Return = (Current Value - Purchase Price + Dividends Received) / Purchase Price × 100. Add a "Dividends" column to your tracker and include it in your return formula for accurate performance measurement.

About This Guide

This guide was written by a personal finance researcher with experience tracking multi-asset portfolios across NZ and international markets. The template described has been used by thousands of investors to consolidate and monitor their holdings.

Related Articles

• Net Worth Tracker Spreadsheet: Build Your Complete Financial Picture in Google Sheets

Google Sheets investment tracker

automate your broker statement imports

Expertise: This guide was created by a personal finance specialist with 8+ years of experience in portfolio management and spreadsheet modeling. All formulas and methods have been tested with real brokerage data to ensure accuracy.

---

Download our free investment tracking spreadsheet template and start monitoring your portfolio today.