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

"14rsi" returns one column of RSI values, with no date column unless you ask for one. Add "NH" to remove the header row so the first row is the latest value, then 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,"NH"),1,1)

How it works

1. "14rsi" returns RSI only, in column 1. Date is not included unless you request it with "date" or "all".

2. "NH" removes the header row, so the first row of the returned array is data.

3. Results come back newest first, so row 1 is the most recent RSI value and INDEX(..., 1, 1) returns it.

4. 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,"NH"),1,1)

Adding the date beside the value

Request the date with "14rsi&date" to get two columns: date in column 1 and RSI in column 2. Then 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&date","daily",$A$1-1,$A$1,"NH"),1,1)

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

Multiple stocks

Put tickers in A2:A5 and =TODAY() in $F$1, then enter this formula in B2 and fill it down to get the latest RSI for each ticker.

=INDEX(SF_TECHNICAL(A2,"14rsi","daily",$F$1-1,$F$1,"NH"),1,1)

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.