Chart with 39-week moving average

  • Thread starter Thread starter Herbert Chan
  • Start date Start date
H

Herbert Chan

Hello,

I have a spreadsheet that pulls data on the click of a button from the
internet the daily fund prices. I want to be able to produce charts with
39-week moving averages.

My excel is 97 and I've just found out that the greatest number allowed for
moving average is 35. Any way I can produce the moving average by Excel
directly without me creating a separate sheet to calculate the 39-week
moving averages myself??

Thanks.

Herbert
 
I don't believe 35 is the limit on the # periods in a moving average
trendline. The limit is the number of data points in the series. So,
if you have 39 or more points in the series, XL will let you create a
39 week moving average trendline.

That said, one can always compute a moving average through worksheet
cells. Assuming your data are in A1:A{n}, in B39 enter =AVERAGE
(A1:A39). Copy B39 down column B as needed. Alternatively, adapt the
idea behind the 'Graph only the last so many entries in a data series'
example at http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/index.html#LastSoMany

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks!

I'm very stupid, just found out I've just at the moment 36 data points!

Thanks Tushar, you have there in your website a lot of useful and very
practical tips.

Herbert
 
Back
Top