User’s Guide : EViews Fundamentals : EViews Databases : Foreign Format Databases
  
Foreign Format Databases
 
To Convert Or Not To Convert?
Opening a Foreign Database
Copying a Foreign Database
Notes on Particular Formats
Bloomberg
Limitations
Bureau of Economic Analysis (BEA)
Bureau of Labor Statistics (BLS)
CEIC
Census (United States Census Bureau)
Datastream
DBnomics
EIA (U.S. Energy Information Administration)
Online EIA Database
Offline EIA Bulk File - U.S. Energy Information Administration Databases
FAME
FRED
Haver
IHS Global Insight
IHS Magellan
Bank Names
Special Handling of Mnemonics
Special Handling of Frequencies
Running EViews from a Network Folder
IHSMarkit
Moody’s Economy.com
NOAA (National Oceanic And Atmospheric Administration)
OECD SDMX (Organisation for Economic Cooperation and Development Statistical Data and Metadata eXchange)
Eurostat, ECB, UN, IMF, OECD, ABS, DB, and Insee
RATS 4.x
SDMX-ML Files
Trading Economics
Indicators
Markets
World Bank Data
World Health Organization
While most of your work with databases will probably involve using EViews native format databases, EViews also gives you the ability to access data stored in a variety of other formats using the same database interface. You can perform queries, copy objects to and from workfiles and other databases, rename and delete objects within the database, add databases to your search path, and use EViews’ name aliasing features, all without worrying about how the data are stored.
When copying objects, EViews preserves not only the data itself, but as much as possible of any date information and documentation associated with the object. Missing values are translated automatically.
To Convert Or Not To Convert?
Although EViews allows you to work with foreign files in their native format, in some cases you may be better off translating the entire foreign file into EViews format. If necessary, you can then translate the entire file back again when your work is complete. EViews native databases have been designed to support a certain set of operations efficiently, and while access to foreign formats has been kept as fast as possible, in some cases there will be substantial differences in performance depending on the format in use.
One significant difference is the time taken to search for objects using keywords in the description field. If the data are in EViews format, EViews can typically query databases containing tens of thousands of series in a couple of seconds. When working with other formats, you may find that this same operation takes much longer, with the time increasing substantially as the database grows.
On the other hand, keeping the data in the foreign format may allow you to move between a number of applications without having to retranslate the file. This minimizes the number of copies of the data you have available, which may make the data easier to update and maintain.
Using EViews, you can either translate your data or work with your data directly in the foreign format. You should choose between the two based on your particular needs.
Opening a Foreign Database
Working with foreign formats requires very little additional knowledge. To open a foreign database, simply select File/Open/Database... from the main menu to open the dialog. In the field Database/File Type: select the type of the foreign database or file you wish to open. If the database is a local file, you can then use the Browse Files button to locate the database in exactly the same way as for a native EViews database. You can create a new foreign format database by a similar procedure way using File/New/Database... from the main EViews menu.
If the database is accessed through a client-server model, selecting the dialog will change to show extra fields necessary for making the connection to the server. For example, when accessing a database located on a FAME server, the dialog will include fields for the FAME server, username and password.
Since access to a server requires many fields to be entered, you may wish to save this information as an entry in the database registry (see “The Database Registry” for details).
You can also create and open foreign format files using the dbopen or dbcreate commands. You may either use an option to specify the foreign type explicitly, or let EViews determine the type using the file extension. See dbopen and dbcreate for details.
Copying a Foreign Database
Once you have opened a window to a foreign database, you can copy the entire database into a new format using Proc/Copy the Database from the database menus. A dialog will appear which allows you to specify the type and other attributes of the new database you would like to create.
When performing a database copy to a new format, objects which cannot be copied due to incompatibility between formats will result in error messages in the EViews command window but will not halt the copying process. Upon completion, a message in the status line reports how many objects could not be copied.
Notes on Particular Formats
Bloomberg
EViews Enterprise Edition users may use the standard EViews database interface to search, browse, and retrieve Bloomberg Reference Data Services extensive library market and economic data.
You can search through Bloomberg securities and fields from within EViews to quickly locate the data you need, then fetch the data directly into an EViews workfile without the need for intermediate files or formats.
To access Bloomberg data from EViews, you must have:
1. The Bloomberg Professional application software installed on your machine
2. A currently active subscription to Bloomberg and be able to log into the Bloomberg Professional terminal on your machine.
In addition, Bloomberg connectivity requires the EViews Enterprise Edition.
Note that the highest resolution of data that can be fetched by EViews is one minute interval data. EViews does not currently support reading tick data for a security. Further, the Bloomberg database extension for EViews that powers the connection only supports Bloomberg Desktop API configurations (Bloomberg Server API and B-Pipe configurations are not supported).
For detail on Bloomberg Reference Data Services please see the Bloomberg website http://www.bloomberg.com/enterprise/data/reference-data-services.
The following discussion offers a quick introduction to use EViews to connect with Bloomberg data. See our whitepaper: Bloomberg Database Extension for EViews (available from our website www.eviews.com/download/download.html) for additional detail and discussion.
To start, you must open a database window to Bloomberg by selecting File/Open Database… from the main EViews menus, then selecting Bloomberg Database from the Database/File type dropdown menu. The following dialog should appear:
In most cases, you should simply be able to click on OK to get started. Clicking on OK should bring up a Bloomberg database window.
The database window represents a connection to Bloomberg data.
The first step in retrieving data is to find a series that we would like to fetch. Click on Browse to bring up the Bloomberg database custom search dialog:
The Search Text field allows you to enter one or more keywords to search for. The ‘Market Sector’ field lets you restrict the search to a particular Bloomberg market sector. (If you are using a Bloomberg keyboard you can change the market sector field by pressing a Yellow Key).
The Items to Return field specifies how many items to return from the search. Bloomberg is very effective at selecting relevant results so only a small number of results is generally needed.
The Field Name and Overrides boxes allow you to specify what particular information about a security you would like to fetch. By default EViews will fetch the field “PX_LAST” without any overrides.
For example, we can simply type “us gdp” into the Search Text box and press OK. You should return to the database window with the following search results displayed:
Any series displayed in the database may be manipulated following the usual EViews interface conventions:
Double click on a series to bring up detailed information on the series
Drag and drop series or copy and paste them into an EViews workfile or database to fetch the current data from the server (drag with the right mouse button or use Paste Special to create links)
Limitations
Note that the highest resolution of data that can be fetched by EViews is one minute interval data. EViews does not currently support reading tick data for a security.
Further, the Bloomberg database extension for EViews that powers the connection only supports Bloomberg Desktop API configurations (Bloomberg Server API and B-Pipe configurations are not supported).
Bureau of Economic Analysis (BEA)
BEA provides access to a list of datasets that offer a large range of publicly available data, including U.S. GDP, foreign trade, investment statistics, and industry data.
Please note that an internet connection is required to obtain BEA online data. For more information on the datasets, please see
www.bea.gov/data/all
EViews offers a custom interface to BEA data. To open the BEA database, select File/Open Database… from the main EViews menu, then select Bureau Of Economic Analysis from the Database/File type dropdown menu:
Use of the BEA service is free but requires registration. The first time you attempt to open the database you will be asked to enter an API Key obtained from the Bureau of Economic Analysis:
Please enter your API key and then click on OK. The key will be saved as a user specific setting in your EViews “.ini” file. If you need to change the key at a later time, select View/Preferences… from the EViews database menu to modify your settings.
When you click on OK, EViews will open a standard database window:
Click on Browse to open the custom BEA window:
The dialog allows you to select data available within datasets. The browser interface to the data provides a way to search through the datasets by typing a keyword in the Filter By textbox and clicking the Filter button:
Select a dataset and click the Next > button. A dialog with a list of dataset parameters will be shown, which will allow you to filter and customize the search results of the available series objects in the selected dataset. The default parameters are displayed under the Value column of the data table. Double click the row the change the default values.
Click the Reset button to clear the selections, the Back button to navigate to the previous window, or the Next button to view the available series:
A dialog containing a table with all the available series is displayed. The interface provides a way to search through the series by typing a keyword in the Filter By textbox and clicking the Filter button. Click the Select button to select the series:
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
Bureau of Labor Statistics (BLS)
The BLS database is a large collection of free and publicly available economic data provided by the Bureau of Labor Statistics of the U.S. Department of Labor.
EViews 10 offers a custom interface to BLS data. To open the BLS database, select File/Open Database… from the main EViews menu, then select Bureau Of Labor Statistics from the Database/File type dropdown menu:
The server specification will be automatically filled in with the BLS server address api.bls.gov, which you should not need change. Click on OK to proceed.
Use of the BLS service is free but requires registration. The first time you attempt to open the database you will be asked to enter an API Key obtained from the Bureau of Labor Statistics:
Please enter your API key and then click on OK. The key will be saved as a user specific setting in your EViews ".ini" file. If you need to change the key at a later time, select View/Preferences… from the EViews database menu to modify your settings.
When you click on OK, EViews will open a standard database window:
Click on Browse to open the custom BLS window. The standard database window will be minimized and the BLS window will open:
The browser window displays an edit box where the user can type or Paste one or more series IDs to be retrieved from BLS. In the example above the edit box contains three typed series. After clicking OK, the regular EViews database window will be restored and will contain any requested series.
Please note that the BLS Data API requires users to know the series ID to request data.
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile.
CEIC
The CEIC database includes economic, sector and financial data. Data are fetched from the internet by Internet Securities, Inc. (also known as IS Emerging Markets) XML based data servers.
CEIC database access is only available in the Enterprise Edition of EViews.
To access CEIC data, the CEIC-EViews Interface Software must already be installed on the client machine. To obtain the software and a valid CEIC account, please contact Internet Securities, Inc. directly. For additional information, please see http://www.securities.com.
To access a CEIC database, select File/Open/Database... and select CEIC Database in the drop-down menu and fill out your User name and Password as prompted. The Sever specification is pre-filled with the CEIC default, but you may enter the specification information for a different server if desired:
You may optionally provide a Database alias. Click on OK to open the database in the standard EViews interface.
Census (United States Census Bureau)
The Census Bureau provides access to a list of datasets that offer a large range of publicly available data about the people and economy of the United States. Please note that an internet connection will be required to obtain Census online data. For more information on the datasets, please see
https://api.census.gov/data.html
EViews offers a custom interface to the Census data. To open the Census database, select File/Open Database… from the main EViews menu, then select US Census from the Database/File type dropdown menu:
Use of the Census service is free but requires registration. The first time you attempt to open the database you will be asked to enter an API Key obtained from the United States Census Bureau:
Please enter your API key and then click on OK. The key will be saved as a user specific setting in your EViews “.ini” file. If you need to change the key at a later time, select View/Preferences… from the EViews database menu to modify your settings.
When you click on OK, EViews will open a standard database window:
Click on Browse to open the custom Census window:
The dialog displays the available datasets. The checkbox Show TimeSeries Only is checked by default. Uncheck the box if you want to see all available datasets. The browser interface to the datasets provides a way to search through the datasets by typing a keyword in the Filter By textbox and clicking the Filter button. Select a dataset and click the Next button. A dialog with a list of variables will be shown, which will allow you to filter and customize the search results of the available series objects in the selected dataset:
The variables that are preselected are required variables for the search; you may select additional variables you are interested in. You can search through the variables by typing a keyword in the Filter By textbox and clicking the Filter button. Click the Next button to navigate to the next dialog:
The majority of Census datasets require the user to specify geographic information in order to customize and limit the data result. After selecting the geography type, click Next to navigate to the next dialog. You might need to navigate to a number of dialogs until the geographic order is met:
Select one or more geography options and navigate to the next dialog. If there are any variables required by the dataset you will be asked to choose available values:
Once you finish selecting geography and required variables information, a dialog that contains a table with all the available series is displayed. The interface provides a way to search through the series by typing a keyword in the Filter By textbox and clicking the Filter button.
Click the Select button to select the series:
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
Datastream
The Datastream database allows you to fetch data remotely over the internet from Datastream's extensive collection of financial and economic data. Data are retrieved from the Thomson Financial Datastream historical XML API. The location of the XML API must be entered in the server specification of the open database dialog window.
Datastream database access requires the Enterprise Edition of EViews.
In addition, you must be able to access to the Thomson Datafeeds service using Datastream Advance through an internet connection, and you must have a valid XML API account from Thomson Financial. (Note that the XML API user name is not the Datastream user name as used with thick client products such as Datastream Advance.)
Please contact Thomson Reuters for further information ( http://www.thomsonreuters.com).
DBnomics
DBnomics provides access to a large range of publicly available economic data from national and international institutions like the IMF, Eurostat, World Bank, ECB, etc. Please note that an internet connection will be required to obtain DBnomics online data. For more information on the datasets, please see http://db.nomics.world.
EViews offers a custom interface to the DBnomics data. To open the DBnomics database, select File/Open Database… from the main EViews menu, then select DBnomics from the Database/File type dropdown menu:
When you click on OK, EViews will open a standard database window:
Click on Browse to open the custom DBnomics window:
The dialog interface allows you to continue your search for data by searching for a keyword, by selecting a provider, or by typing known series ids.
There are three methods to find the data you want. To search directly, click the Search radio button and type a keyword in the textbox. Use the Next button to view the results of the search:
A dialog that contains a table with all providers and datasets related to the keyword searched (GDP in this case) is displayed. The interface provides a way to filter through the results by typing a keyword in the Filter textbox. It also provides a textbox and buttons to navigate through pages of results. Click the Next button or double-click on a row to select a provider and a dataset.
To select by data provider, click the radio button Select Provider and choose one of the entries listed in the drop-down box:
Use the Next button to view the results in a dialog that contains a table with all datasets related to the specified provider (in this case, ECB).
The interface provides a way to filter through the results by typing a keyword in the Filter textbox. You may use the textbox and buttons to navigate through multiple pages of results. Click the Next button or double-click on a row to select a dataset.
The Search and Select Provider options will display a dialog where the user can view and select series. For the GDP search example, we may select the ECB provider using the SPF dataset:
This dialog contains a table where all the series matching the search are displayed. The interface provides a textbox where search criteria can be viewed or changed. It also provides a list of dropdown boxes that contain additional search filter criteria. By clicking a filter drop box one or more options can be selected. After selections are made the results of series will be updated to match the filter options. The interface also provides a graph preview of the data selected.
Once you have found and selected the series of interest, you may drag-and-drop or click the Export to workfile button to export the series directly into an existing or new EViews workfile.
The third option is to enter a Series ID. Click the radio button Enter Series ID(s) and enter one or more series codes in the text area:
Use the Next button to view the series:
EViews displays a dialog that contains a table with all the series. The interface provides a way to filter through the results by typing a keyword in the Filter textbox. It also provides a graph preview of the series data selected.
Once you have found and selected the series of interest, you may drag-and-drop or click the Export to workfile button to export the series directly into an existing or new EViews workfile.
EIA (U.S. Energy Information Administration)
The EIA database is a large collection of free and publicly available energy and related economic data provided by the U.S. Energy Information Administration.
EViews Enterprise Edition supports both online access to EIA data via the EIA web server and offline access to data downloaded in the EIA Bulk File format.
Online EIA Database
To open the EIA online database, simply select File/Open Database… from the main EViews menu, then select EIA - U.S. Energy Information Administration from the Database/File type dropdown menu:
The server specification will be automatically filled in with the EIA server address “api.eia.gov”. This does not need to be changed. Click on OK to proceed.
Use of the EIA online service is free but requires registration. The first time you attempt to open the EIA online database you will be asked to enter an API Key obtained from the EIA:
Please enter your API key and click on OK. The key will be saved as a user specific setting in your EViews “.ini” file. If you need to change the key at a later time, use View/Preferences… from the EViews database menu to bring up the dialog again so you can modify your settings.
When you click on OK, EViews will open a standard database window:
The EIA database connection supports a custom browser window for navigating through the EIA data. Click on Browse to open the custom browser window. The standard database window will be minimized and the EIA browser window will open:
The browser window displays a Search By link and the data sets available within the database as a set of folders, where each folder may contain additional folders or a list of series available for download. Clicking on a folder moves you into that folder and adds the folder to the path displayed at the top of the window:
You can return to the previous folder by clicking on the “..” folder icon at the top of the list, or move directly to any folder within the current path by clicking on the path component at the top of the window.
Select the Show Chart checkbox at the bottom right of the dialog to view a chart of a selected series:
All the dialogs contain a link (Open Browser) to the API. Click on the link to get additional information including documentation.
Additionally, the EIA Edx allows the user to search for one or multiple series. Click on the Search By link to search for series by Keyword(s), Series ID, or Category ID.
You can select the Show Chart box to view the chart of a selected series:
Once you have found and selected the series of interest, you may drag-and-drop or copy-and-paste the series directly into an EViews workfile. When you have finished working with the browser, simply close the browser window to restore the regular EViews database window.
Offline EIA Bulk File - U.S. Energy Information Administration Databases
EViews also allows you to work offline with data downloaded from the EIA using the EIA bulk download facility. The bulk download feature allows you to fetch all series and category information from an entire EIA data set into a single local file. Downloading an entire bulk file is generally much more efficient than fetching a large number of series one at a time. Once the file has been downloaded, you can navigate within the dataset and bring data into EViews without reconnecting to the EIA servers.
To download a bulk file, open the browser window of the EIA online database, right click on a data set, then select Download Bulk File…:
A dialog will appear giving instructions for downloading the file and preparing it for use by EViews:
Clicking on the download link will open your default web browser and start a download of the file. The bulk file is compressed in “.zip” format. You will need to use an unzipping utility to extract the single “.txt” file contained within the zip file.
Once the bulk file is ready, use File/Open Database/EIA Bulk File - U.S. Energy Information Agency… , then click on Browse Files to find the file, and then OK to open it:
Alternatively, you can drag and drop the file onto EViews to open it. First, however, you should rename the “.txt” file to “.eia” so EViews can tell that the file contains data in EIA bulk file format and is not a generic text file.
The caption on the window indicates that you are working with a local file. Otherwise, the interface behaves the same as when working with online data:
Note that some EIA datasets are large, potentially hundreds of megabytes of uncompressed data. When working with large files you may see a delay as the file is opened since EViews must scan the entire bulk file to find all series and category information stored in the file. Subsequent operations should be fast since all data is stored locally on your machine.
FAME
The FAME format is a binary file format written by FAME (SunGard MarketMap Analytic Platform) database products. FAME provides a variety of products and services for working with time series data.
FAME access is only available in the Enterprise Edition of EViews.
In order to access FAME databases, a valid installation of FAME must already be available. EViews makes use of the FAME C Host Language Interface (C HLI) library, and will error unless the FAME .DLLs are correctly installed on the machine. EViews supports versions 8 and newer of the FAME libraries.
A local FAME database can have any file extension, and EViews supports access to a FAME database with any name. However, because many commands in EViews use the file extension to automatically detect the file type, you will generally find it easier to work with FAME databases which have the default “.DB” extension.
EViews also allows access to FAME databases located on a FAME Database Server. When working with a FAME server, the Server specification should be given in the form:
#port_number@ip_address
For example, the server specification for access to a FAME/Channel database might appear as:
#2552@channel.fame.com
Access to a server will require a valid username and password for that server.
Please contact SunGard directly ( http://www.sungard.com/fame) for further information about the FAME database system and other FAME products.
FRED
FRED (Federal Reserve Economic Data) is a publicly accessible database of more than 20,000 U.S. and international time series of multiple frequencies, provided by the Economic Research Division of the Federal Reserve Bank of St. Louis. The FRED database offers a wide variety of freely downloadable data, including interest rates, exchange rates, national income accounts, and many others. Data found in FRED are drawn from several national and international sources and is updated frequently.
For more information on the FRED database, please see http://research.stlouisfed.org/fred2.
Both the Standard and Enterprise versions of EViews offer FRED access. Please note that an internet connection will be required to obtain FRED data.
EViews offers a custom interface to the FRED data service provided by the Federal Reserve Bank of St Louis. The interface includes a custom browser for navigating the available FREDX data and adds support for retrieval of historical releases. To access the FRED database, use File/Open Database… from the main EViews menus and choose “FRED Database”:
Click on OK to open the online database. You will be presented with a standard EViews database window with the Query and Easy Query search interface. Click on Browse or Browse–Append, which will open an all new custom FRED database. Click on the folder icons to drill down into subtopics:
The browser allows you to find data available within FRED by navigating through a set of nested folders. Simply click on any folder to move inside it.
The full path of the active folder will be shown in the header at the top of the window. You can click on any folder within the path to navigate back to that folder. Here, clicking on Categories will move back up a single level to show the category choices. Similarly, clicking on the “..” in the window listing will move up a single level.
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
The browser interface to FRED offers a number of useful tools for working with your FREDX database:
Clicking on the All Series Search folder in the FRED root directory changes the interface to allow searching by keyword. Simply enter one or more keywords into the Search For box and EViews will display a list of series that match those keywords.
You can use the Order By combo to change the order in which series are listed. By default, EViews will show the Most Popular items first, but you can order by alphabetical Description order, Recently Updated, Earliest Values, Latest Values, Highest Frequency, and Lowest Frequency.
You may click on the Add Filter button to narrow the display list. Filters will be displayed at the top of the window and may be modified, disabled, or removed by clicking on the filter description in the header.
You may use the As Of dropdown calendar to restrict the data to a particular vintage, which is handy when trying to match a particular data revision.
Right-clicking on items in the browser will bring up a menu with items for performing useful tasks:
1. Jump to Category can be used to navigate directly to the folder within the category tree that contains the selected series. If the series appears in more than one category, a list will appear for you to choose which of the folders you would like to navigate to.
2. Jump to Release can be used to navigate directly to the statistical release that contains the selected series.
3. Filter by tags allows you to see the list of tags attached to a particular series. Tags are standardized concepts that may be used to filter which series are displayed within the browser window. You may check or uncheck the tags of a series to adjust the filtering currently in effect:
4. The Show Release Dates menu item displays a list of release dates for the selected series. You may use this information in conjunction with the As Of dropdown to retrieve the historical version of a series.
5. The Copy As Of right mouse button menu item allows you to retrieve multiple historical revisions at once. Simply select one or more series in the browser window, then click on Copy As Of to see a list of available releases. Select the releases you would like to copy by clicking on them then click on the Copy Selected Releases button at the bottom of the screen.
Haver
The Haver database format is a binary file format used by Haver Analytics when distributing data.
Direct access to Haver database files is only available in the Enterprise Edition of EViews.
The main difference between Haver databases and other file formats supported by EViews is that Haver databases are read-only. You cannot create your own database in Haver format, nor can you modify an existing database. EViews will error if you try to do so.
Please contact Haver Analytics ( http://www.haver.com) directly for further information about Haver Analytics data products.
IHS Global Insight
The IHS Global Insight Database is a large and frequently updated international data offering for over 200 global markets. The Global Insight Database offers a modern interface for accessing the same data offered through the IHS Magellan interface.
To access the Global Insight Database you must have a valid IHS MyInsight username and password, which can be requested from the IHS webpage ( http://www.ihs.com/products/global-insight/data-analytics/index.aspx).
Note that access is only available in the Enterprise Edition of EViews.
To open a connection to the IHS Global Insight Database, select File/Open Database… from the main EViews menu, then select IHS Global Insight Database from the Database/File type dropdown menu:
EViews will launch the Global Insight Database Browser, allowing you to search the database of series available from IHS:
For more information see the PDF guide to using the IHS Global Insight Database Browser from within EViews, available from our website: www.eviews.com/download/download.html.
IHS Magellan
You may use EViews to access IHS Global Insight data stored in Magellan data banks Please note that an internet connection and a MyInsight account will be required to obtain IHS Magellan data.
(Note: the IHS Magellan interface has largely been replaced by the newer IHS Global Insight Database Browser; see “IHS Global Insight”.)
Bank Names
There are two ways of specifying a particular Magellan series in an EViews command:
using series type (e.g. “gdp.q.hist”)
using bankname (e.g. “us\gdp.q”)
Both of these identifiers will work no matter what bank name was specified when opening the database.
The bank name specified when opening a database only affects what happens when you use an incomplete series identifier (containing neither a series type nor a bank name).
When you specify a particular bankname when opening a database, this bankname is used as the default bankname for all operations in the database. This means that whenever you specify a series name without a leading bankname, this default bankname will be added to the front of the name. So, if you open a database with bank “US”:
“fetch gdp.q” will be interpreted as “fetch us\gdp.q”.
doing an easy query for “name matches gdp*” will be interpreted as an easy query for “name matches us\gdp*”.
When you specify the special “all banks” keyword when opening a database (“IGI”) then there is no default bank. In this case a bank name is never added to any series names, but the series type “.hist” will be added whenever a series type is required but has not been specified in a name. So
“fetch gdp.q” will be interpreted as “fetch gdp.q.hist”.
Note that in either case, you can always override the bankname specified during database open in Easy Query by adding an explicit “bankname\” to the beginning of the name. Thus, name matches “us\*” and description matches “iron steel” will produce the same results no matter the default bankname.
Special Handling of Mnemonics
EViews recognizes mnemonics in IHS Magellan databases that have illegal EViews characters (“@,” “&,” etc.) and will, if possible, prompt to rename the series before transferring it to your active workfile. The default replacement for illegal characters is an underscore. If you are using a command to fetch data, EViews will automatically replace an illegal character with an underscore.
Note that EViews drops the frequency identifier when a series is pulled into the workfile if the frequency of the series fetched matches the workfile frequency. If the original series does not match the workfile frequency, EViews will note this fact and convert the series to the workfile page frequency using the series defaults and prompt you for a name change.
For example, if you fetch the Magellan series GDP.Q into an annual frequency page of a workfile, EViews will convert the data in GDP.Q to an annual frequency (i.e., averaging the four quarters, if average is the default for high to low frequency) and it will prompt for a series name since “GDP.Q” is not a legal EViews name. The prompt will suggest the name “GDP_Q,” but you will have the option to provide different name. If instead you fetch GDP.A into the annual-frequency workfile, EViews will automatically drop the “.A,” leaving the series GDP in the workfile.
(Note that while this method of fetching data will provide you with a quarterly series from one that is reported at a monthly frequency, an better approach might be to bring the monthly series into a monthly page, then link the data into a quarterly page.)
Special Handling of Frequencies
There are two rules to make handling of Magellan (and AREMOS) frequencies easier in EViews:
1. When fetching into a workfile, if the Magellan series identifier does not contain an explicit version/frequency, EViews will add a version/frequency based on the frequency of the destination workfile.
2. When fetching into a workfile, if the Magellan version/frequency matches the version/frequency of the workfile being fetched into, then EViews will automatically trim the version/frequency from the name.
Examples:
“fetch gdp” into a quarterly workfile will try to fetch “gdp.q” (using rule 1) and then discard the version “.q” from the name (using rule 2) so that the series appears in the workfile as “gdp.”
“fetch gdp.q” into a quarterly workfile will also discard the version “.q” from the name (using rule 2) so that the series appears as “gdp.”
“fetch gdp.m” into a quarterly workfile will not match either rule, so the series will keep the illegal name “gdp.m” which EViews will suggest renaming to “gdp_m.”
copying a series from a Magellan database into an EViews database will never use either rule (because EViews databases do not have a default frequency).
Running EViews from a Network Folder
When running EViews from a folder on a local network, the IHS Magellan database extension may fail to load properly due to a restrictive Runtime Security Policy for .NET assemblies. By default, the .NET Framework does not allow the use of .NET assemblies that are located on a network folder. In order for this extension to work properly with EViews, you must grant FullTrust permissions to the EViews network folder.
To do this, go to a computer that will run EViews:
1. If you haven't already done so, run EViews on that machine. If the Register Components dialog does not appear automatically upon startup, run the regcomponents command to bring it up manually. Verify that all required components have been registered properly on this machine. Click the Yes button to register (or re-register) and wait for confirmation of success.
2. Shutdown EViews (if it is already running).
3. In Control Panel, open Administrative Tools.
4. Run “Microsoft .NET Framework 2.0 Configuration.”
5. In the left tree-view, expand the node “.NET Framework 2.0 Configuration/My Computer/Runtime Security Policy/Machine/Code Groups/All_Code.”
6. Under “All_Code,” right-click “LocalIntranet_Zone,” then click on New.
7. Enter a name and description (e.g. “EViews Network Share”). Click Next.
8. In the “Choose the condition type for this code group” list, click “URL.”
9. In the “URL” box, type in the full path to your EViews network file share followed by an asterisk to allow any extensions in that folder to run with the new permissions (e.g. “\\servername\folder\EViews 9\*”). Click Next.
10. Select “Use existing permission set” and then select “FullTrust” from the dropdown list. Click Next.
11. Click Finish.
12. Restart EViews from the network folder to obtain the new permissions. Try opening a database using the IHS Magellan database extension to verify it loads properly.
You will have to repeat this procedure on each computer that will run EViews in order to get the IHS Magellan database extension working properly from the network.
IHSMarkit
IHSMarkit provides access to financial data from a large number of datasets. To access IHSMarkit data from EViews, you must have a currently active account to the IHSMarkit data API and be able to log into it on your machine.
In addition, IHSMarkit connectivity requires that you are using the EViews Enterprise Edition.
EViews offers a custom interface to IHSMarkit data. To open the database, select File/Open Database… from the main EViews menu, then select IHSMarkit from the Database/File type dropdown menu:
You are required to enter Username and Password information before you click on OK. EViews will verify your user information and open a standard database window:
Click on Browse to open the custom IHSMarkit window:
The dialog allows you to select data available within datasets using the Namespace field. You may also search through the datasets by typing a keyword in the Filter textbox. For this example, select a dataset and click the Next button:
Select the type of identifier (id, cusip, isin, etc.) you want to use in the drop-down box. Type or paste a unique id and click the Submit button:
The dialog interface will display the list of variable names, their types, and a description. Type a keyword in the Filter textbox to filter the results. The interface also provides a graph preview of the series data selected. Once you have found and selected the series of interest, you may drag-and-drop or click the Export to workfile button to export the series directly into a new or preexisting EViews workfile.
We may go back to the top level and select the Corporate and Sovereign Bonds Pricing Data. The pricing data is organized into batches:
When batch information is available, after a unique id is entered the results table will show a list of batch-ids and metadata information. Type a keyword in the Filter textbox to filter the results.
Note that in the example shown in the dialog above, there are four tabs/buttons (Price, Instrument, Organization, TraceStatistics). The IHSMarkit API identifies these as Entities and they represent additional categories with uniquely identified records. In the above example we have selected Price (the Entity Price defines the price, yield, spreads and other metrics of an instrument.).
Select a batch id and click the Next button:
The dialog interface will display the list of variable names, types, and descriptions. Type a keyword in the Filter textbox to filter the results. The interface also provides a graph preview of the series data selected. Once you have found and selected the series of interest, you may drag-and-drop or click the Export to workfile button to export the series directly into a new or preexisting EViews workfile.
All of the IHSMarkit Edx dialogs contain a link (Browse ihsmarkit.com) to the API. Click on the link to get additional information, including documentation.
Moody’s Economy.com
The Moody's Economy.com format is a binary file format written by Moody's Economy.com tools. Moody s Economy.com features a database containing more than 190 million economic, financial, and demographic time series covering more than 180 countries and their sub-regions.
The Enterprise Edition of EViews is required to read Moody’s Economy.com formatted data.
Additional information on Moody's Economy.com databases can be found at http://www.economy.com.
NOAA (National Oceanic And Atmospheric Administration)
NOAA provides access to a list of datasets that offer a large range of publicly available weather and climate data. Please note that an internet connection will be required to obtain NOAA online data. For more information on the datasets, please see
https://www.ncdc.noaa.gov/cdo-web/webservices/v2#datasets
EViews offers a custom interface to NOAA data. To open the NOAA database, select File/Open Database… from the main EViews menu, then select National Oceanic And Atmospheric Administration from the Database/File type dropdown menu:
Use of the NOAA service is free but requires registration. The first time you attempt to open the database you will be asked to enter an API Key obtained from the National Oceanic And Atmospheric Administration:
Please enter your API key and then click on OK. The key will be saved as a user specific setting in your EViews “.ini” file. If you need to change the key at a later time, select View/Preferences… from the EViews database menu to modify your settings.
When you click on OK, EViews will open a standard database window:
Click on Browse to open the custom NOAA window:
The dialog allows you to select data available within datasets. The first step to access data is to select a NOAA dataset from the drop down list. The dialog interface allows you to continue your search for data either by selecting a Location category (city, county, climate division, etc.) or by typing or pasting the ids of the stations you are interested in. Click the Next button to navigate to the next dialog:
If you chose the location category (e.g., cities) you will be able to select one or more locations to get station data from. The interface allows you to filter and customize the available locations by typing a keyword in the Filter By textbox and clicking the Filter button. Use the navigation Next button to select one or more datatypes:
If you previously selected more than one location you are going to see two tabs: Shared and All Available. The Shared tab displays all the datatypes that are shared between the locations and the All Available tab displays all available for the locations selected. You can use the Filter button to customize your search results. Click the Next button to view the available NOAA stations:
A dialog that contains a table with all the available stations is displayed. The interface provides a way to search through the stations by typing a keyword in the Filter By textbox and clicking the Filter button. Click the Select button to select the series:
You will be asked to choose a date range, specific to each dataset, in order to limit the data results. For annual and monthly data the default is a ten year range; all other data are limited to a one year range.
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
OECD SDMX (Organisation for Economic Cooperation and Development Statistical Data and Metadata eXchange)
Eurostat, ECB, UN, IMF, OECD, ABS, DB, and Insee
SDMX Databases contain a large range of publicly available data. Both the Standard and Enterprise versions of EViews offer access to Eurostat, ECB (European Central Bank), UN (United Nations), IMF (International Monetary Fund), OECD (Organisation for Economic Cooperation and Development), ABS (Australian Bureau of Statistics), Deutsche Bundesbank (DB), and L’Institut national de la statistique et des études économiques (Insee) using SDMX Web Services.
Please note that an internet connection is required to obtain SDMX online data. For more information on the datasets, please see
http://ec.europa.eu/eurostat/data/database
https://ec.sdw-wsrest.ecb.europa.eu
http://data.un.org/WS/
http://sdmxcentral.imf.org
http://stats.oecd.org/restsdmx/sdmx.ashx
http://api.data.abs.gov.au
http://api.statistiken.bundesbank.de
http://www.insee.fr/en/information/2868055
EViews offers a custom browser for navigation to and retrieval of available data from SDMX databases. To start, open a database window by selecting File/Open Database… from the main EViews menus, then select Eurostat SDMX Database, ECB SDMX Database, UN SDMX Database, IMF SDMX Database, OECD SDMX Database, ABS SDMX Database, Deutsche Bundesbank SDMX Database, or Insee SDMX Database from the Database/File type dropdown menu. A dialog similar to the one below will be displayed:
Click OK to open the standard EViews online database representing a connection to data. Click on Browse or Browse-Append to open a custom database.
For example, this is the interface to the Eurostat data:
The dialog allows data to be selected from within datasets; alternatively, the browser interface is a way to search through the datasets by typing a keyword in the Filter textbox:
Select a dataset and click Next to display a dialog for viewing and selecting series:
The dialog contains a table with all of the series matching the search. On the left is an interface with a list of dropdown boxes containing additional search filter criteria. Click a box or boxes to select one or more options. If more filter criteria are selected the results on the right will be updated to match the new selections. On the bottom right is a graph preview of the series data selected.
Once the selection process is finished, drag-and-drop or click the Export to workfile button to export the series directly into a new or existing workfile.
RATS 4.x
The RATS 4.x format is a binary file format used by RATS Version 4 through 7 on all platforms.
The main issue to be aware of when working with RATS 4.x format files is that the “.RAT” extension is also used by RATS version 3 files. EViews will neither read from nor write to RATS files in this earlier format. If you try to use EViews to open one of these files, EViews will error, giving you a message that the file has a version number which is not supported.
To work with a RATS Version 3 file in EViews, you will first have to use RATS to translate the file to the Version 4 format. To convert a Version 3 file to a Version 4 file, simply load the file into RATS and modify it in some way. When you save the file, RATS will ask you whether you would like to translate the file into the new format. One simple way to modify the file without actually changing the data is to rename a series in the file to the name which it already has. For example, if we have a Version 3 file called “OLDFILE.RAT”, we can convert to a Version 4 by first opening the file for editing in RATS:
dedit oldfile.rat
then listing the series contained in the file:
catalog
then renaming one of the series (say “X”) to its existing name
rename x x
and finally saving the file
save
At this point, you will be prompted whether you would like to translate the file into the Version 4 format.
See the RATS documentation for details.
 
SDMX-ML Files
SDMX (Statistical Data and Metadata eXchange) standardizes the processes for the exchange of statistical data among international organizations. EViews offers an interface to SDMX data where the user has the ability to read SDMX datasets and data structure definitions (DSD) in structured XML documents (SDMX-ML), using the standard EViews database interface. EViews allows you to work offline with data from organizations like EUROSTATA, ECB, IMF, UN, BIS, and OECD. Both the Standard and Enterprise versions of EViews offer reading of SDMX data. Please note that the EViews SDMX-ML interface requires that data were previously downloaded in SDMX XML format.
To start, you must open a database window to SDMX-ML by selecting File/Open Database… from the main EViews menus, then selecting SDMX-ML files from the Database/File type dropdown menu. The following dialog should appear:
Click on Browse Path to select the folder/path on disk where the SDMX data and data definitions files are located.
Click on OK to open the database. You will be presented with a standard EViews database with the All, Query and Easy Query search interface, to view all or a selection of the data series:
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
Trading Economics
Trading Economics provides access to a large range of historical and forecast data for economic indicators, stock markets, government bonds, exchange rates, and commodity prices.
An internet connection is required to obtain Trading Economics online data. For more information on data subscriptions, please see:
https://tradingeconomics.com/analytics/features.aspx
Additionally, direct access to Trading Economics online data is only offered in the EViews Enterprise Edition.
EViews offers a custom interface to Trading Economics data. To open the database, select File/Open Database… from the main EViews menu and select Trading Economics from the Database/File type dropdown menu:
Click OK to open the standard EViews database window:
Click on Browse in the toolbar to open the custom Trading Economics window:
The dialog interface displays five tabs, or categories, of data: Indicators, Market Currencies, Market Stocks, Market Commodities, and Market Bonds.
Indicators
Under the Indicators tab, choose between picking a country/territory, an indicator category, or a search:
For Pick Country/Territory, select a country from the drop-down box to see historical and forecast indicators:
For Pick Indicator Category, select a category from the drop-down box to see historical and forecast indicators:
For Search, select Term/Keyword or Symbol and enter an expression in the text box:
The user interface provides a way to filter through the results regardless of the method chosen. After picking the country Mexico, for example, the dialog displays a table with the indicator results:
Click the drop-down box next to each column header to show a set of filter checkboxes. Select one or more of these to display selected values or select All to show all values. Click Reset Filter to clear all filters.
Markets
If any of the market tabs (Market Currencies, Market Stocks, Market Commodities, Market Bonds) are selected, the dialog will display a table with all the stock market symbol results you have permission to see based on your subscription. For example, the below dialog shows the Market Stocks tab:
You may elect to search for a Term/Keyword or a Symbol. Once the series of interest is found and selected, drag-and-drop or click the Export to workfile button to export the series directly into a new or existing workfile.
For more information click the Browse Trading Economics Stocks link at the bottom of the dialog to open the Trading Economics webpage.
World Bank Data
EViews offers a custom interface to World Bank data. World Bank Open Data provides access to a list of datasets that offer access to global development data. These databases offer a wide variety of freely downloadable indicators about development in countries around the world.
For more information on the World Bank datasets, please see http://data.worldbank.org.
Both the Standard and Enterprise versions of EViews offer World Bank access. Please note that an internet connection will be required to obtain World Bank data.
EViews offers a custom interface to the World Bank. The interface includes a browser for navigating and retrieval of World Bank data. To start, you will open a database window by selecting File/Open Database… from the main EViews menus, then selecting World Bank Database from the Database/File type dropdown menu. The following dialog should appear:
The default Data Source selected is World Development Indicators (a collection of development indicators that includes global development data). Click on Browse to view and select another data source.
Click on OK to open the online database. You will be presented with a standard EViews database window.
The database window represents a connection to the data. Click on Browse or Browse-Append, which opens a new custom World Bank database. Click on the folder icons to move down into subtopics:
The browser allows you to find data available within the World Bank by navigating through a set of nested folders. Simply click on any folder to move inside it.
The full path of the active folder will be shown in the header at the top of the window. You can click on any folder within the path to navigate back to that folder. Here, clicking on Countries will move back up a single level to show the country choices. Similarly, clicking on the ".." in the window listing will move up a single level.
The browser interface to the World Bank offers a number of useful tools for working with your World Bank database:
The Search button allows searching by keyword. Simply enter a keyword into the edit box and click the Search button. EViews will display a list of indicators that match the keyword.
You can use the < and > buttons to navigate to the next and the previous indicator pages.
You can use the |< and >| buttons to navigate to the first or last indicator pages.
Right-clicking on items in the browser will bring up a menu with items for performing useful tasks:
1. Right-click Open can be used to navigate inside a folder or bring an indicator in the database window.
2. Right-click Copy can be used to select an indicator to be copied to a workfile
3. Right-click Find allows you to do a keyword search.
Once you have found the series of interest, you may drag-and-drop (or copy-and-paste) the series directly into an EViews workfile in the usual fashion.
World Health Organization
World Health Organization (WHO) provides access to a large range of health-related data and statistics. An internet connection is required to obtain WHO online data.
For more information on data subscriptions, please see:
https://www.who.int/data/gho
EViews offers a custom interface to World Health Organization data. To open the database, select File/Open Database… from the main EViews menu and select World Health Organization from the Database/File type dropdown menu:
Click OK to open the standard EViews database window:
Click on Browse in the toolbar to open the custom WHO window:
Click on the Indicators folder and navigate through the set of nested folders:
Click on a folder to open its subtopics:
The full path of the active folder is shown in the header. Click on any folder within the path to return to it. For example, clicking on By country will move up a single level to show the country choices. Similarly, clicking on “..” in the window listing will move up a single level.
Alternately, click on Search By to search for a keyword:
Once the series of interest is selected, drag or copy it into a workfile. For more information, click the Open Browser link at the bottom of the dialog to open the WHO website.