[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] RSI does anyone have tried manualy ?



PureBytes Links

Trading Reference Links

Thanks Tom.

I'll try it.

I'm already using Wilder's smoothing, and I assured the data for calculation 
is the same.

But I do not attemp for the number of bars.

I'll post the results soon.

Best regards.

Mormax.



----- Original Message ----- 
From: "Tom Sprunger" <tlsprunger@xxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Thursday, April 28, 2005 4:48 PM
Subject: Re: [EquisMetaStock Group] RSI does anyone have tried manualy ?


> You should be able to get Excel to come very close to Metastock providing:
> 1.you must use Wilder's smoothing in Excel,
> 2.you must use the same data for Excel and Metastock.  (Open the 
> Downloader
> and copy the data out of there to Excel to be sure).
> 3. you compare data at same places in the price series.  I.e  you compare 
> at
> the 20th bar loaded, or 100th bar loaded or 500th bar or whatever.
>
> I say "come very close" because with Excel you have something like 32 bits
> of precision on the calculation whereas Metastock does not have that many.
> Also,from memory ( and it could be faulty), sometimes MS rounds off or
> truncates.  For example, maybe it rounds RS to a whole number prior to 
> doing
> the actual RSI calculation.  If it does that you will be off a little bit
> also.
>
> If you want to find out where you are off, program a custom indicator in 
> MS.
> Build the RSI as an indicator in pieces, one at a time, and compare the
> pieces to your  Excel columns.  For example take Preston's formula and see
> what Metastock gives you for the Z values, the Y values, RS, and then
> finally RSI.  Those intermediate steps should compare closely with your
> Excel spreadsheet.
>
> If you get with in 0.1 or 0.2 you should consider yourself matched.
>
>
> ----- Original Message ----- 
> From: "Mormax" <mormax_trader@xxxxxxxxxxxx>
> To: <equismetastock@xxxxxxxxxxxxxxx>
> Sent: Thursday, April 28, 2005 11:29 AM
> Subject: [EquisMetaStock Group] RSI does anyone have tried manualy ?
>
>
>> I've tried manualy and the results wasn't the same !
>>
>> am i doing something wrong ?
>>
>> I've used the same method that MS uses to calculate de RSI (at least the
>> method tha's in help).
>> The results was reasonable, but not identical.
>> (the results are attached)
>>
>>
>>
>> What moving average MS uses to calculate RSI ? 'cause i've tried EMA too.
>>
>>
>> If anyone can help me, i'll be grateful
>>
>>
>>
>> Thanks,
>>
>> MORMAX.
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> 








------------------------ Yahoo! Groups Sponsor --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/