Gallup reported that 62% of U.S. adults owned stock in 2025, and the Federal Reserve reported $64.8 trillion in directly and indirectly held household equity shares in Q1 2026. The Stock Portfolio Tracker in Google Sheets gives investors a practical way to monitor ticker allocation, sector exposure, cost basis, market value, and gain/loss without a paid portfolio app. Built by PK, a Microsoft Certified Professional with 15+ years of spreadsheet experience and 300K+ subscribers, this editable tracker is a one-time $6.99 purchase with no recurring template subscription.
Key Features of Stock Portfolio Tracker in Google Sheets
- Total Portfolio Value card: See the selected market value in one headline KPI at the top of the Overview page.
- Ticker-level allocation: Review how your portfolio is distributed across tickers before rebalancing or adding new positions.
- Sector breakdown: Compare positions by sector so concentration risk is easier to notice.
- Gain/loss visibility: Track dollar gain or loss by ticker using your entered cost basis and market value.
- Cost basis comparison: Compare Cost Basis vs Market Value by ticker to see where value has moved.
- Multiple slicers: Filter the dashboard quickly during monthly portfolio reviews.
- Dropdown List tab: Maintain sector options and position-status values so data entry stays consistent.
- Google Sheets format: Copy to Google Drive, update from a browser, and share with selected permissions.
What’s Inside the Stock Portfolio Tracker in Google Sheets
1 – Overview Page
The Overview Page is the main dashboard sheet. At the top, the Total Portfolio Value card shows the high-level market value after slicer filters are applied, so you can check portfolio size before reviewing the charts.
Portfolio Allocation by Ticker: This chart shows how market value is distributed across each ticker in the tracker. It helps you spot over-concentration in one stock, ETF, or fund before making allocation decisions.
Positions by Sector: This chart groups holdings by sector. It helps you understand whether your portfolio leans too heavily toward technology, finance, healthcare, energy, or another sector category.
Gain / Loss ($) by Ticker: This chart compares the dollar gain or loss for each ticker. It helps you identify which positions are contributing most to portfolio performance and which ones need closer review.
Cost Basis vs Market Value by Ticker: This chart compares what you paid against the current market value for each ticker. It gives a clear visual check of unrealized movement at the position level.
2 – Dropdown List Tab
The Dropdown List tab keeps the tracker cleaner by storing list values used in the workbook. Instead of typing sector names and status labels differently each time, you can maintain controlled dropdown options in one place.
Sector Options by Portfolio Category: This area stores the sector or portfolio-category values used by the tracker. Consistent sector names make the Positions by Sector chart cleaner and easier to read.
Position Status by Tracking Stage: This area stores status options for classifying holdings. It helps you separate active, watchlist, closed, review, or custom tracking stages without breaking dashboard filters.
Stock Portfolio Tracker in Google Sheets vs. Microsoft Excel vs. Paid Portfolio SaaS – Where This Fits
| Feature | This Google Sheets tracker | Microsoft Excel alternative | Paid portfolio SaaS |
|---|---|---|---|
| Cost | $6.99 sale price, one-time | Template cost plus any Microsoft license | Usually monthly or annual |
| Platform | Google Sheets in Drive | Excel desktop or web | Vendor web or mobile app |
| Setup time | Copy file, update dropdowns, enter positions | Open workbook and customize | Create account and connect or import accounts |
| Real-time team collaboration | Built into Google Sheets sharing | Available through Microsoft cloud tools | Depends on plan and permissions |
| Mobile access | Google Sheets mobile app | Excel mobile app | Usually included |
| Customizable fields | Edit tickers, sectors, statuses, formulas, and charts | Editable if workbook is unlocked | Often limited to app settings |
| Share with link | Yes, using Google Drive permissions | Yes, through OneDrive or SharePoint | Usually account-based |
| Year-1 cost at 5 users | $6.99 before any Google Workspace costs | Template plus license cost | Can rise with seats or premium features |
| Ticker allocation charts | Included on the Overview page | Must be built or purchased | Depends on app reporting |
| Manual data control | Yes, no bank or brokerage login required | Yes | Often encourages connected accounts |
Who This Template Is For – and Who It’s Not For
This template is for individual investors, household budgeters, investment club members, spreadsheet-first advisors, and finance students who want a clean manual tracker for holdings, cost basis, market value, gain/loss, sector exposure, and ticker allocation.
It is not a brokerage account, trading platform, tax-lot accounting system, retirement planner, live market-data terminal, or substitute for professional financial advice. Use official brokerage statements and tax records before making trading, tax, or compliance decisions.
How to Use the Stock Portfolio Tracker in Google Sheets
- Open the PDF guide after purchase and copy the Google Sheets file to your Drive.
- Review the Dropdown List tab and update sector and position-status options.
- Enter each holding with ticker, sector, status, cost basis, and market value.
- Open the Overview Page to review Total Portfolio Value and the four portfolio charts.
- Use slicers to filter by ticker, sector, status, or other available fields.
- Compare cost basis and market value before monthly review or rebalancing discussions.
- Keep the tracker reconciled with your brokerage records.
Real-World Use Cases
Maya, self-directed investor
Maya tracks her ETF and stock positions by ticker and sector. Once a month, she checks allocation by ticker and sector before deciding whether new contributions should go to an underweighted area.
Jordan, household finance planner
Jordan uses the cost basis versus market value chart to explain household investment movement during a monthly budget review. The manual setup keeps the file in Google Drive without connecting brokerage credentials.
Priya, finance coach
Priya creates a separate copy for each coaching client and uses the gain/loss by ticker chart to start a planning conversation. She reminds clients to verify all figures against official account statements.
Frequently Asked Questions
What does the Total Portfolio Value card show?
It shows the selected portfolio market value based on the data and filters applied in the tracker.
Can I track multiple tickers?
Yes. Add each ticker as a separate position or row, then use the allocation, gain/loss, and cost basis charts to analyze the holdings.
Does this connect directly to my brokerage account?
No. It is a manual Google Sheets tracker. This keeps setup simple and avoids requiring bank or brokerage login credentials.
Can I customize sectors and statuses?
Yes. The Dropdown List tab lets you maintain sector options and position-status values used throughout the tracker.
Does it provide investment advice?
No. It organizes portfolio data for analysis. Investment, tax, and trading decisions should be verified with qualified professionals and official account records.
Can I share it with another person?
Yes. After copying the file to Google Drive, you can share it using Google Sheets permissions.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
For adjacent finance workflows, explore the Investment Management Dashboard in Google Sheets, Personal Finance Net Worth Tracker in Google Sheets, Loan EMI Repayment Tracker in Google Sheets, Student Loan Repayment Tracker in Google Sheets, and Mortgage Payoff Tracker in Google Sheets. Browse more Google Sheets templates, Google Sheets tracker templates, and Google Sheets financial tools.
Get the Stock Portfolio Tracker in Google Sheets and turn ticker, sector, cost basis, market value, and gain/loss data into a clear portfolio dashboard you can review every month.
Watch the step-by-step video Demo:
Last updated: July 19, 2026.
Compatibility and Requirements
- Works in Google Sheets. You need a free Google account and a web browser.
- Sector and position-status values come from dropdowns on the Dropdown List tab. Google explains dropdowns in Create an in-cell dropdown list.
Reviews
There are no reviews yet.