|
PureBytes Links
Trading Reference Links
|
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
|