Wiki JStore Search Login

Calculating RSI Indicator values
 Post subject: Calculating RSI Indicator values Post rating: 0   New post Posted: Wed 12 Apr, 2023, 03:26 
User avatar

User rating: 2
Joined: Fri 02 Mar, 2012, 22:08
Posts: 200
Location: New Zealand, Dunedin

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

Bob M

RSI-calc.xlsx [11.75 KiB]
Downloaded 290 times
DISCLAIMER: Dukascopy Bank SA's waiver of responsability - Documents, data or information available on this webpage may be posted by third parties without Dukascopy Bank SA being obliged to make any control on their content. Anyone accessing this webpage and downloading or otherwise making use of any document, data or information found on this webpage shall do it on his/her own risks without any recourse against Dukascopy Bank SA in relation thereto or for any consequences arising to him/her or any third party from the use and/or reliance on any document, data or information found on this webpage.
 Post subject: Calculating RSI Indicator values Post rating: 0   New post Posted: Wed 24 May, 2023, 11:09 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6137

I kindly wanted to draw your attention to the fact that strategy works with GMT by default.
There is a popular problem when users use different parameters assigned to "Time zone" and "Day Start Time". (Settings -> Preferences -> General).
You can learn the difference between "Time zone" and "Day Start Time" here:
https://www.dukascopy.com/wiki/en/manua ... e-settings

Please make sure that in your platform you use also GMT for these parameters.

I do not recommend you to change time zone in strategy, but you can do it as described here:
https://www.dukascopy.com/wiki/en/devel ... -date-time
https://www.dukascopy.com/client/javado ... eZone.html

Kind regards,
Dukascopy Bank


Jump to:  

  © 1998-2011 Dukascopy® Bank SA
On-line Currency forex trading with Swiss Forex Broker - ECN Forex Brokerage,
Managed Forex Accounts, introducing forex brokers, Currency Forex Data Feed and News
Currency Forex Trading Platform provided on-line by Dukascopy.com