- Katılım
- 23 Eki 2020
- Mesajlar
- 1,826
Re: Different RSI in MetaStock ? * To: <metastock@xxxxxxxxxxxxx> * Subject: Re: Different RSI in MetaStock ? * From: "billhebert" <billhebert@xxxxxxxxxxx> * Date: Sun, 20 Jan 2002 12:45:28 -0800 * Cc: <o.goedknegt@xxxxxxxxx>, <rlarsen@xxxxxxxxxxxxxx> * References: <1915b14942.149421915b@xxxxxxxxx> * Reply-To: metastock@xxxxxxxxxxxxx * Sender: owner-metastock@xxxxxxxxxxxxx ----- Original Message ----- From: "onno goedknegt" <o.goedknegt@xxxxxxxxx> To: <pdmanager@xxxxxxxxxxxxxxxxx> Cc: <metastock@xxxxxxxxxxxxx> Sent: Thursday, December 20, 2001 11:42 AM Subject: Different RSI in MetaStock ? > Dear Sirs, > > It looks like other MetaStock users noticed the following fact: > > It seems that the calculation for RSI in MetaStock differs from the standard RSI calculation. > > I'm trying to "translate" my MetaStock trading system into an Excel sheet. > And because my MetaStock trading system contains RSI, I need to "translate" the RSI calculation into Excel. > > Attached Excel sheet contains my RSI calculation (sheet: calc 1). > Other calculations downloaded from the Internet give the same values for RSI as my calculation (sheet: calc 2). > > MetaStock RSI values are shown in red. > > 1. Which version is correct ? > 2. How does MetaStock calculate their RSI ? > 3. Can you give the exact formula how MetaStock's RSI is calculated? > > Kind regards, > Onno Onno, I have tested the following code and I beleive it will fix your RSI problem - Bill Hebert |
|
Relative Strength Index - Custom IV A:=Input("RSI periods",2,50,14); B:=C; {RSI target array} U:=If(B>Ref(B,-1),B-Ref(B,-1),0); D:=If((B<Ref(B,-1) OR (B=Ref(B,-1))),Ref(B,-1)-B,0); UE:=Wilders(U,A); DE:=Wilders(D,A); 100-(100/(1+(UE/DE))); |
Source / From: |