Page 1 of 1

Linking Excel with Eviews

Posted: Wed Oct 24, 2012 12:12 pm
by bfiaux
Which do you think would be the best to way to link a series from excel to Eviews, apply the x-12 arima procedure, and link the output to excel back?

Thanks

Re: Linking Excel with Eviews

Posted: Wed Oct 24, 2012 12:40 pm
by EViews Gareth
I think you'll need to give a little more detail on what you're trying to achieve.

Re: Linking Excel with Eviews

Posted: Wed Oct 24, 2012 12:51 pm
by bfiaux
Basically I have a series , non seasonally adjusted, in a excel spreadsheet which is updated automatically. I would like to link this column to one eviews's series archive. Afterwards, i need to run the seasonal adjustment program and link the output data back to a column in excel.

Re: Linking Excel with Eviews

Posted: Wed Oct 24, 2012 1:03 pm
by EViews Gareth
Sounds like your best bet is to use COM to do it.
http://eviews.com/download/whitepapers/ ... mation.pdf

Re: Linking Excel with Eviews

Posted: Wed Oct 24, 2012 1:29 pm
by bfiaux
Thankyou very much garreth. i will take a look at it now