Referencing Data in Table W/I Formula

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

kcaron
Posts: 101
Joined: Wed Mar 04, 2015 11:46 am

Referencing Data in Table W/I Formula

Postby kcaron » Tue Jun 07, 2016 10:50 am

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!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
Joined: Tue Sep 16, 2008 5:38 pm

Re: Referencing Data in Table W/I Formula

Postby EViews Gareth » Tue Jun 07, 2016 11:07 am

Mytable(1,2)

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

kcaron
Posts: 101
Joined: Wed Mar 04, 2015 11:46 am

Re: Referencing Data in Table W/I Formula

Postby kcaron » Tue Jun 07, 2016 12:03 pm

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"...

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
Joined: Tue Sep 16, 2008 5:38 pm

Re: Referencing Data in Table W/I Formula

Postby EViews Gareth » Tue Jun 07, 2016 12:28 pm

Bo

kcaron
Posts: 101
Joined: Wed Mar 04, 2015 11:46 am

Re: Referencing Data in Table W/I Formula

Postby kcaron » Tue Jun 07, 2016 2:04 pm

Sorry... What is "bo"?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13600
Joined: Tue Sep 16, 2008 5:38 pm

Re: Referencing Data in Table W/I Formula

Postby EViews Gareth » Tue Jun 07, 2016 2:09 pm

No


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests