EViews.com

Here is the excel formula for anyone who is interested.

=L145*(E144/L144)*EXP((coef!$D$3*forecast!M145)+(coef!$E$3*forecast!N145)+(coef!$F$3*forecast!O145)+(coef!$G$3*forecast!P145)+(coef!$H$3*forecast!Q145)+(coef!$I$3*forecast!R145))

Figured it out. Thanks for all your great help Gareth. Great to see nothing has changed around here.

Ok, how would I do it in Eviews without using forecast?

Can you tell me what I need to change in the formula in column W?

=EXP(coef!$D$3*((E144/E143)-(L144/L143)))*E144

I'm still not getting it. Can you take a look at my formula (column W) in the attached excel sheet?

Can someone point me to more detail on what Eviews does when normalizing a series when forecasting? I would like to be able to hand calculate the forecast to check it. This is from the Eviews help documentation. If the formula can be normalized, EViews will compute the forecasts of the transformed d...

Tried that. No it doesn't work.

Yes, i can open a file from Linux from within Eviews.

Locally it will save fine just fine. What I've been doing is saving the program to my desktop and then copy paste it to Linux.

Really weird, when I do a save as opens up the correct directory, it just won't save it. Attached are a couple of screenshots.

I'm using Eviews9, latest build. I'm able to copy and paste a Eviews program from a Linux server (using Samba) into Eviews which is running on my desktop pc. When I try to save the program I'm getting the follwing error in an error message popup. Unable to open file \\sas\pm\econ\hpfm\v3.1\2015q2\20...

I would like to replace the NAs in the series with a period. So when I export the series to .csv there won't be any text in the field. It will le me replace it with zero. Just wondering if I can replace it with a period. I'm guessing probably not.

I'm using EViews9, latest build.

Is there a way to replace NA values with missing? So replace NA with a period.

The error is get is . is not defined in "blah".

series fcst_hpi=@recode(fcst_hpi=na,.,fcst_hpi