logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
boy5176  
#1 Posted : Friday, December 13, 2019 4:46:49 AM(UTC)
boy5176

Rank: Newbie

Groups: Registered, Registered Users
Joined: 5/26/2013(UTC)
Posts: 3

I am creating simple explorations as below but seems like the RSI  from the explorations are not matching with the real one on the graph

Column A = Cross(RSI(C,30),30) Column B = RSI(C,30) Column C = C

Can anybody please help me if i am wrong with something ?

Thanks in advance

Below is sample image

​​​​​​​

Edited by user Friday, December 13, 2019 5:58:05 AM(UTC)  | Reason: Not specified

daveskis2019  
#2 Posted : Monday, December 23, 2019 9:08:51 PM(UTC)
daveskis2019

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 11/23/2019(UTC)
Posts: 2
Location: Brisbane

Hi boy5176

I wonder whether your issue is related to Wilders Smoothing. In RSI, RS uses a simple average of the up and down closes. In Wilder's RSI, RS uses Wilder's smoothing which is a different form of exponential averaging.

Non-Wilders RSI looks like this:

A:=Input("Periods",2,99,14); 

B:=C; {target array} 

U:=Sum(If(B>Ref(B,-1),B-Ref(B,-1),0),A); 

D:=Sum(If(B<Ref(B,-1),Ref(B,-1)-B,0),A); 

100-(100/(1+(U/Max(D,.00001))));

As opposed to Wilders, which looks like this:

{RSI Indicator} 

A:=Input("Periods",2,99,10); 

B:=C; 

{target array} 

U:=Wilders(If(B>Ref(B,-1),B-Ref(B,-1),0),A); 

D:=Wilders(If(B<Ref(B,-1),Ref(B,-1)-B,0),A); 

100-(100/(1+(U/D)));

Test to see if either of these match your result.

MS Support  
#3 Posted : Thursday, January 2, 2020 5:23:58 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)

Hello,

It is possible that within the "Options" button the Load Minimum Records option could allow discrepancies between the chart and the exploration. The problem with Load Minimum Records is that it does not account for exponential calculations needs. It looks for the minimum records required to perform the calculation. This is fine for simple calculations but can result in inaccuracies with weighted/exponential calculations.

When Editing an exploration there is also an "Options" button within the Exploration Editor. You will want to make sure you are running the scan for the Most Recent Data (as opposed to a specific date) typically.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.