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.
Formula cells are locked so a stray keystroke can't break the math; input cells stay editable. To change a formula or the layout in Excel, go to Review → Unprotect Sheet and enter the password tt.
Download the free Excel Stock Portfolio Tracker (Excel + Google Sheets, Free)
The offers include our paid versions of the templates. Privacy
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.