Build a crypto portfolio tracker in Google Sheets

A spreadsheet is still the most flexible crypto portfolio tracker there is — you own the data, you decide the columns, and nothing gets locked behind a subscription you can't export. The one thing Sheets can't do alone is fetch live prices. Here's how to add that and build a tracker that keeps itself current.

The one-click way

With the free CryptoTrackPro add-on installed, open Extensions → CryptoTrackPro → Open CryptoTrackPro and click Portfolio. You get a ready-made tracker with holdings, average cost, current price, value, profit/loss, and allocation columns — just fill in your numbers. Prefer to build it yourself? It's four columns.

Build it from scratch

1. List your coins and holdings. Symbols in column A, amounts in column B:

A2 = BTC, B2 = 0.5

2. Pull live prices. In C2, reference the symbol cell so you can drag it down:

=cryptotrackpro(A2 & "-USD")

3. Calculate value. In D2, holdings × price:

=B2*C2

4. Add allocation %. In E2, each holding's share of the total (drag down, keep the total absolute):

=D2/SUM($D$2:$D$100)

Format E as a percentage and you have a live allocation breakdown. Add a =SUM(D2:D100) at the bottom for total portfolio value.

Add profit & loss

Put your average buy price in a column (say F), then unrealised P&L is current value minus cost:

=D2-(B2*F2)

For P&L %, divide that by your cost basis. Don't know your old buy prices? Pull them automatically with historical prices: =cryptotrackproPrice("BTC","2024-01-15").

Keep it current

Click Refresh All Prices in the sidebar anytime, or turn on Auto-Refresh so your portfolio updates every 30 minutes (Base) or 5 minutes (Pro) while the sheet is open. No manual work before you check your numbers.

Frequently asked questions

How do I track a crypto portfolio in Google Sheets?

List coins and holdings, use =cryptotrackpro(A2 & "-USD") for live prices, and multiply by holdings for value. The Portfolio template does it in one click.

Does it update automatically?

Yes — refresh on demand, or auto-refresh every 30 / 5 minutes on Base / Pro.

Can I see profit and loss?

Add an average-cost column; P&L is value minus cost. The template includes it, along with live prices and allocation.

See also: crypto tax & cost basis in Google Sheets →