Saving E-views computations to excel

[Loujaina]

Hi
I am new to using E-views, and I am stuck in something
I have a workfile in which there are some arithmetic computations... I want to translate these computations to excel. When I export the the computed series to excel, I get the numbers only, but I do not get the formula itself.
Even when I export the whole workfile (including the sources from which the computations were made)

Thank you

[EViews Gareth]

I'm not sure what you're expecting to happen?

[Loujaina]

I expect to see the formulas in the excel...
i.e., suppose in e-views I create a new series "New=x+y"

I want to export from e-views to excel the following:
- X (can do this)
- Y (can do this)
- New (so that when I click on any cell under new in excel, I can see that this cell in calculated x+y)

[EViews Gareth]

That's not going to happen. EViews cannot convert all of its formulas into Excel formulas.

[EViews Glenn]

Put somewhat differently, Excel doesn't have all of the functionality of EViews.

[Loujaina]

I am talking about simple arithmetic computations... Like generating a new series from another series in a workfile... Logs, divisions, additions... stuff that excel can do.

The issue is the work is already done on E-views... we need it on excel... we can easily export the series in numbers, but we will need formulas for future reference in case we need to change something... Plus I know that E-views does not export to an existing excel file... so every time we change we will go back to E-views, change the formula and export the results to a new excel file!

[EViews Gareth]

EViews can happily save to an existing workfile...

Plus if you need the formulas in Excel, perhaps the best thing to do is use EViews to save the raw data in to Excel, then enter the formulas in Excel.

[startz]

I expect you can get part of what you want by creating a string with the history part of the label and then saving that string. Something like

Code: Select all

string xs=x.@attr("history")