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 change and market-cap columns. Use the add-on refresh controls to update them. The optional RSI column requires Base or Pro access, including the Base trial.

What the watchlist looks like

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

Build the watchlist step by step

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")/100 — divide the percentage-point result by 100, then format C as a percentage. A raw result of -4.15 becomes -0.0415 and displays as −4.15%.
4. 7d change (D2): =cryptotrackproData(A2,"change7d")/100 — format D as a percentage too.
5. Market cap (E2): =cryptotrackproData(A2,"marketcap")
6. Optional daily RSI (14), Base/Pro (F2): =cryptotrackproRSI(A2,14) — format as a number, not a percentage. Available Kraken pairs only.
7. Drag down from row 2, then Extensions → CryptoTrackPro → Refresh All Prices.

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

• Controlled refresh: use Refresh All Prices. Timed refresh requires the sidebar open: Base every 30 minutes, Pro every 5 minutes, within lookup limits.
• Separate coverage: current prices use CoinMarketCap data; daily RSI requires a supported Kraken pair. A working price does not guarantee RSI availability.
• Reporting currencies: request supported pairs such as BTC-EUR or BTC-GBP. Market cap remains USD; indicator currency coverage depends on Kraken markets.
• Free price watchlist: 50 lookups a day. Daily RSI requires Base or Pro, including the 30-day Base trial. Indicator caching is approximately 15 minutes.

Frequently asked questions

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

A watchlist focuses on prices and momentum for coins you are monitoring. A portfolio tracker adds holdings and acquisition records to calculate value and performance. Keep both in separate tabs.

Can I add stocks or gold to the same watchlist?

You can add tokenized real-world asset references with =cryptotrackproRWA("AAPL") or =cryptotrackproRWA("GOLD"). These are token quotes, not official exchange quotes for broker-held shares or physical gold. Label them separately; see the RWA guide.

Is it really free?

The Free plan includes 50 daily lookups for prices and market data. RSI requires Base or Pro, including the 30-day Base trial offered to new eligible accounts without a card. After the trial, the account returns to Free unless you subscribe. Compare plans.

Why divide the percentage-change formula by 100?

The function returns percentage points: −4.15 means −4.15%. Dividing by 100 gives −0.0415, which Sheets correctly displays as −4.15% using percentage formatting. Apply the same conversion to the 7-day change.

See also: daily RSI setup and limitations → · crypto portfolio template → · investment tracker → · crypto in sheets →