|
PureBytes Links
Trading Reference Links
|
the 'equis' way to compute the 21-day Average True Range is:
Mov(ATR(1),21,x)
where x = S or E or W etc.
and is upose to Wilders' smoothing ATR(21), eg Mov(ATR(21),1,x).
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying and
note the new address change. Also for my Homepage
http://home.planet.nl/~anthmaas
----- Original Message -----
From: Barry Marx <bmarx@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: vrijdag 31 december 1999 6:17
Subject: Re: Heat Map explained - MetaStock Formula Discrepancy
> Thanks for posting the link, Walter.
> I tried to reproduce the results in MetaStock for the spreadsheet posted in
> the link, but I am getting quite different numbers. Here's 14 days of data
> for a stock, TESI, that I follow:
>
> Today's
> Moving
> Average
> Average
> True
> True
> DATE HIGH LOW CLOSE Range Range
> Thu 12/30/99 $8.63 $7.06 $8.25 1.5625 $1.72
> Wed 12/29/99 $9.00 $7.31 $8.50 $1.88 $1.73
> Tue 12/28/99 $9.88 $6.50 $9.19 $3.38 $1.71
> Mon 12/27/99 $6.75 $5.63 $6.50 $1.13 $1.53
> Thu 12/23/99 $7.00 $4.75 $6.50 $2.25 $1.48
> Wed 12/22/99 $5.13 $4.00 $4.75 $1.13 $1.35
> Tue 12/21/99 $6.06 $4.88 $5.00 $1.25 $1.31
> Mon 12/20/99 $6.38 $6.00 $6.13 $0.38 $1.33
> Fri 12/17/99 $6.88 $6.00 $6.38 $0.88 $1.35
> Thu 12/16/99 $7.00 $6.13 $6.88 $0.88 $1.31
> Wed 12/15/99 $7.25 $5.25 $6.88 $2.00 $1.27
> Tue 12/14/99 $8.13 $3.75 $6.75 $4.38 $1.14
> Mon 12/13/99 $5.50 $3.06 $5.13 $2.44 $0.83
> Fri 12/10/99 $3.38 $2.88 $3.31 $0.63 $0.67
>
>
> When I tried to reproduce the spreadsheet results with MetaStock indicators,
> I used the formula ATR(1) for the column "Today's Average True Range". The
> results for this matched those from the spreadsheet. However, when I used
> the formula ATR(14) to compute the 14-day Average True Range (the rightmost
> column in the above spreadsheet exerpt), the MetaStock results were quite
> different from those in the spreadsheet (the spreadsheet appears to me to be
> doing the calculation correctly). For example, my MetaStock results for the
> five most recent days for the "Moving Average True Range" column (using the
> ATR(14) formula) were:
>
> 1.315
> 1.296
> 1.251
> 1.088
> 1.085
>
> Any ideas as to why there is a difference? Does the MetaStock ATR indicator
> use a *simple* moving average, as opposed to some other method? I didn't
> see anything to indicate otherwise in the MS help.
>
> Thanks,
> Barry
>
>
>
>
>
>
> ----- Original Message -----
> From: Walter Lake <wlake@xxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Thursday, December 30, 1999 6:34 PM
> Subject: Re: Heat Map explained
>
>
> > Hi Jim and others who have written
> >
> > This is a nice "ATR stops for your portfolio.xls" with lots of VBA code
> both
> > in the .xls and as .txt ... .
> >
> >
> http://content.communities.msn.com/isapi/fetch.dll?action=get_message&ID_Com
> >
> munity=MoneyCentralSuperModels&ID_Message=1111&ID_Last=0&Dir=0&ID_Topic=0&La
> > stModified=942056506000
>
>
>
|