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/
|