Hi,
I have a time series of daily data and want to compute average values over an exact year. So for example, for the observation January 1st, 1999, I want the average from January 1st,1999 to January 1st, 2000. I can do this easily using monthly data with the rangestat command which can give me rolling observations and its straight forward because there's always 12 months in a year. However, I'm running into trouble for the same using daily data. I want the exact average over a year (February 27th, 2011 to February 27th, 2012). There aren't exact number of days in a year because this is stock returns data. Would appreciate any advice/insight on this. Thank you!
I have a time series of daily data and want to compute average values over an exact year. So for example, for the observation January 1st, 1999, I want the average from January 1st,1999 to January 1st, 2000. I can do this easily using monthly data with the rangestat command which can give me rolling observations and its straight forward because there's always 12 months in a year. However, I'm running into trouble for the same using daily data. I want the exact average over a year (February 27th, 2011 to February 27th, 2012). There aren't exact number of days in a year because this is stock returns data. Would appreciate any advice/insight on this. Thank you!
Comment