Updating/Refrshing Links in EViews Workfile Pages

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

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Updating/Refrshing Links in EViews Workfile Pages

Postby moameen » Fri Mar 15, 2013 1:11 am

My EViews workfiles contains a number of different pages for things like Demand, Supply etc, with one single page called "All Data" where all the time series that I use are imported into from Excel. The other pages (Demand, Supply etc) only contain the relevant time series, and have been copies and pasted as links from the All Data page, the idea being is that once new data comes into the spreadsheet, I can just import from excel into "All Data" and all the other will get updated when i click "refresh" all links under "manage links and formula".

Unfortunately, once I update from excel in "All Data" and click refresh all links in the individual pages, the time series are not updating. Am I missing something? Help will be appreciated. Thanks.

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

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby EViews Gareth » Fri Mar 15, 2013 8:04 am

Links between pages do not need refreshing - they update automatically in real time.

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby moameen » Fri Mar 15, 2013 8:15 am

That's what I thought as well - but in my case, they are not refreshing automatically. The new data gets populated by NA's.

Here is what I am doing:
1) Update "All Data" through Import / Overwrite all time series
2) Go to individual pages
3) Click on Proc, resize current page, update the end data
4) Right click on page, manage links / formula, refresh links - update from source

Am I missing something?

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

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby EViews Gareth » Fri Mar 15, 2013 8:20 am

You're doing it correctly, although step 4 isn't needed.

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

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby EViews Gareth » Fri Mar 15, 2013 8:27 am


moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby moameen » Fri Mar 15, 2013 9:49 am

Thanks for the example.

I've done the exact same thing but it still seems like i'm getting "NA" in the cells where the new data is being populated. So I can see the new months being added, but instead of numbers, im seeing NA instead of the data points. Any idea why that might be happening?

In the pages, Set Sample, does that always have to be @all?

Can you please confirm that when I paste the link, I do paste special, paste as link, merge by date, OK?

Many thanks.

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

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby EViews Gareth » Fri Mar 15, 2013 10:17 am

Sample @all is fine. Yes, that's how you paste.

Post your workfile. Maybe there's something screwy.

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby moameen » Fri Mar 15, 2013 10:43 am

Thanks. Please see attached.
Attachments
sample model.wf1
(57.52 KiB) Downloaded 382 times

EViews Esther
EViews Developer
Posts: 149
Joined: Fri Sep 03, 2010 7:57 am

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby EViews Esther » Fri Mar 15, 2013 12:02 pm

When you create a new page, you do not need to make a copy of OBSID. Could you do the followings?

1) paste special
2) paste as link
3) merge by date

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby moameen » Fri Mar 15, 2013 12:41 pm

I am creating a new page by

1) Staying on the all data page
2) Clicking new page
3) Copy extract from current page
4) By link to new page

Once this creates a new page, i simply delete the time series i dont need to use, the rest remain links

Is that the porblem?

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: Updating/Refrshing Links in EViews Workfile Pages

Postby startz » Fri Mar 15, 2013 1:47 pm

The problem is that the link needs obsid01, which you have deleted.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests