Stochastic Oscillator

The Stochastic Oscillator compares where a security's price closed relative to its price range over a given time period. The Stochastic Oscillator is displayed as two lines. The main line is called "%K." The second line, called "%D," is a moving average of %K. The %K line is usually displayed as a solid line and the %D line is usually displayed as a dotted line.

There are several ways to interpret a Stochastic Oscillator. Three popular methods include:

1. Buy when the Oscillator (either %K or %D) falls below a specific level (e.g., 20) and then rises above that level. Sell when the Oscillator rises above a specific level (e.g., 80) and then falls below that level.
2. Buy when the %K line rises above the %D line and sell when the %K line falls below the %D line.
3. Look for divergences. For example, where prices are making a series of new highs and the Stochastic Oscillator is failing to surpass its previous highs.

Stochastic Oscillator(Parameters)

1. High. The cell reference for the range of High prices.
2. Low. The cell reference for the range of Low prices.
3. Close. The cell reference for the range of Close prices.
4. Output range. The cell reference for the range of output data.
5. Period. Number of values used for calculation.
6. Slowing. Number of time periods used in the internal smoothing of the %K value. A value of 1 is considered a fast stochastic; a value of 3 is considered a slow stochastic.

Stochastic Oscillator(Syntax)

StochasticOscillator(HIGH;LOW;CLOSE;PERIOD;SLOWING;DIRECTION)

Example
=StochasticOscillator(A1:A8;K1:K8;L1:L8;5;3;1)

Stochastic Oscillator Alert

The Stochastic Oscillator compares where a security's price closed relative to its price range over a given time period. The Stochastic Oscillator is displayed as two lines. The main line is called "%K." The second line, called "%D," is a moving average of %K. The %K line is usually displayed as a solid line and the %D line is usually displayed as a dotted line.

There are several ways to interpret a Stochastic Oscillator. Three popular methods include:

1. Buy when the Oscillator (either %K or %D) falls below a specific level (e.g., 20) and then rises above that level. Sell when the Oscillator rises above a specific level (e.g., 80) and then falls below that level.
2. Buy when the %K line rises above the %D line and sell when the %K line falls below the %D line.

Look for divergences. For example, where prices are making a series of new highs and the Stochastic Oscillator is failing to surpass its previous highs.

Stochastic Oscillator Alert expert produces a Sell/Buy signal indicator bases on calculation of Stochastic Oscillator.

Stochastic Oscillator Alert(Parameters)

1. High. The cell reference for the range of High prices.
2. Low. The cell reference for the range of Low prices.
3. Close. The cell reference for the range of Close prices.
4. Output range. The cell reference for the range of output data.
5. Period. Number of values used for calculation.
6. Slowing. Number of time periods used in the internal smoothing of the %K value. A value of 1 is considered a fast stochastic; a value of 3 is considered a slow stochastic.

Stochastic Oscillator Alert(Syntax)

ALERT_D8020(HIGH;LOW;CLOSE;PERIOD;SLOWING;DIRECTION)

Example
=ALERT_D8020(A1:A18;K1:K18;L1:L18;14;1;1)

Stochastic Oscillator and RSI Alert

This alert bases on simultaneous RSI and Stochastic calculations and indicates possible buy or sells points.

Stochastic Oscillator and RSI Alert(Parameters)

1. High. The cell reference for the range of High prices.
2. Low. The cell reference for the range of Low prices.
3. Close. The cell reference for the range of Close prices.
4. Range (RSI). The cell reference for the range of RSI values.
5. Output range. The cell reference for the range of output data.
6. Period. Number of values used for calculation.
7. Slowing. Number of time periods used in the internal smoothing of the %K value. A value of 1 is considered a fast stochastic; a value of 3 is considered a slow stochastic.

Stochastic Oscillator and RSI Alert(Syntax)

ALERT_D8020_And_RSI(HIGH;LOW;CLOSE;RANGE(RSI);PERIOD;SLOWING;DIRECTION)

Example
=ALERT_D8020_And_RSI(A1:A18;K1:K18;L1:L18;G5:G18;14;3;1)