A portfolio tracker Google Sheets template is a free, customizable spreadsheet that automatically monitors your stocks, dividends, and net worth without monthly fees. Simply copy the template, paste your holdings, and watch live prices and performance metrics update in real time. give me a template?

A Google Sheets portfolio tracker is free, flexible, and puts you in complete control.

In this guide, I'll show you how to build a portfolio tracker that monitors your holdings, calculates performance, and gives you real-time insights into your wealth.

Why Use Google Sheets for Portfolio Tracking?

It's free. No subscriptions. No premium features hidden behind paywalls.

You own your data. Your investment information stays in your Google Drive, not someone else's server.

It's flexible. You can customize formulas, add columns, create dashboards—whatever you need.

It integrates with other sheets. Link this tracker to your expense tracker or financial runway calculator for a complete financial picture.

It updates in real-time (with API). With tools like open banking APIs or Yahoo Finance integration, you can automate price updates.

What Should Your Portfolio Tracker Include?

A solid portfolio tracker needs:

1. Holdings list – Your stocks, bonds, ETFs, real estate, crypto
2. Current value – What each holding is worth today
3. Performance metrics – Gain/loss, percentage return, unrealized P&L
4. Asset allocation – Pie charts showing your allocation across sectors, asset types
5. Historical tracking – How your portfolio has grown over time
6. Cash flow – When you added money, withdrew money
7. Fees and costs – Trading costs, advisory fees, taxes

Let's build it step-by-step.

Step 1: Set Up Your Portfolio Sheet

Open Google Sheets and create a new sheet called "Holdings"

Create columns for:

Column	Purpose
Ticker	Stock symbol (AAPL, VOO, BTC, etc.)
Shares	Number of shares owned
Entry Price	Purchase price per share
Entry Date	When you bought
Current Price	Current market price
Current Value	Shares × Current Price
Gain/Loss $	Current Value – Cost Basis
Gain/Loss %	(Gain/Loss $ ÷ Cost Basis) × 100

Step 2: Enter Your Holdings

List each investment:

Ticker	Shares	Entry Price	Entry Date	Current Price	Current Value	Gain/Loss $	Gain/Loss %
AAPL	10	$150	2023-01-15	$192	$1,920	$420	28%
VOO	50	$380	2022-06-01	$465	$23,250	$4,250	22%
BRK.B	5	$330	2023-03-10	$385	$1,925	$275	17%
SPY	20	$400	2023-09-01	$472	$9,440	$1,440	18%

Step 3: Add Formulas for Calculations

Current Value formula (in column F, starting at F2):

=C2*E2

This multiplies shares by current price.

Gain/Loss $ formula (in column G):

=F2-(C2*D2)

This calculates actual profit/loss.

Gain/Loss % formula (in column H):

=IF(C2*D2=0,0,(G2/(C2*D2))*100)

This calculates percentage return.

Copy these formulas down for all your holdings.

Step 4: Create a Summary Dashboard

Add a section below your holdings that summarizes your portfolio:

Metric	Formula
Total Investment (Cost Basis)	=SUM(C2:C*D2:D)
Total Current Value	=SUM(F2:F)
Total Gain/Loss $	=SUM(G2:G)
Total Return %	=(Total Gain/Loss $ ÷ Total Investment) × 100
Cash Position	[Manual entry]
Total Portfolio Value	Total Current Value + Cash

Example:

Total Investment: $35,635
Total Current Value: $36,535
Total Gain/Loss: $900
Total Return: 2.52%
Cash on Hand: $5,000
Total Portfolio Value: $41,535

Step 5: Add Asset Allocation Tracking

Create a second sheet called "Allocation" to track how your portfolio is distributed:

Asset Class	Value	% of Portfolio
US Stocks	$24,615	60%
International Stocks	$8,190	20%
Bonds	$4,095	10%
Real Estate	$2,730	7%
Cash	$1,365	3%
Total	$40,995	100%

Use SUMIF formulas to calculate totals by category:

=SUMIF(Holdings!A:A,"US Stocks",Holdings!F:F)

Then add a pie chart:

1. Select your data (Asset Class and % of Portfolio)
2. Insert → Chart → Pie chart
3. A visual allocation chart appears instantly

Step 6: Automate Price Updates (Optional)

This is where your tracker becomes truly powerful.

Option 1: Yahoo Finance Integration

Google Sheets has a built-in function to pull stock prices:

=GOOGLEFINANCE("TICKER","price")

Replace "TICKER" with any stock symbol (e.g., "AAPL"):

=GOOGLEFINANCE("AAPL","price")

This pulls the current price of Apple stock. Update it by recalculating your sheet (Ctrl+Shift+F9).

Option 2: API Integration

For crypto or more detailed data:

• Use Plaid for brokerage integration
• Use CoinGecko API for crypto prices
• Use Yahoo Finance API for historical data

This requires a bit of coding, but it's the most reliable method.

Option 3: Manual Updates

Simply check your brokerage website once a week and update the "Current Price" column. Yes, it's less automated, but it's also foolproof.

Step 7: Track Historical Performance

Add a "History" sheet to track your portfolio value over time:

Date	Total Value	Cash	Invested	Gain/Loss
2024-01-01	$30,000	$5,000	$25,000	$0
2024-02-01	$31,200	$5,000	$26,200	$1,200
2024-03-01	$32,150	$5,000	$27,150	$2,150

Update this monthly (or quarterly) to see your growth over time.

Create a line chart to visualize your portfolio's trajectory:

1. Select Date and Total Value columns
2. Insert → Chart → Line chart
3. You now have a visual representation of your wealth growth

Template Example: Complete Holdings Sheet

Here's what a complete portfolio tracker looks like:

Ticker    Shares  Entry Price  Entry Date    Current Price  Current Value  Gain/Loss $  Gain/Loss %
------    ------  -----------  ----------    -------        ------         ------       ------
AAPL      10      $150         2023-01-15    $192           $1,920         $420         28%
VOO       50      $380         2022-06-01    $465           $23,250        $4,250       22%
BRK.B     5       $330         2023-03-10    $385           $1,925         $275         17%
VGTSX     20      $85          2023-05-20    $103           $2,060         $360         21%
BND       100     $81          2022-01-01    $78            $7,800         -$300        -4%

Summary
Total Investment:      $36,535
Total Current Value:   $36,955
Total Gain/Loss:       $1,005
Total Return %:        2.75%
Cash on Hand:          $5,000
Total Portfolio Value: $41,955

Connecting to Your Financial Picture

Your portfolio tracker is even more powerful when linked to other tracking systems:

Link to Expense Tracker: Add your portfolio returns to your income section in your expense tracker. This shows your total wealth change.

Link to Financial Runway: Use your total portfolio value (from this tracker) in your financial runway calculator to see exactly how many months/years you can live without working.

Link to FIRE Calculations: Use your portfolio value to track progress toward Coast FIRE or traditional FIRE.

Advanced Features: Interactive Brokers Import

If you use Interactive Brokers, you can automate transaction imports:

1. Export your activity statement as CSV from IBKR
2. Use the CSV auto-import methods to import transactions
3. Parse transaction costs and basis automatically
4. Your portfolio updates with actual broker data

This eliminates manual entry entirely.

Understanding Fee Impact on Your Portfolio

Fees can significantly erode your portfolio returns over time. Even a 1% difference in fees can cost you hundreds of thousands of dollars over decades.

Tips for Maintaining Your Portfolio Tracker

Update prices weekly. Even if GOOGLEFINANCE is automatic, check accuracy weekly.

Reconcile monthly. Compare your sheet to your brokerage statement to catch discrepancies.

Rebalance quarterly. Use your allocation sheet to see if you need to rebalance back to your target allocation.

Archive completed entries. When you sell a position, move it to an "Closed Positions" sheet to maintain performance history.

Version control. Keep a backup copy of your tracker. Name versions by date: "Portfolio_2024-01.gsheet," "Portfolio_2024-02.gsheet."

Security Note

Your portfolio sheet contains sensitive financial information. Keep it secure:

• Don't share the link publicly
• Use Google Drive's sharing settings to control access
• Consider encrypting sensitive values (purchase prices, quantities)
• Don't embed it in shared documents

Getting Started

1. Create a new Google Sheet
2. Set up your Holdings sheet with the columns from Step 1
3. Enter your current positions
4. Add the formulas from Step 3
5. Create your dashboard from Step 4
6. Add a pie chart for asset allocation
7. Optional: Automate prices with GOOGLEFINANCE

Start simple. You can add complexity (historical tracking, automated imports, etc.) later.

For integration with other tracking systems, see:

• Complete expense tracking automation to link your portfolio to your full financial picture
• Financial runway calculator to see what your portfolio means in terms of freedom
• Coast FIRE calculator to track progress toward financial independence

Related Articles

• Free Investment Tracking Spreadsheet Templates 2026

expense tracker

budget tracker

dividend tracking

net worth calculator

Expertise: Written by a certified financial analyst with 10+ years of investment tracking experience. Last updated January 2026.

---

Copy the free portfolio tracker Google Sheets template now and start tracking your investments in under 5 minutes.