Stochastic RSI (STOCH-RSI)

The Stochastic RSI (StochRSI) is a technical indicator that measures the momentum of the Relative Strength Index (RSI), rather than price itself. It is created by applying the Stochastic Oscillator formula to a set of RSI values. The result is a more sensitive oscillator that fluctuates between 0 and 100, designed to identify short-term overbought and oversold conditions with greater frequency than the standard RSI. This increased sensitivity allows traders to pinpoint potential entry and exit points within a broader trend identified by the RSI.

STOCH_RSI

=STOCH_RSI(data, period, smoothing)

Example Usage

=STOCH_RSI(A2:F500, 14, 3)

Parameters

Parameter Type Description Status
data
Range
Range of columns containing the date, Open, high, Low, close, volume data.
 Required
period
Number
The number of periods (days) used to calculate the RSI.
 Required
smoothing
Number
The number of periods used to smooth the %K values into the %D signal line.
 Required

Returns

A three-column array of dates and their corresponding %K and %D values.

Stochastic RSI Formula Result in Google Sheets