average value - last six months
Posted: Tue Feb 06, 2018 10:35 am
When I am working at a daily frequency, how can I best find the average value for the last six months of a series?
Thomas
Thomas
Before answering, you'll have to define exactly what you mean.
If an observation is 15th January 2010, do you want the result to be:
Code: Select all
sum(16th July 2009: 15th January 2010) / 183
If so, what happens if an observation is 31 August? (31 Feb doesn't exist).
Obviously one method, that doesn't do the above, would be to convert the daily into monthly and then take a 6 month moving average and convert back.