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
AREMOS
AREMOS TSD
Bloomberg
Limitations
Bureau of Labor Statistics (BLS)
CEIC
Datastream
DRIPro Link
DRIBase Database
EcoWin
Interactive Graphical Interface
Tips for Working with EcoWin Databases
EIA (U.S. Energy Information Administration)
Online EIA Database
Offline EIA Databases
Eurostat, ECB, UN, and IMF
FactSet
FAME
FRED
GiveWin/PcGive
Haver
IHS Global Insight
IHS Magellan
Bank Names
Special Handling of Mnemonics
Special Handling of Frequencies
Running EViews from a Network Folder
Moody’s Economy.com
RATS 4.x
RATS Portable
SDMX-ML Files
TSP Portable
World Bank Data
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).
There are special issues relating to working with DRIPro links. See “DRIPro Link” 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
AREMOS
EViews allows you to open and access data in AREMOS data banks using the standard EViews database interface. Bear in mind that there are a few limitations when working with AREMOS data banks:
EViews can only translate series, matrix and list objects. AREMOS models and equations will be displayed in a database query, but cannot be imported into EViews. AREMOS list objects are translated into string objects inside EViews, with AREMOS comma delimited lists translated into EViews space delimited lists so that they can easily be used in EViews for loops and with the EViews “word” manipulation functions that begin with the “@w”).
EViews does not support the following AREMOS frequencies: two-monthly, lunar, periodic and daily with non-consecutive days of the week. All other frequencies should be supported. Series with unsupported frequencies will be read into EViews as “undated” series. Note that series containing weekly data should be translated correctly, but will be labeled slightly differently in AREMOS and EViews since EViews labels each observation with the first day of the week and AREMOS labels each observation with the last day of the week. (You can use the @enddate series in EViews to display the same dates that AREMOS would use for each observation).
EViews cannot handle databanks that contain multiple objects with the same name and version (but different object types). Queries that return more than one object with the same name and version cause EViews to error, and fetching objects with one of these shared names is unreliable.
EViews does not add/hide default versions to the end of names based on the working frequency in the same way that AREMOS does. AREMOS versions are simply treated as part of the object name. Since the dot character is illegal in EViews object names, this means that most objects in an AREMOS databank have illegal names. There are a variety of mechanisms in EViews to help users to work with objects with illegal names which will automatically come into play when working with AREMOS databanks. (The default outcome is that the dot that separates the name and version in Aremos will become an underscore when the object is moved into an EViews workfile or database).
Note also that there are special rules for handling AREMOS frequencies when fetching AREMOS data into EViews. See “Special Handling of Frequencies” for discussion.
AREMOS TSD
The TSD format is a portable ASCII file format written by the AREMOS package. The EViews database tools provide an intuitive graphical interface to the data, and allows you to move data directly in and out of an EViews database without having to move the data through a workfile (which may force the data to be converted to a single frequency).
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 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 https://api.bls.gov/publicAPI/v2/timeseries/data/, which you should not need to 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.
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).
DRIPro Link
A DRIPro link is a special type of database which allows you to fetch data remotely over the internet from DRI’s extensive collection of economic data. To access these data, you must have a valid DRIPro account with DRI, and you must have already installed and configured the DRIPro server software.
(Note: the DRIPro Link interface has been replaced by the newer IHS Global Insight Database Browser; see “IHS Global Insight”.)
There are special issues involved with using DRIPro links, which are discussed in detail in “Working with DRIPro Links”.
DRIBase Database
The DRIBase system is a client server system used by DRI to provide databases at the client site which can be kept current by remote updates. Customers can also use DRIBase as a means of storing their own databases in an Sybase or Microsoft SQL Server system.
(Note: the DRIBase interface has been replaced by the newer IHS Global Insight Database Browser; see “IHS Global Insight”.)
DRIBase access is only available in the Enterprise Edition of EViews.
To access DRIBase databases, the TSRT library from DRI must already be installed on the client machine (this will normally be done by DRI as part of the DRIBase installation procedure).
When working with DRIBase databases, the Server specification field should be set to contain the DRIBase database prefix, while the Database name field should contain the DRIBase bank name, including the leading “@” where appropriate. Note that these fields, as well as the Username and Password fields may be case sensitive, so make sure to preserve the case of any information given to you.
A DRIBase database has slightly different handling of frequencies than most other databases supported by EViews. See “Issues with DRI Frequencies” for details. You should also read “Dealing with Illegal Names” for a discussion of how DRI names are automatically remapped by EViews.
For further information on DRIBase, please contact IHS Global Insight (http://www.globalinsight.com).
EcoWin
EcoWin database support provides online access to economic and financial market data from EcoWin. The EcoWin Economic and Financial databases contain global international macroeconomic and financial data from more than 100 countries and multinational aggregates. Additional databases provide access to equities information and detailed country-specific information on earnings estimates, equities, funds, fixed income, and macroeconomics. For further information on EcoWin data and software, please contact EcoWin directly (http://www.thomsonreuters.com/products_services/financial/financial_products/investment_management/research_analysis/ecowin_pro).
EcoWin database access is only available in the Enterprise Edition of EViews.
With EViews Enterprise Edition, you can open an EViews window into an online EcoWin database. This window allows browsing and text search of the series in the database, selecting series, and copying/exporting series into an EViews workfile or another EViews database. In addition, EViews provides a set of commands that may be used to perform tasks such as fetching a particular series from a EcoWin database.
Access to EcoWin databases within EViews Enterprise Edition requires that the EcoWin Pro software has already been installed on the local machine, and that configuration of EcoWin database access using the EcoWin Database Configuration software has already been completed outside of EViews.
Interactive Graphical Interface
To open a graphical window to an EcoWin database, you should first open Database Specification dialog by selecting File/Open/Database… from the main EViews menu. Next, choose EcoWin Database in the Database/File Type dropdown, and enter the name of the online database as specified in the EcoWin Database Configuration software, typically “DEFAULT”.
Clicking on OK will open an empty EViews database window. To access the EcoWin data, click on the Query–Select button in the database window toolbar. EViews will open a window containing a EcoWin Pro control for browsing and searching the online data. Note that it may take a bit of time to initialize the EcoWin control. Once initialized, EViews will open the EcoWin Query window.
The EcoWin Query window provides you with two methods for selecting series to be brought into your EViews database.
First, you may use Tree Search to browse a directory structure of the online database. You should use the tree on the left to navigate to the directory of interest, then select series in the window on the right by clicking or control-clicking on the entry, or by clicking on the right-mouse button and choosing Select All. Once the desired series have been highlighted, click on OK to bring the selected data into your EViews database.
This procedure, first browsing to find a directory containing data of interest, selecting series, and then clicking on OK to bring in data, can be performed multiple times, until a list of all the series that you wish to use has been accumulated within the EViews database window. At this point the EcoWin browse control can be closed using the Cancel button.
In place of browsing the tree structure of the database, you may elect to use text search to display a list of series in the database. Click on the Text Search selection at the top of the dialog to change the dialog to the search display, and enter the information in the appropriate fields. For example, to search for all series in the database using the text “PETROLEUM” and “US”, we have:
Highlight the series of interest and click on OK to bring them into the database. Repeat the tree browsing or search method of adding series until the list in the database is complete, then click on Cancel to close the query window.
Once series of interest have been included in the database window, all of the standard EViews database tools, such as copy and paste into an existing workfile or database using the right mouse menus, creating a new EViews workfile containing the data using the Export button, or importing data into an existing EViews workfile using the Fetch menu item from the workfile window, are available.
Note that after you have completed your initial query, you may reopen the EcoWin query window at any time. To add series to those already available in the database window, press the Query Append Select button in the database window, then browse or search for your series. To first clear the contents of the database window, you should press the Query Select button instead of the Query Append Select button.
Tips for Working with EcoWin Databases
If an EcoWin database is going to be used frequently or for direct access to individual series, you should find it useful to add an EcoWin entry in the database registry (“The Database Registry”).
The EViews database registry may be accessed by choosing Options/Database Registry... from the main EViews menu. Press Add New Entry to add a new database registry entry to the list. The procedure for adding an EcoWin database to the registry is identical to that for opening an EcoWin database. The Database/File Type field should be set to EcoWin Database and the Database Name/Path field should be filled with the name assigned to the database in the EcoWin Database Configuration software (generally “DEFAULT”).
Once the EcoWin database has been put in the registry, it may be referred to by its alias (short hand) name. For example, if you have assigned the EcoWin database the alias “EW”, you can open the database with the simple command:
dbopen ew
or by using the Browse Registry button in the Database Specification dialog. The database name “EW” will be added to the most recently used file list, where it may be selected at a later time to reopen the database.
Assigning the EcoWin database a shorthand name also allows you to reference data without explicitly opening the database. For example, the command
equation eq1.ls ew::usa09016 c ew:usa09016(-1) @trend
runs a regression of U.S. unemployment on an intercept, its own lagged value, and a time trend. The series USA09016 will be accessed directly from the EcoWin servers, and does not need to appear within a currently open database window for this command to be used. Other commands such as copy allow the name associated with the series to be changed during the procedure, as well as supporting the copying of series directly from an EcoWin database to another EViews database.
show ew::usa09016
displays a table of U. S. unemployment.
Note that series in the EcoWin “Economic” or EcoWin “Financial” databases may be referenced merely by using the database shorthand and the series name. In the example above, EViews looks for USA09016 in the two base EcoWin databases.
Series located in add-on EcoWin databases such as “Bank of England,” “Bundesbank,” “Bureau of Economic Analysis,” must also provide the name of the add-on database in which the series is located. You should provide the name of the EcoWin shortcut followed by a double colon, an EcoWin add-on database prefix, a slash, and then the series name. For example, you can fetch the mortgage rate (LUM5WTL) in the Bank of England database with
fetch ew::boe\lum5wtl
where we follow the database name with the add-on name BOE. The series will be named “BOE\LUM5WTL” in EViews. Note that the add-on name BOE is taken from the EcoWin name prefix (for example, LUM5WTL appears as “BOE:LUM5WTL” within EcoWin.
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 as well as 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 Online Database from the Database/File type dropdown menu:
The server specification will be automatically filled in with the EIA server address api.eia.gov which you should not need to change. The database will always be opened with the name “eia”. 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 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, use View/Preferences… from the EViews database menus 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 the data available within the database as a set of folders, where each folder may contain additional folders or a list of series available for downloading. 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. You can also move directly to any folder within the current path by clicking on the path component at the top of the window.
Any series contained in the folder may be manipulated in the usual fashion. When you have finished working with the browser, simply close the browser window to restore the regular EViews database window.
Offline EIA 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. Finally, rename the “.txt” file to “.eia” so EViews can tell that the file contains data in EIA bulk file format rather than a generic text file.
Once the bulk file has been prepared, use File/Open Database… and browse to the file or simply drag and drop the file onto EViews to open it. 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 data sets are large (hundreds of megabytes of uncompressed data). When working with large files you may see a delay as the file is opened since EViews must completely 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 the machine.
Eurostat, ECB, UN, and IMF
SDMX Databases provide access to a list of datasets that offer 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), and IMF (International Monetary Fund) data using SDMX Web Services.
Please note that an internet connection will be 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
EViews offers a custom interface to the SDMX databases. The interface includes a custom browser for navigating and retrieval of available data. To start, you must open a database window to SDMX database by selecting File/Open Database… from the main EViews menus, then selecting Eurostat SDMX Database, ECB SDMX Database, UN SDMX Database, or IMF SDMX Database from the Database/File type dropdown menu. A dialog similar to the one below will be displayed:
Click on OK to open the online database. You will be presented with a standard EViews database representing a connection to data. Click on Browse or Browse-Append to open a custom database.
Here we see the interface to the Eurostat data:
The browser allows you to find data available within datasets by navigating through a set of folders. Click on any folder to move inside it. A dialog with a list of filters will be shown, which will allow you to filter and customize the search results of the available series objects in the selected dataset.
Click on OK to show the results.
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. Similarly, clicking on the ".." in the window listing will move up a single level.
The browser interface to the data offers a number of useful tools for working with your Eurostat database:
The Search button allows searching the browse window by keyword. Simply enter a keyword into the edit box and click the Search button. EViews will display a list of data sets or series that match the keyword.
Right-clicking on items in the browser will bring up a menu for performing useful tasks:
1. Open can be used to navigate inside a folder or bring a series object in the database window.
2. Copy can be used to select a series object to be copied to a workfile
3. Find allows you to do find a keyword on your window.
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.
FactSet
The FactSet database is a remote database provided by FactSet Research Systems. It is composed of more than 800 commercial data sets of financial data. Data include international macroeconomic, commodity, and financial time series from more than 150 countries.
Use of FactSet databases requires the Enterprise Edition of EViews and installation of FactSet client software. For further information on using Factset please contact Factset directly (http://www.factset.com).
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.
GiveWin/PcGive
The GiveWin/PcGive format is a binary file format used by GiveWin, PcGive versions 7 through 10, and PcFiml.
There are two issues when working with GiveWin/PcGive files. The first is that EViews is case insensitive when working with object names, while GiveWin and PcGive are case sensitive. Because of this, if you intend to work with a file in both packages, you should avoid having two objects with names distinguished only by case. If your files do not follow this rule, EViews will only be able to read the last of the objects with the same name. Any early objects will be invisible.
The second issue concerns files with mixed frequency. The GiveWin/PcGive file format does support series of mixed frequency, and EViews will write to these files accordingly. However, GiveWin itself appears to only allow you to read series from one frequency at a time, and will ignore (with error messages) any series which do not conform to the chosen frequency. Consequently, depending on your application, you may prefer to store series of only one frequency per GiveWin/PcGive file.
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.
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.
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.
RATS Portable
The RATS portable format is an ASCII file format which can be read and written by RATS. It is generally slower to work with than RATS native format, but the files are human readable and can be modified using a text editor.
You can read the contents of a RATS portable file into memory in RATS with the following commands:
open data filename.trl
data(format=portable) start end list_of_series
close data
To write what is currently in memory in RATS to a RATS portable file, use:
open copy filename.trl
copy(format=portable) start end list_of_series
close copy
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.
TSP Portable
The TSP portable format is an ASCII file format which can be read and written by copies of TSP on all platforms. The file consists of a translation of a TSP native databank (which typically have the extension “.TLB”) into a TSP program which, when executed, will regenerate the databank on the new machine.
To create a TSP portable file from a TSP databank file, use the DBCOPY command from within TSP:
dbcopy databank_name
To translate a TSP portable file back into a TSP databank file, simply execute the TSP file as a TSP program.
Once the data are in TSP databank format, you can use the TSP command,
in databank_name
to set the automatic search to use this databank and the TSP command,
out databank_name
to save any series which are created or modified back to the databank.
See the TSP documentation for details.
World Bank Data
EViews 10 offers a new 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. Open can be used to navigate inside a folder or bring an indicator in the database window.
2. Copy can be used to select an indicator to be copied to a workfile
3. 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.