Excel Stock Portfolio Tracker (Excel + Google Sheets, Free)
What's inside the stock portfolio tracker
The workbook is a single Portfolio sheet with 100 rows: symbol, quantity, average cost per share, and current price. Market value, cost basis, gain/loss $ and gain/loss % all calculate automatically once you've entered a current price for each position.
A summary block below the table rolls everything up: total portfolio value, total cost basis, total gain/loss, and the largest single-position allocation - so you can see your whole portfolio's health without adding up rows yourself.
Unlike Portfolio Slicer, which is free but requires Windows and a Power Pivot setup, this file is a plain formula-only spreadsheet - no add-ins, no Windows requirement, works the same in Excel and Google Sheets.
Manual price updates - no live data connection
To be direct about what this template does and doesn't do: current price is a column you type into, not a live feed pulling quotes from a market data source. You update it yourself each time you check in on your portfolio - daily, weekly, or whenever you review your holdings.
That's a deliberate trade-off. A live-data connection (like MarketXLS's paid add-in) adds ongoing cost and a dependency that can break; a manual price column works forever, in any spreadsheet app, with no subscription - at the cost of needing you to type in a number.
Every calculation - market value, gain/loss, allocation % - depends on that manual price being current, so update it before relying on the numbers for a decision.
Allocation % and the concentration-risk flag
Allocation % of portfolio shows what share of your total portfolio value each position represents, calculated from live market values so it updates the moment you refresh a price - not a static snapshot you have to recompute.
A conditional-formatting flag highlights any position where allocation exceeds 25% of the total portfolio - a simple concentration-risk check built with plain IF/SUM formulas, a feature none of the scraped free competitor templates (Vertex42's stock-quotes sheet, Indzara's tracker, Portfolio Slicer) include out of the box.
Who this template is for
Individual investors who want a simple, offline record of their holdings, cost basis and gain/loss - without a brokerage-linked app, an Excel add-in subscription, or a Power Pivot setup.
This template is for organizing and tracking your own portfolio. It is not investment advice and does not recommend what to buy, hold or sell - consult a licensed financial advisor for investment decisions.
How to use it
- List every position: symbol, quantity, average cost per share, and current price (entered manually).
- Market value, gain/loss $ and %, and allocation % of portfolio calculate automatically.
- Check the summary below the table for total value, total gain/loss, and your largest position's allocation.
Download the free Excel Stock Portfolio Tracker (Excel + Google Sheets, Free)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Does this template pull live stock prices?
No. Current price is entered manually for each position - there is no live market data connection. Update it yourself whenever you review your portfolio.
How is allocation % calculated?
A position's market value divided by the sum of all positions' market values. It updates automatically whenever you refresh a current price.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All formulas keep working.
How many positions can I track?
Up to 100 positions on the Portfolio sheet. For most individual investors that covers a full portfolio across multiple accounts.
Is this investment advice?
No. This template is for tracking your own holdings. It is not investment advice and does not recommend specific trades - consult a licensed financial advisor for investment decisions.
What's the usage license?
Personal use. It's not meant to be resold or redistributed as a template product.