Excel help - moving average

Wideboy

Well-known member
489 1
Calling all Excel gurus!

I have a column of numbers which I wish to calculate an ongoing a moving average for.
Which formula do I need to use to calculate it?
The AVERAGE only seems to calculate for the whole column, I want to be able to have an average in each cell as the worksheet fills up.

Wideboy
 

esiotrot

Active member
157 0
Try this:
=AVERAGE(a1:a20) for 20 period simple ma of cells A1 to A20
I've no idea how to do EMAs though!

Then drag down for each cell as required
 

Wideboy

Well-known member
489 1
Yes thanks, I had a moment of madness - I was trying to work out a 10 period MA with less than 10 numbers!!
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock