Excel Stock Portfolio Tracker Template Download: Choose and Set Up

Broker apps show balances. They rarely give you one calm register for cost basis, live quotes, buys and sells, and a performance history you can chart yourself. An excel stock portfolio tracker template download is useful when you want that register in a file you control. The goal is not a trading cockpit. It is a clear holdings sheet, a quotes source you trust, and a habit that keeps gain and loss numbers honest.

Explore the stock portfolio tracker cluster [CLUSTER_NAV]

Use this guide to choose an approach, then continue with the specific job you need:

• Stock Portfolio Excel Template: Fields That Actually Matter
• Best Excel Stock Portfolio Tracker: How to Compare Options
• Create a Stock Portfolio in Excel: Step-by-Step Build
• Investment Portfolio Excel Template: Beyond Single Tickers
• Simple Stock Tracking Spreadsheet Excel: Start Small

Decide what this workbook must answer

Write the question before you add columns. Common ones: “What is each position worth today?”, “What did I pay for it?”, “How much cash is left?”, or “How has total value moved this quarter?” That question decides whether you need live quotes, a dividends column, or only a static list. Spreadsheets get fragile when they try to be a tax engine, a research terminal, and a retirement planner at once.

A free gated download helps when you want a quick look. DIY with Excel’s Stocks data type works when you enjoy formulas and Microsoft 365. A paid structured workbook is a practical middle path when you want Start Here instructions, a Quotes sheet, and a Portfolio sheet that already knows the gain/loss math. Compare options on maintenance, not on how many charts appear on day one.

[TABLE: Recommended approach by situation]

Use a holdings register, not a random grid

Every row should represent one open position. Keep the ticker stable even if the company name display changes. Record shares and average cost from your brokerage export, not from memory. Market value is shares times current price. Unrealized gain or loss is market value minus cost basis. Percent gain is that difference divided by cost basis. Those four formulas are enough for most personal trackers.

Controlled values matter. “ETF,” “etf,” and “Exchange Traded Fund” break filters. Keep an asset type list short: stock, ETF, cash, other. If you track dividends, log them as transactions instead of overwriting share counts. [WARNING] Do not delete closed positions just to tidy the sheet. Mark them sold, keep the exit date, and filter active rows when you review.

Separate quotes from portfolio math

Live prices belong on a Quotes sheet or in Excel’s Stocks fields. The Portfolio sheet should look up price by ticker rather than pasting numbers each week. Google Sheets users often lean on GOOGLEFINANCE; Excel 365 users can convert tickers with Data > Stocks and pull .Price. Either way, refresh on a schedule and note that delayed quotes are fine for personal tracking.

The PlanoNest Excel Stock Portfolio Tracker is a structured workbook for individual investors who want that separation already built. It includes a Start Here sheet, a Portfolio sheet with holdings and gain/loss calculations, a Quotes sheet for ticker management and live lookups, historical performance data that is chart-ready, and a transaction log for buys, sells, dividends, and fees. It works in Excel and Google Sheets as a one-time purchase with instant digital download. Check the product page for current pricing.

Keep a transaction log

A holdings row answers “what do I own now?” A transaction log answers “how did I get here?” Log date, ticker, action, shares, price, fees, and notes. Rebuild average cost from that log when you add to a position. Brokers disagree on lot methods; your spreadsheet only needs one consistent method you document on Start Here.

Sites such as Vertex42 and roundups like Tiller’s free investment spreadsheet list show how popular free Excel and Sheets trackers remain. Guides from Investopedia on tracking investments in Excel and step-by-step Stocks data type walkthroughs from NYIM Training cover the DIY path. Free Google Sheets trackers such as Beanvest’s portfolio spreadsheet are useful references for GOOGLEFINANCE layouts. Use them as research, then decide whether you want to maintain formulas yourself.

Know when Excel is enough

Excel or Google Sheets is enough when position count is manageable, one person owns the file, and you need visibility rather than automated tax lots across many accounts. It remains useful for a quarterly rebalance check or a simple allocation pie chart. Consider a dedicated portfolio app when you need multi-broker sync, audited performance reporting, or shared household editing without file conflicts.

A short setup checklist

1. Export current positions and cash from your brokerage.
2. Enter ticker, shares, and average cost; verify cost basis against the export.
3. Connect quotes (Stocks data type, GOOGLEFINANCE, or a Quotes sheet).
4. Confirm market value and unrealized gain formulas on three sample rows.
5. Add a transaction log and a monthly value snapshot sheet.
6. Write refresh and review rules on Start Here.

Review before you trust the totals

Filter for blank tickers, zero shares, and prices that have not refreshed. Spot-check one position against the brokerage app. If allocation percentages do not sum near 100%, find cash or closed rows that should be excluded. Fix the convention once and document it. Do not add a second dashboard because the first table is messy.

Keep the workbook honest over time

Personal portfolio spreadsheets fail quietly. A ticker stops resolving, a dividend reinvestment changes share count, or cash sits in the brokerage and never appears in the total. Schedule a short reconciliation: open the brokerage positions view, match tickers and shares, then match cash. Only after that reconciliation should you trust allocation percentages or month-over-month charts.

Document exceptions on the Start Here sheet. Examples: a delisted ticker kept for history, a mutual fund priced manually, or a joint account that should be excluded from personal allocation targets. Future you will not remember why a row looks odd. A one-line note prevents a weekend of reverse engineering.

When you outgrow a single table, add sheets rather than columns. A Transactions sheet preserves the story of each buy and sell. A Snapshots sheet stores month-end total value for a simple line chart. A Closed sheet holds exited positions so active filters stay readable. Resist the urge to automate every edge case. Spreadsheet trackers stay useful when they remain understandable after three months away.

FAQ

What is the minimum for a stock portfolio tracker?

Ticker, shares, average cost, current price, market value, and unrealized gain or loss. Add dividends and fees when those numbers change decisions.

Can I use this in Google Sheets?

Yes. Many trackers use GOOGLEFINANCE in Sheets. The PlanoNest workbook is built to work in Excel and Google Sheets; confirm quote behavior after import.

Do I need live prices every minute?

No. Delayed quotes are fine for personal gain/loss tracking. Refresh when you review, not while you trade.

Free template or paid workbook?

Use free or DIY when you enjoy maintenance. Choose a paid structured workbook when you want Start Here guidance, a Quotes sheet, and a transaction log without building them from scratch. See the product page for live pricing on a one-time purchase.

Disclosure

PlanoNest sells this template. Links to PlanoNest products and collections point to our own digital template shop. This article is for spreadsheet workflow education and is not investment advice.

About the author

Robin is the independent maker behind PlanoNest, creating practical Excel, Google Sheets, and Notion templates for clearer day-to-day tracking.