Stochastic (STOCH)

Measures the relationship between the current close and the range of highs and lows over a specified period.

Function Syntax

=STOCH(data, period)
  • 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 Stochastic Oscillator.

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() function.

stoch return array