Hi Guys,
Have a complicated (i think) task here...
Im trying to calculate moving averages on a window of 10 working days. For a period of 40 days, i will get 4 average figures.
However, I will need to repeat this process by moving back 1 day for each set of 4 Average figures.
This means I will have, for a 40 day period, a total of 40 sets of averages but of coz this will require my data set to have 50 sets of daily figures to accomodate for the last set of 4 average figures.
Then i want to translate these figures into a seperate column, in order of the calculations performed..
Can a macro be written for this?
I think im confusing pple.. have attached a spreadsheet...
Is there a code that can do this?