Page 1 of 1
Access Table Data in Formula?
Posted: Fri Dec 04, 2015 9:02 am
by 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
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 9:21 am
by EViews Gareth
Define what you mean by formula.
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 9:58 am
by 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
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 10:01 am
by EViews Gareth
Sorry, what do you mean by "line"?
Are you trying to create a formula object?
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 10:04 am
by kcaron
yes. sorry.
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 10:06 am
by 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.
Re: Access Table Data in Formula?
Posted: Fri Dec 04, 2015 10:37 am
by kcaron
Hmmmm...
I'll play around with it. Thank you!
-K