Page 1 of 1

Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 10:50 am
by kcaron
I have a calculated series and I want to reference data contained in a table in the series calculation.

Is there a way to do this?

For example, my calculated series draws a line with a slope of 0.06...

Like this: 0.06 * trend + acwi_m0.c(2)...

However, I don't want to "hard code" the 0.06 like this.

I would rather store a value in a table and reference the table. That way, if the 0.06 changes I don't have to keep updating the formula...

Or is there a better way to do this?

Thanks!

Re: Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 11:07 am
by EViews Gareth
Mytable(1,2)

But it won't be dynamic - the series won't update whenever the table does

Re: Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 12:03 pm
by kcaron
Is there some better sort of "container" I can put the information in that would be dynamic?

I don't necessarily need it to be a "table"...

Re: Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 12:28 pm
by EViews Gareth
Bo

Re: Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 2:04 pm
by kcaron
Sorry... What is "bo"?

Re: Referencing Data in Table W/I Formula

Posted: Tue Jun 07, 2016 2:09 pm
by EViews Gareth
No