I need help with the way MetaTrader 4 calculates Stochastic Oscillator. I have done some research regarding the formula to calculate Stoch (5,3,3),Stoch (5,4,3). However, using the Metatrader's historical data, my calculation results are always different from MetaTrader's. I hope someone can formulate an Excel spreadsheet to recalculate Stoch (5,3,3) and Stoch (5,4,3) in agreement with Metatrader's calculation with decimal point precision of 6
Please use the July 1, 2008 - July 20, 2008 EURUSD 30-min historical data when prepare the spreadsheet.