Stock Portfolio Tracker Excel Template | PlanoraNest Template

This Excel stock portfolio tracker template from PlanoraNest is a personal investment tracking spreadsheet with live Google Sheets price integration, gain/loss calculations, and historical performance charts. Six sheets with GOOGLEFINANCE-powered live quotes and automated CAGR returns. One-time purchase at $3.9 (compare at $6.9), instant download, no subscription.

Who it's for

This stock portfolio tracker is built for individual investors who want to monitor their holdings without a brokerage dashboard:

• Individual investors who hold stocks, ETFs, and index funds across multiple accounts and want a consolidated view.
• DIY portfolio managers who track cost basis, unrealized gains, and realized gains/losses in one spreadsheet.
• Investors who want historical price data and performance charts without paying for a portfolio tracking service.
• Beginners learning how to calculate investment returns (CAGR, unrealized vs. realized gains) with real data.

What's included in this Excel template

Six sheets covering live quotes, portfolio tracking, and historical analysis:

Start Here sheet

Quick-start guide with navigation tips and setup instructions. Includes the PlanoraNest link for more templates and updates.

Quotes sheet

Live stock price dashboard with 11 columns per ticker: Symbol, Info, Prev Close, Price, PE, EPS, Low, High, Volume, 52-Wk Low, and 52-Wk High. Each row uses the GOOGLEFINANCE function wrapped in IFERROR to pull live or near-real-time data from Google Finance. The Info column is a clickable hyperlink to the stock's detail page. Add any symbol (stocks, ETFs, mutual funds) to column A and copy the formulas down. Includes sample data for SPY, QQQ, DIA, VGT, and VCR.

Portfolio sheet

Your holdings tracker with 14 columns split into Purchased and Sold sections. Stock Purchased: Stock, Date Bought, Shares, Purchase Price, Total Fees, Purchase Cost (Shares x Price + Fees), Current Price (GOOGLEFINANCE), Current Value (Current Price x Shares), Unrealized Gain/Loss (Current Value - Purchase Cost). Stock Sold: Date Sold, Sell Price, Income from Sale (Sell Price x Shares), Realized Gain/Loss (Income - Purchase Cost). CAGR (Compound Annual Growth Rate) calculates automatically for each holding using the formula: (Current Value / Purchase Cost)^(365/days held) - 1, using TODAY() for open positions. Tracks buy-and-hold positions as well as fully exited trades.

Historical sheet

Historical price data engine with 1,200+ rows. Configure a Symbol, Start Date, End Date, Attribute (price, all), and Interval (Daily, Weekly). The sheet pulls historical open, high, low, close, and volume data via GOOGLEFINANCE. Use this for chart-ready data, performance analysis, and backtesting. Sample data shows SPY weekly prices dating back to 2018.

Help sheet

Documentation covering template overview, how to add more stock quotes (enter symbol in column A, copy formulas), GOOGLEFINANCE function guidance, and links to related financial templates (Simple Investment Tracker, Financial Calculators, Budget Templates).

About sheet

Template credits, license information (personal and commercial use allowed, no resale), and usage notes — designed for personal and business productivity.

Sheet	What it does
Start Here	Quick-start guide for portfolio tracking setup
Quotes	Live price dashboard: Symbol, Price, PE, EPS, High/Low, Volume, 52-Week Range via GOOGLEFINANCE
Portfolio	Holdings tracker: Purchase Cost, Current Value, Unrealized/Realized Gain-Loss, CAGR with TODAY()
Historical	1,200+ rows of price history (Date, Open, High, Low, Close, Volume) via GOOGLEFINANCE
Help	Documentation and links to related financial templates
About	Credits and license terms

Preview

See how each sheet looks before you download — screenshots from the actual template.

Historical Performance

Preview of Excel Stock Portfolio Tracker Template Download | PlanoraNest Template

Portfolio Holdings

Preview of Excel Stock Portfolio Tracker Template Download | PlanoraNest Template

Stock Quotes

Preview of Excel Stock Portfolio Tracker Template Download | PlanoraNest Template

Start Here

Preview of Excel Stock Portfolio Tracker Template Download | PlanoraNest Template

How to use this Excel template

Get your stock portfolio tracker running with live data in under 15 minutes:

1. Open the file in Google Sheets — the GOOGLEFINANCE functions require Google Sheets to pull live prices. (The template also works in Excel with static data if you paste values.)
2. Read the Start Here sheet for a quick tour.
3. Go to the Quotes sheet and replace the sample symbols (SPY, QQQ, DIA, VGT, VCR) with your own tickers in column A. Copy the formulas from the previous rows to populate Price, PE, EPS, Volume, and 52-week range data.
4. Move to the Portfolio sheet and enter your holdings: Stock symbol, Date Bought, Shares, Purchase Price, and any fees. Purchase Cost, Current Price, Current Value, and Unrealized Gain/Loss calculate automatically. For sold positions, enter Date Sold and Sell Price — Realized Gain/Loss and CAGR calculate automatically.
5. Use the Historical sheet to pull price history for any symbol. Set the Symbol, Start Date, End Date, and Interval — the sheet populates with Date, Open, High, Low, Close, and Volume data ready for charting.
6. Check the Help sheet if you need guidance on adding more stocks or understanding the GOOGLEFINANCE function.

Works with

• Google Sheets (recommended — required for live GOOGLEFINANCE prices)
• Microsoft Excel (desktop & web — works with static or manually-entered prices)
• WPS Office
• LibreOffice Calc

One-time purchase — $3.9 USD (compare at $6.9) — Instant download — No account required to use the file after purchase.