Free template

Free investment tracker for Google Sheets

One sheet for your whole portfolio — stocks, ETFs, gold and crypto — with live value, allocation and profit/loss. No API key, no code, free to start.

The simplest free investment tracker for Google Sheets is the CryptoTrackPro add-on: it prices stocks with =cryptotrackproRWA("AAPL") and crypto with =cryptotrackpro("BTC-USD"), so a single sheet tracks your entire net worth — live, and for free. Here's the template and how to get it.

What the tracker looks like

Asset Type Holdings Live price Value Weight
BTCCrypto0.5$77,302$38,65142%
AAPLStock40$309$12,37613%
SPYETF50$642$32,10035%
GOLDCommodity2.5$3,940$9,85010%
Net worth$92,977100%

Prices shown are examples. In your sheet the Live price and Value columns are formulas that update on their own.

Get the free template

Install the add-on, open the sidebar, and click Portfolio — it builds the sheet for you. Free plan, no API key, no card.

Install free & load the template

Or build it yourself in 2 minutes

  1. Columns: Asset · Type · Holdings · Live price · Value · Weight.
  2. Live price (column D): crypto uses =cryptotrackpro(A2 & "-USD"); stocks, ETFs and commodities use =cryptotrackproRWA(A2).
  3. Value (column E): =C2*D2 — drag down.
  4. Net worth: =SUM(E2:E5).
  5. Weight (column F): =E2/$E$6 — format as a percentage.

Want profit/loss too? Add a Cost column (what you paid) and a P&L column with =E2-(C2*Cost). For historical buy prices, =cryptotrackproPrice("BTC","2021-04-14") returns the price on any date.

Why this beats a manual tracker

Frequently asked questions

Is it really free?

Yes — 50 lookups a day on the free plan, no API key or card. Base and Pro raise or remove the limit for larger portfolios.

Can I track just crypto, or just stocks?

Either — use whichever formula you need. See the crypto portfolio guide or stock prices guide.

Note: stock, ETF and commodity prices are tokenized real-world-asset prices that closely track — but aren't official exchange quotes for — the underlying asset. Not financial advice.

See also: stocks & crypto together → · crypto portfolio tracker → · crypto in sheets →