Hi
I am puzzled about the above calculation.................
I have setup a simple excel spreadsheet to do the calculation but the results seem way different to the results I see on a chart
I am looking at the EUR/USD hourly figures for the end of December 2022
The formula I am using is RSI = 100 - ((1 + (average gain / average loss))) where avg gain and avg loss is over 14 hour period
In the last column I have noted the last few actual values I see from an hourly EUR/USD chart with the RSI Indicator
Why is there such a large difference between what I am calculating and what I see on the chart
Cheers
Bob M
| Attachments: |
RSI-calc.xlsx [11.75 KiB]
Downloaded 538 times |