Free crypto watchlist template for Google Sheets

A crypto watchlist is for the coins you're monitoring — not necessarily ones you own. With the free CryptoTrackPro add-on you list your tickers in one column and let a handful of formulas fill in the rest: =cryptotrackpro("BTC-USD") for live price, plus momentum and market-cap columns that refresh on their own. Here's the layout and how to build it.

What the watchlist looks like

Prices shown are examples. In your sheet every column except Coin is a formula that updates on refresh.

Build it yourself in 2 minutes

1. Column A — Coin: type one ticker per row, e.g. BTC, ETH, SOL.
2. Live price (B2): =cryptotrackpro(A2 & "-USD")
3. 24h change (C2): =cryptotrackproData(A2,"change24h") — returns a decimal like -4.15; format the column as a percentage.
4. 7d change (D2): =cryptotrackproData(A2,"change7d")
5. Market cap (E2): =cryptotrackproData(A2,"marketcap")
6. RSI (14) (F2): =cryptotrackproRSI(A2,14)
7. Drag down from row 2, then Extensions → CryptoTrackPro → Refresh Data.

Want a green/red look? Select the change columns and add a Conditional format rule: greater than 0 → green, less than 0 → red.

Reading the momentum columns

• 24h / 7d change shows short- and medium-term direction at a glance.
• RSI (Relative Strength Index) is a 0–100 momentum gauge. It's conventionally read as below 30 = oversold and above 70 = overbought — a signal some traders watch, not a recommendation.
• Market cap gives context — a 5% move on a $10B coin is very different from one on a $200M coin.

Why build it here

• Live, not stale: columns refresh themselves — no copy-pasting from price sites.
• 10,000+ coins: any ticker on CoinMarketCap works, including small caps.
• Any currency: swap -USD for -EUR, -GBP and 150+ more.
• Free: 50 lookups a day, no API key, no card.

Frequently asked questions

What's the difference between this and a portfolio tracker?

A watchlist focuses on price and momentum for coins you're monitoring. A portfolio tracker adds your holdings and buy price to compute value and profit/loss. Keep both as separate tabs in one sheet.

Can I add stocks or gold to the same watchlist?

Yes — use =cryptotrackproRWA("AAPL") for stocks, ETFs and commodities. See the investment tracker for a mixed sheet.

Is it really free?

Yes — 50 lookups a day on the free plan. Base and Pro raise or remove the limit for bigger watchlists that refresh often.

See also: crypto portfolio template → · investment tracker → · crypto in sheets →