Fan Chart Actual and FC Data

[27npg]

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]

Yes, just include the historical data in the graph.

[27npg]

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]

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.

[27npg]

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]

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


[creagan52]

I have tried this also and cannot get a correct graph. I get two seprate median lines as the other poster. Any ideas?