Track portfolio value, P&L in $ and %, and allocation with a ready-made Google Sheet. Copy the free template, install CryptoTrackPro and refresh your prices. No API key required.
Make your own copy in Google Drive, install and authorize the add-on, then open CryptoTrackPro from the Extensions menu. Enter your holdings and choose Refresh All Prices to update your portfolio.
Copy Template to Google Drive →Requires the CryptoTrackPro add-on for live prices. First-time users get a 30-day Base trial, no card required, then continue on Free unless they subscribe. Compare plans.
Everything you need to track your crypto portfolio in one sheet.
Every row is pre-wired with =cryptotrackpro(). Prices refresh whenever you run Refresh All Prices 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. In your copy of the sheet, choose Extensions → CryptoTrackPro → Open CryptoTrackPro to connect your account.
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 All Prices to fetch live prices. P&L values and the summary row recalculate from the refreshed prices.
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 10,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.