|
PureBytes Links
Trading Reference Links
|
>>I looked more closely at the values. It appears that what MS is
doing is taking the first data point and treating it as though it was
the simple average (i.e. start point) and then calculates EMAs based
on that point. However, it only displays data starting with the 5th
day. That method will lead to a small difference in the two methods.<<
Ron,
I am totally lost. I apologize but I have no clue. My goal is to have
Excel match my MetaStock calculations. Can you upload another
spreadsheet, that matches as best you can.
I want to calculate the 5 day Moving Average Exponential. The current
day is first, then days minus 1. Here is the data:
1098.63
1106.300049
1117.859985
1112.890015
1109.099976
1107.22998
1108.02002
1121.699951
1135.910034
1132.910034
MetaStock says the 5 day Moving Average Exponential is:
1111.514.
I don't care about rounding, but when I plugged the numbers into the
downloaded spreadsheet, your cell B11 = 1124.612.
These numbers are way different. Is the excel spreadsheet cell that
has the answer cell B11?
larryTAKEOUT@xxxxxxxxxx
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Metastockusers/
<*> To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|