Access Table Data in Formula?

[kcaron]

Is it possible to write a formula that references a cell in a saved EViews table?

If so, what is the method for doing so?

Thanks!

-K

[EViews Gareth]

Define what you mean by formula.

[kcaron]

Formula for a line... Where my independent variables are stored in a table and the coefficients are drawn from a regression equation.

dependent = regression.c(1) * independent + regression.c(2)

Where...

regression.C(1) is the coefficient and regression.C(2) is the constant from a saved regression equation (called "regression"), and
independent is some number that I make up and store in a table. (Let's say the table is called "mytable")

Thx!

K

[EViews Gareth]

Sorry, what do you mean by "line"?

Are you trying to create a formula object?

[kcaron]

yes. sorry.

[EViews Gareth]

You can refer to the table cell just from mytable(3,1). But the formula will not dynamically update every time the table updates. Formula objects only update when series do.

[kcaron]

Hmmmm...

I'll play around with it. Thank you!

-K