Custom Fiscal Year

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

BCNAV
Posts: 40
Joined: Tue Oct 31, 2017 9:06 am

Custom Fiscal Year

Postby BCNAV » Tue Nov 07, 2017 7:48 am

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.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Custom Fiscal Year

Postby EViews Gareth » Tue Nov 07, 2017 8:51 am

Code: Select all

wfcreate a 2000m9 2010m8

BCNAV
Posts: 40
Joined: Tue Oct 31, 2017 9:06 am

Re: Custom Fiscal Year

Postby BCNAV » Tue Nov 07, 2017 8:26 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Custom Fiscal Year

Postby EViews Gareth » Wed Nov 08, 2017 11:45 am

Not clear what you're asking. For what purpose do you want "proper dating"?


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests