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
average value - last six months
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: average value - last six months
Tricky.
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:
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.
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.
Follow us on Twitter @IHSEViews
-
- Posts: 540
- Joined: Fri Apr 15, 2011 5:35 am
Re: average value - last six months
Great, thanks. Just what I was looking for
Thomas
Thomas
Who is online
Users browsing this forum: Google [Bot] and 26 guests