Live prices for 1,000+ coins, automatic P&L in $ and %, colour-coded gains & losses — copy to your Drive in seconds. No setup, no API key, free forever.
Click the button below to make your own copy in Google Drive. Enter your holdings and the live prices update automatically — no spreadsheet setup required.
Copy Template to Google Drive →Requires the free CryptoTrackPro add-on for live prices. · Your copy is private — we never see your data.
Everything you need to track your crypto portfolio in one sheet.
Every row is pre-wired with =cryptotrackpro(). Prices refresh whenever you run Refresh Data from the Extensions menu.
Enter your holdings and average buy price. Current Value, Cost Basis, P&L $, and P&L % are all calculated for you automatically.
Gains show in green, losses in red — both in the P&L columns and the portfolio summary row. No manual formatting needed.
A pinned summary row shows your Total Value, Total Cost Basis, overall P&L $, and overall P&L % across all holdings.
Each asset row automatically calculates its share of your total portfolio, so you can spot concentration risk at a glance.
BTC, ETH, SOL, XRP, ADA, DOGE, AVAX, LINK, DOT, and POL are already set up. Add or replace any row with your own holdings.
Four steps to a live portfolio tracker.
Click Copy Template to Google Drive above. Google will open the sheet and prompt you to save a copy — click Make a copy.
If you haven't already, install the free CryptoTrackPro add-on from the Google Workspace Marketplace and authorize it.
Fill in your Holdings (how many coins you own) and Avg Buy Price (what you paid per coin) for each row. The blue columns are your input cells.
Click Extensions → CryptoTrackPro → Refresh Data to fetch live prices. All P&L values and the summary row update instantly.
Know what each column does at a glance.
| Column | Type | Description |
|---|---|---|
| Ticker | Your input | Symbol used in the formula, e.g. BTC. Combined with -USD automatically. |
| Holdings | Your input | How many coins/tokens you own. Blue-tinted column. |
| Avg Buy Price | Your input | Your average purchase price per coin in USD. Blue-tinted column. |
| Live Price | Formula | Fetched live from CoinMarketCap via =cryptotrackpro(). Updates on each refresh. |
| Current Value | Formula | Holdings × Live Price. Total USD value of your position. |
| Cost Basis | Formula | Holdings × Avg Buy Price. What you originally paid. |
| P&L $ | Formula | Current Value − Cost Basis. Green if positive, red if negative. |
| P&L % | Formula | Percentage return on each position. Green/red conditional formatting applied. |
| Portfolio % | Formula | This asset's share of your total portfolio by current value. |
Everything you need to know about the free crypto portfolio tracker template.
PEPE, WIF, or INJ. The formula automatically appends -USD and fetches the live price. CryptoTrackPro supports 1,000+ cryptocurrencies via CoinMarketCap.
ETH-EUR or SOL-GBP — and edit the formula accordingly. CryptoTrackPro supports USD, EUR, GBP, AUD, CAD, JPY, CHF, CNY, INR, KRW, BRL, ZAR, BTC, and ETH as quote currencies.
Get the template and the free add-on — up and running in under 5 minutes.