Custom Fiscal Year

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator

BCNAV
Posts: 21
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: 11406
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
Follow us on Twitter @IHSEViews

BCNAV
Posts: 21
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: 11406
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"?
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 5 guests