how to do a 50 day and 200 day moving average

G

giovanni

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?
 
B

Bob Phillips

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)
 
G

Gary''s Student

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)
 
Top