Access IHS Global Insight series by code

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

bojiang19
Posts: 7
Joined: Wed Mar 20, 2013 10:54 pm

Access IHS Global Insight series by code

Postby bojiang19 » Tue Aug 06, 2013 7:14 am

Just found out Aremos has command to access a series from IHS Global Insight by commend using mnemonics. I know Eviews has an IHS data brower add-in. However, does it have command similar to Aremos'?
Here is a sample command from Aermos:
"link oecd_mei_d;
rec m158prmnve02st,m158prmnve03st"

EViews Michelle
Posts: 1
Joined: Wed Oct 10, 2012 11:22 am

Re: Access IHS Global Insight series by code

Postby EViews Michelle » Tue Aug 06, 2013 11:41 am

Just found out Aremos has command to access a series from IHS Global Insight by commend using mnemonics. I know Eviews has an IHS data brower add-in. However, does it have command similar to Aremos'?
Here is a sample command from Aermos:
"link oecd_mei_d;
rec m158prmnve02st,m158prmnve03st"
To access the IHS data browser through commands, you must add it to your database registry. Options-> Database Registry->Add new entry. From the pull-down menu, choose IHS Global Insight Database. You should give it an alias (i.e, databrowser).

The code to fetch the above series would be:

fetch(d=databrowser) m158prmnve02st.m m158prmnve03st.m

(Please note that you should have a workfile open, I would recommend a monthly one since that is the frequency of the series above - denoted by the .m ending)

-Michelle

bojiang19
Posts: 7
Joined: Wed Mar 20, 2013 10:54 pm

Re: Access IHS Global Insight series by code

Postby bojiang19 » Tue Aug 06, 2013 9:08 pm

Many thanks. May I follow up with a question about wildcard?

fetch(d=ihs, i=giif, notifyillegal=false) ip_chn.m.fgi ip_jpn.m.fgi
the command above worked, with series names changed in Eviews workfile.
but why ip_???.m.fgi doesn't work (wildcard used)? How can I make it work to pull out a batch of countries in one shot?

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

Re: Access IHS Global Insight series by code

Postby EViews Gareth » Thu Aug 08, 2013 10:28 am

Fetch doesn't support wildcards. Use @wquery to find the list of objects you want to fetch first.

bojiang19
Posts: 7
Joined: Wed Mar 20, 2013 10:54 pm

Re: Access IHS Global Insight series by code

Postby bojiang19 » Thu Aug 08, 2013 8:53 pm

thanks. but Does @wquery work with IHS Global Insight? Could you give a couple of examples?

just couldn't make it work with command like below or any command I tried:
@wquery("ihs", "Mnenomic matches ip* and geography=China")
Note: ihs is registered alias for IHS Global Insight database.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests