How to calculate Stochastic Oscillator within Excel?

[Eric]

Does anyone have any suggestions on how to calculate Stochastic Oscillator
within Excel?
Date is under column A
Open is under column B
High is under column C
Low is under column D
Close is under column E

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Gary''s Student]

In column F:

=100*(E1-D1)/(C1-D1)

 

[Cheers,]

Hi,

This is typical of stock market analysis. You can look here for details

http://stockcharts.com/school/doku.php?id=chart_school:technical_indicators:stochastic_oscillator

If this helps, please click the Yes button

Cheers,
Shane Devenshire