Page 1 of 1

Custom Fiscal Year

Posted: Tue Nov 07, 2017 7:48 am
by BCNAV
Hi all,

Is there a way in EViews to say the fiscal year is September to August? When using our monthly air traffic data I would like to be able to copy that data to the quarterly part of my workfile (separate page) and have it automatically calculate the quarterly totals (which are sums of months) based on the fiscal year and not calendar year. The same would be for my annual page, with the annual year being based on the fiscal year and not calendar year. Any ideas? Can Eviews do a custom year?

Thanks in advance.

Re: Custom Fiscal Year

Posted: Tue Nov 07, 2017 8:51 am
by EViews Gareth

Code: Select all

wfcreate a 2000m9 2010m8

Re: Custom Fiscal Year

Posted: Tue Nov 07, 2017 8:26 pm
by BCNAV
Thank you very much, but eviews will lag the year. Suppose I have:

Code: Select all

2000M09 1384532085 2000M10 1358868167 2000M11 1197089389 2000M12 1146904062 2001M01 1166251524 2001M02 1051963506 2001M03 1191344759 2001M04 1241573540 2001M05 1324928884 2001M06 1390336159 2001M07 1486012141 2001M08 1496857895 15436662112 2001M09 1219122886 2001M10 1188742514 2001M11 1028742527 2001M12 1038707808 2002M01 1018003580 2002M02 921225910.7 2002M03 1062281533 2002M04 1105230265 2002M05 1218980464 2002M06 1275355941 2002M07 1383705201 2002M08 1384023397 13844122025
The fiscal year sums are in the third column, identified at fiscal year 2001 and fiscal year 2002. When using your code Eviews will list annualy as:

Code: Select all

9/01/2000 15436662112 9/01/2001 13844122025
Is there a way to get a proper dating? EViews is taking the first date of the range, so this would read Fiscal Year 2000 and 2001 and not 2001 and 2002. Perhaps I could create a fiscal year variable, which would read the observation date, pull out the year, and add one to it?

Thanks

Re: Custom Fiscal Year

Posted: Wed Nov 08, 2017 11:45 am
by EViews Gareth
Not clear what you're asking. For what purpose do you want "proper dating"?