manipulation of forecast series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

swingline007
Posts: 4
Joined: Mon Jul 29, 2013 6:33 am

manipulation of forecast series

Postby swingline007 » Mon Jul 29, 2013 6:44 am

Hello,

I'm trying to figure out an efficient way to manipulate the forecast series of multiple variables. For example I'd like to increase/decrease the out of sample values of the variable apples by 10% to do some "sensitivity testing".

The only way I have come up with is the following:

where there is already a series called apples where the sample period 1990q1 - 2013q1 are my in sample actuals and the forecast period (forecasts already in the series) is 2013q2 2016q4

smpl 1990q1 2013q1
apples_inc10 = apples
apples_dcr10 = apples

smpl 2013q2 2016q4
apples_inc10 = apples*1.1
apples_dcr10 = apples *.90

This give me two series with the same in sample values and with the forecasted values 10% above and and below the orginal forecasted values.

For a high number of variables, is there an easier way to do this? Is there a 'select all' variables command I could use?

Version: 7.2

Thanks,
Last edited by swingline007 on Mon Jul 29, 2013 8:01 am, edited 1 time in total.

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

Re: manipulation of forecast series

Postby EViews Gareth » Mon Jul 29, 2013 7:59 am

Not in EViews 7, no :(

You could always write a program that will do it.

swingline007
Posts: 4
Joined: Mon Jul 29, 2013 6:33 am

Re: manipulation of forecast series

Postby swingline007 » Mon Jul 29, 2013 8:07 am

That's the plan. Though the problem is that the list of variables may change from time to time. So I'm trying to think of an efficient way to write it so there is minimal editing going forward when the variable list changes. Though the only way I can think to write it is just an expanded version of what is posted above. Suggestions?

swingline007
Posts: 4
Joined: Mon Jul 29, 2013 6:33 am

Re: manipulation of forecast series

Postby swingline007 » Mon Jul 29, 2013 8:08 am

Also, does EViews 8 have some sort of "select all variable" command or a feature that I could use that EViews 7 doesn't?

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

Re: manipulation of forecast series

Postby EViews Gareth » Mon Jul 29, 2013 8:17 am

All versions let you select all variables and put them in a group:

Code: Select all

group mygroup *
You can then just loop through the members of the group.


EViews 8 has an easier way of adjusting the values of a series. You'd still have to loop through the series one by one though.

swingline007
Posts: 4
Joined: Mon Jul 29, 2013 6:33 am

Re: manipulation of forecast series

Postby swingline007 » Mon Jul 29, 2013 8:20 am

I'll give this a try. Thanks.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests