Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceInvestment TrackingInvestment Portfolio Tracker

SpreadsheetInvestment TrackingFree

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

Shown with sample data

Colour

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

Portfolio value
$74,144
Unrealised gain
$13,013
Total return
21%
Largest holding
33%
Watch concentration above 20%
Allocation by asset class
  • US stocks$37,916.6051%
  • International stocks$16,306.5022%
  • Bonds$12,897.2017%
  • Real estate$3,5245%
  • Cash$3,5005%
Market value by holding
  • VTI$24,616
  • VXUS$8,988
  • BND$8,748
  • MSFT$7,590.60
  • VTIAX$7,318.50
  • AAPL$5,710
  • FXNAX$4,149.20
  • VNQ$3,524

How to use it

  1. 1Enter each holding with ticker, asset class, account, shares and average cost per share.
  2. 2Update Current price when you review (weekly or monthly).
  3. 3Set your target percentage for each asset class on the Allocation sheet (they should add up to 100%).
  4. 4Follow the Buy / sell column to rebalance, or direct new money to the classes that are under target.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Record each holding with shares, average cost and current price. The tracker calculates market value, unrealised gain or loss, return and each holding's weight, then rolls everything up by asset class against your target allocation and tells you how much to buy or sell in each class to rebalance, the way a planner would.

Who it’s for

  • DIY investors with several accounts
  • Keeping a target allocation (for example 60/40)
  • Quarterly or yearly rebalancing

What’s included

  • Holdings sheet: Each position with value, gain, return and weight.
  • Allocation sheet: Your allocation by asset class against your targets, with what to buy or sell.

How to use it

  1. 1Enter each holding with ticker, asset class, account, shares and average cost per share.
  2. 2Update Current price when you review (weekly or monthly).
  3. 3Set your target percentage for each asset class on the Allocation sheet (they should add up to 100%).
  4. 4Follow the Buy / sell column to rebalance, or direct new money to the classes that are under target.

Tips

  • Rebalance when a class drifts more than 5 percentage points from target, not every week.
  • Rebalance with new contributions first to avoid selling and paying tax.
  • Record dividends in the Dividend Income Tracker.

Questions

Does it pull live prices?

No. Prices are entered by hand so the sheet works anywhere. In Google Sheets you can replace Current price with a GOOGLEFINANCE formula.

What does Drift mean?

Current share of the portfolio minus the target share. Positive means overweight, negative underweight.

Related searchesinvestment trackerportfolio trackerstocksasset allocationrebalancinggainsetf portfolio

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInvestment TrackingFree

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More investment tracking templates

View all
Dividend Income Tracker3 sheets

Forward annual income

$1,439

Per month

$120

Portfolio yield

2%

Dividends by month
$183.04
$178.14
$172.74
$110.28
$106.08
SepJunMarOctJan
SpreadsheetInvestment Tracking

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

10 min setupPreview
Asset Allocation & Rebalancing Planner3 sheets

Portfolio value

$117,300

Classes out of range

2

Largest drift

10%

ABCD
1Asset classTargetCurrent valueCurrent share
2Global equities55%$75,70065%
3Home equities10%$9,8008%
4Bonds20%$17,40015%
5Property5%$6,1005%
Allocation
SpreadsheetInvestment Tracking

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

10 min setupPreview
Crypto Portfolio Tracker2 sheets

Portfolio value

$49,891

Unrealised gain

$4,034

Realised gains this year

$1,270

Allocation by coin
48%
  • BTC
  • ETH
  • LINK
  • USDC
SpreadsheetInvestment Tracking

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ