Converting to monthly from @weekly
Posted: Mon Jun 09, 2014 6:30 am
I'm trying to convert a weekly series to a monthly.I need to take 12 weeks of weekly at Friday prices, distribute that data linearly over a 30 day interval (so basically taking 12 weeks of data and distributing linearly to 30 days, not 90). Then convert that linear distribution to a month (April in this example). I'm doing this to smooth the take off month.
However, what I’m finding is that Eviews only wants to convert linearly the weeks in the month set, not the full 12 week interval. No matter what I do I can’t figure out a way around it. Does that make sense? I tried to doing an undated workfile, but that didn’t do the trick.
However, what I’m finding is that Eviews only wants to convert linearly the weeks in the month set, not the full 12 week interval. No matter what I do I can’t figure out a way around it. Does that make sense? I tried to doing an undated workfile, but that didn’t do the trick.