Crypto RSI in Google Sheets: formula and daily watchlist

By CryptoTrackPro · Published 9 September 2026 · Examples checked against the current formula implementation

=cryptotrackproRSI("BTC",14,"USD") returns the latest available 14-period RSI for Bitcoin against USD. CryptoTrackPro calculates RSI from daily Kraken candles using Wilder-style smoothing. The number is useful for organizing a watchlist, provided you keep the period, market and observation time consistent. A 14-period value here refers to daily candles, not 14 minutes or 14 hours.

Build a small research table first

Install the add-on, open Extensions → CryptoTrackPro → Open CryptoTrackPro, and confirm that your account has Base, Pro or the Base trial. RSI is a paid feature; a Free account can still retrieve current prices within its allowance but cannot make new RSI requests.

Use columns A through E for Symbol, Period, Quote, RSI and Research note. Start with BTC and ETH before adding the rest of your list. The example readings below are invented to demonstrate the layout, not current indicators.

Enter this in D2 and fill down only through rows with valid inputs:

=cryptotrackproRSI(A2,B2,C2)

Format the result as a number with two decimal places, not a percentage. RSI is reported on a scale from 0 to 100. Formatting 48.25 as a spreadsheet percentage would display 4,825%, which changes the meaning of the presentation.

Make the period explicit

The default period is 14, and the supported range is 2 through 100. For repeatable comparisons, enter a valid integer in the Period column instead of relying on defaults or automatic limits. A shorter period responds to recent daily movements differently from a longer one, so keep separate column headings when comparing them:

=cryptotrackproRSI("BTC",7,"USD")
=cryptotrackproRSI("BTC",14,"USD")
=cryptotrackproRSI("BTC",28,"USD")

Label these as daily RSI(7), daily RSI(14) and daily RSI(28). Changing the period does not change the candle interval. The function does not accept a separate hourly timeframe argument. If your chart uses hourly candles, its RSI is answering a different question.

Record observations without inventing a signal history

This function returns a current reading, not an entire historical RSI series. To keep a review log, copy the ticker, period, quote and result to a dated tab using Paste special → Values only. Enter the observation time as a fixed value. A formula left in yesterday's row will eventually show a later reading and should not be treated as yesterday's observation.

Keep a short research note next to each snapshot: for example, the chart interval you compared or a data issue you noticed. Conditional formatting can help scan readings, but a colored cell is a display choice rather than evidence that a trade will succeed. Avoid labeling a single threshold as an automatic instruction to buy or sell.

Understand differences from a chart

Start a comparison with the same asset, quote currency and daily timeframe. CryptoTrackPro uses Kraken data, so a chart from a different exchange can legitimately differ. The live-price function has broader coverage; a coin having a current price does not mean the corresponding RSI pair is supported. EUR or GBP indicators require the corresponding available Kraken market. The USD lookup can fall back to a USDT pair where a direct USD market is absent.

Kraken includes the current unfinished candle in its OHLC response, and the add-on's calculation currently includes that candle. The latest RSI can therefore move before the daily candle closes. This behavior is described in Kraken's OHLC documentation. A chart configured to use only completed candles can show a different value.

Results also use a roughly 15-minute indicator cache. Pro's 5-minute sidebar refresh does not guarantee a freshly recomputed RSI every five minutes. Keep the sidebar open for timed refreshes, check your lookup balance, and allow the indicator cache window before investigating unchanged readings as an error.

Keep an unavailable result visible

If a row returns an error, test the same formula with BTC and USD, confirm paid or trial access, and check the original pair's availability. Do not replace failures with zero: zero is a valid-looking number on the RSI scale. Use the troubleshooting workflow and share the formula and error with support if the issue continues.

Frequently asked questions

Can I calculate hourly RSI with this formula?

No. CryptoTrackPro RSI currently uses daily candles. The period argument changes the number of daily periods used in the calculation, not the candle interval.

Why does RSI differ from my exchange chart?

Check the exchange, quote currency, period, candle interval and whether the chart includes the current unfinished candle. Indicator caching can also affect when a new value appears.

Continue with: Add MACD columns · Build a broader watchlist · All guides