Fan Chart Actual and FC Data

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

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

27npg
Posts: 20
Joined: Thu Jul 25, 2019 9:31 am

Fan Chart Actual and FC Data

Postby 27npg » Fri Nov 01, 2019 3:10 am

Hi - I have been using the new fanchart option of EViews 11. In previous versions, I used the Fan Chart Add-in which, while being very helpful, was more time consuming as you needed to get data for skewness, uncertainty, mode etc. One advantage however was that it plotted the historical data along with the fan chart. Is there a way of doing this with the new in build feature?

Npg

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

Re: Fan Chart Actual and FC Data

Postby EViews Gareth » Fri Nov 01, 2019 7:43 am

Yes, just include the historical data in the graph.
Follow us on Twitter @IHSEViews

27npg
Posts: 20
Joined: Thu Jul 25, 2019 9:31 am

Re: Fan Chart Actual and FC Data

Postby 27npg » Mon Nov 04, 2019 1:49 am

Hi Gareth - thanks for your reply. I am a bit confused on this however. How this possible as the graph is being taken from the MC tab which will just have the 10,000 (or specified) simulated values. How would it be possible to draw in another historical series form a different tab?

Thanks again.

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

Re: Fan Chart Actual and FC Data

Postby EViews Gareth » Mon Nov 04, 2019 7:41 am

Say the simulations run from 2018-2020, and you have historical data from 2000-2018.

The simulations page should run from 2000-2020 with K cross-sections. Copy the historical series into the panel page, and then copy the simulations into the panel page too. The simulation series will then have constant values for 2000-2018 and different values for each cross-section from 2018 onwards.
Follow us on Twitter @IHSEViews

27npg
Posts: 20
Joined: Thu Jul 25, 2019 9:31 am

Re: Fan Chart Actual and FC Data

Postby 27npg » Mon Nov 11, 2019 9:43 am

Hi Gareth - Thanks for your help. I still haven’t managed to get this. Also, correct me if I am wrong but the simulations will run for 2018-2020 and the historic will run 2000-2018. Therefore, when I put both in the K cross section panel as you mentioned I will have 10,000 identical values from 2000-2018 but then different values for 2018-2020. When I go to plot the fan chart however, I just get two median lines.

Any ideas what I am doing wrong here?

npg

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

Re: Fan Chart Actual and FC Data

Postby EViews Gareth » Mon Nov 11, 2019 10:19 am

No.

If you run the following code to generate data, and then make a fan from Y you should see how it works.

Code: Select all

'historical data (random)
wfcreate(page=hist) m 2000 2018
series y=nrnd+3


'page with 10,000 mc draws of y - just made from random numbers in this example
pagecreate(page=mc) m 2019 2020 10000
series y=nrnd+3 + @trend/5


'page for fanchart
pagecreate(page=fan) m 2000 2020 10000

'copy historical data
copy hist\y fan\y

'copy mc data
copy(merge) mc\y fan\y
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 5 guests