how to do a 50 day and 200 day moving average
 

hi all,
im trying to run a 50 and 200 day moving avg from values of an index. i have
about 1500 values. to do a 50 day moving avg do i choose as my input range
the last 50 days or do i select the whole range of values?

how to do a 50 day and 200 day moving average
 

Giovanni,

You would only use the 50 items, otherwise you will get a skewed average.

It will all depend upon how your data is organised and how you try to use,
that is how you identify what are the latest 50.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"giovanni" wrote in message
...
hi all,
im trying to run a 50 and 200 day moving avg from values of an index. i
have
about 1500 values. to do a 50 day moving avg do i choose as my input range
the last 50 days or do i select the whole range of values?

how to do a 50 day and 200 day moving average
 

Hi giovanni;
Say your dates are in column A and your measurements are in column B. In C1
(or any un-used column) enter:

=IF(A1+50=TODAY(),B1,"") and copy down. C will contain measurements with
the last 50 days. Any else enter =AVERAGE(C:C)
--
Gary's Student


"giovanni" wrote:

hi all,
im trying to run a 50 and 200 day moving avg from values of an index. i have
about 1500 values. to do a 50 day moving avg do i choose as my input range
the last 50 days or do i select the whole range of values?