Hi,
I am relatively new to eviews. I have eviews 9.5 and am importing data from Macrobond into a database. However, after importing macrobond time-series into the database with the browse-append button, and saving the database with a name, I notice that when I re-open the database, the time-series are lost. Ideally, I would like the macrobond time-series to be updated every time I open the macrobond database with a bespoke name. How can I do that? Thank you
Data import via Macrobond database
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Data import via Macrobond database
Put the series into a workfile (as links if you like, so they'll update), not a database.
Follow us on Twitter @IHSEViews
Re: Data import via Macrobond database
Thanks Gareth from the quick reply. I do export the time-series to a workfile, but then the workfile needs to refresh from the database, isn't it?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Data import via Macrobond database
I am sorry, perhaps I don't get it. If the workfile has time-series with links to the database, and the database (with an edb extension) gets emptied every time I close it, then how can I automatically update the time-series which I have saved in the workfile, which are linked to the database?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Data import via Macrobond database
Link from the macrobond database, not an edb.
Follow us on Twitter @IHSEViews
Re: Data import via Macrobond database
Thank you Gareth, this is what I did. I have tried fetching, copying & pasting (normal paste and paste special) a trial time-series from the macrobond database into a workfile. The series in the macrobond database are updated as of yesterday. However, none of these methods resulted in updating the time-series in the workfile to yesterday. In the database registry (in the workfile), the macrobond database is registered with an alias name, the workfile is linked to this database. I have also closed and reopened the workfile, and tried to refresh the links. In summary, I think I have tried all methods to link the time-series in the workfile to Macrobond. Only thr refresh option does not seem to be working, as refreshing the links is taking a long time. Any pointers on how to resolve this would be much appreciated.
-
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: Data import via Macrobond database
If you open the series in your workfile, then press the properties button and select the Values tab, is the 'External link' radio button selected?
If it is not, then the series is not linked to the Macrobond database.
If it is, what is the fetch string listed in the Specification for external data box?
If it is not, then the series is not linked to the Macrobond database.
If it is, what is the fetch string listed in the Specification for external data box?
-
- EViews Developer
- Posts: 788
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Data import via Macrobond database
Also, refreshing a series in a workfile does not automatically resize the workfile if the linked series at the source now has more data outside the workfile's current range. Use PAGESTRUCT to resize your workfile and also look at the arguments in the linked import command to see if a sample range has been specified.
Sent from my iPhone using Tapatalk
Sent from my iPhone using Tapatalk
Re: Data import via Macrobond database
Thank you Jason and Steve for your replies. I managed to refresh everything after inputting pagestruct. Thanks very much again!
Who is online
Users browsing this forum: No registered users and 15 guests