write in excel
Posted: Mon Apr 11, 2016 3:50 am
Hi Eviews,
Sorry for a very basic question but I want to save my pool forecasts in excel what is the best way to do this. I am using below:
pool1.write(xls,bycross) forecast1.xls ?_con ?_con_0
However I want to transpose it so I have each cross section for say 1990 in row 1 and 1991 in row 2 and so on. There is this new thing called pagesave should I use this instead?
Also can I get to the standard errors when using the model object? I do not have a stochastic model but a deterministic and forecasting out to say end of 2016.
Thank you in advance.
Sorry for a very basic question but I want to save my pool forecasts in excel what is the best way to do this. I am using below:
pool1.write(xls,bycross) forecast1.xls ?_con ?_con_0
However I want to transpose it so I have each cross section for say 1990 in row 1 and 1991 in row 2 and so on. There is this new thing called pagesave should I use this instead?
Also can I get to the standard errors when using the model object? I do not have a stochastic model but a deterministic and forecasting out to say end of 2016.
Thank you in advance.