Moving average

[yaelcohen]

Hi to you

Thanks for your help

I want to get a moving average of the last 12 months for each line. I know I can do it with DATA ANALYSIS in excel but I understand that I have to do it for each stock every time while I have a long list of stocks and data.

I attached an example in this file and I appreciate your help

Thanks a lot!

 

[Hui]

Firstly
I would rearrange you data to have Dates as Proper dates, not Year and Month
You could do that in the data or add a new column say G:
G3: =DATE(C3,D3,1)
Copy down

Then setup a list of dates and an Input for the Stock No.
Then use an Averageifs() function

see attached file

 

[Villalobos]

Hi,

Here is another proposal.

 

[yaelcohen]

Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
it works

I really appreciate the help here, it saves a lot of gray hairs