Get a single RSI value in one cell

Use SF_TECHNICAL with a short date range and INDEX to return the latest RSI in a single cell.

Single-cell RSI formula

The RSI function returns a column of dates and RSI values. To keep only the latest value, wrap the call with INDEX(..., 1, 1).

Put the current date (TODAY()) in a cell, for example $A$1, and reference it from the formula. This keeps the sheet fast because Google Sheets recalculates TODAY() every time anything changes.

=INDEX(SF_TECHNICAL("AAPL", "14rsi", "daily", $A$1-1, $A$1), 1, 1)

Performance tip: Put =TODAY() in one cell and reference that cell everywhere you need the current date. Google Sheets recalculates TODAY() on every sheet change, so calling it in many formulas slows the sheet down. For more details, see Performance Tips.

How it works

SF_TECHNICAL returns an array where the first column is the date and the second column is the RSI.
Because the latest date is the first row, INDEX(..., 1, 1) returns the most recent RSI value.
Using $A$1-1 to $A$1 keeps the array small and fast.

Other lookback periods

Change the number before rsi to adjust the period.

RSI(21): "21rsi"
RSI(14): "14rsi"

=INDEX(SF_TECHNICAL("AAPL", "21rsi", "daily", $A$1-1, $A$1), 1, 1)

Adding the date beside the value

If you want the date and RSI in two adjacent cells, use INDEX with row 1 and column 1 for the date, and row 1 and column 2 for the RSI.

=INDEX(SF_TECHNICAL("AAPL", "14rsi", "daily", $A$1-1, $A$1), 1, 1)

=INDEX(SF_TECHNICAL("AAPL", "14rsi", "daily", $A$1-1, $A$1), 1, 2)

What is next

For full technical-analysis options, read Technical Analysis. For more on limiting output, see Get a single value from a multi-row function.

Was this helpful?