Investment / Portfolio Tracker (Pro) — Google Sheets + Excel for Stocks, Mutual Funds, ETFs, Crypto & Gold
Advanced portfolio tracker for Google Sheets & Excel. Track stocks, mutual funds, ETFs, crypto and gold with live gain/loss (₹ & %), portfolio weight, asset-allocation target-vs-actual with rebalance hints, and a dividend log. GOOGLEFINANCE-ready for live prices. 6 tabs, live formulas.
Track your whole portfolio — and know exactly what you're worth and what to rebalance. A complete investment tracker for stocks, mutual funds, ETFs, crypto, gold and more: enter each holding and see invested amount, current value, unrealised gain/loss and portfolio weight update instantly. Works in Google Sheets and Excel.
6 connected tabs:
- Portfolio Dashboard — invested, current value, total gain/loss (₹ & %), holdings count, dividend income, best performer and allocation by asset type with a chart.
- Holdings — one row per investment with quantity, buy price and current price; invested, value, gain/loss and weight are all calculated, with green/red gain colouring.
- Allocation — set a target % per asset class and get a live target-vs-actual view with Add / Trim / On-target rebalance hints.
- Dividends — a dividend & interest income log that feeds the dashboard.
Bonus: in Google Sheets you can replace the manual Current Price cell with =GOOGLEFINANCE() to auto-update live prices (kept manual by default so the file also works perfectly in Excel). Every number is a live formula — nothing hardcoded. Delivered as an .xlsx: open in Excel, or import to Google Sheets via File ▸ Import ▸ Replace spreadsheet.
- Complete Personal Finance OS (duplicate to your Notion workspace)
- Connected databases: Accounts, Transactions, Budget, Debts, Goals, Subscriptions, Net Worth Snapshots
- Dashboards: Money Command Center, Monthly Review, Net Worth, Debt Freedom, FIRE
- Pre-built formulas: savings rate, net worth, budget variance, payoff dates, interest saved
- Avalanche vs Snowball debt comparison built in
- Sinking funds & goal tracker with monthly contribution calculator
- 30+ AI money-prompt pack (spending review, journaling, negotiation)
- Video walkthrough (20+ min) + written setup guide (PDF)
- Sample data you can clear in one click · multi-currency ready
This product is perfect for:
- Individuals tracking personal finances
- Investors monitoring their portfolio
- Anyone building financial discipline
- Beginners and advanced users alike
- Remote workers and digital nomads
Customer Reviews
Excellent product! Saved me so much time. Highly recommended.
This is exactly what I was looking for. Beautiful and functional.
Great value for money. Very well organized and easy to customize.