Stochastic RSI (STOCH-RSI)
Combines the Relative Strength Index (RSI) with stochastic calculations to measure the position of the RSI relative to its range over a specified period.
Function Syntax
=STOCH_RSI(data, period, smoothing)
data
(array):
Range of columns containing the date, Open, high, Low, close, volume data.period
(number):
The number of periods (days) used to calculate the RSI.smoothing
(number): The number of periods used to smooth the %K values into the %D signal line.
Returns:
A three-column array of dates and their corresponding %K and %D values.
Output Example
Below is an example of the resulting array when applying the custom =STOCH_RSI() function.