Datastream is accessed from a workstation on the 12th Floor of the Science Library.
Turn left off of the elevators towards the offices. The workstation will be on your left in the corner.
When you arrive at the workstation, open Excel. You will use an excel plugin called Datastream Navigator (DNO) to browse indicators, make your selections, and extract data.
Datastream is a database which contains current and historical data on stocks, indices, bonds, funds, futures, options, interest rates, commodities, and economic indicators.
There are millions of economic indicators from National Statistical Offices as well as third party data providers like Refinitiv Worldscope, Economist Intelligence Unit and ESG data providers.
Datastream for Office is accessed through an Excel Add-on. Open Refinitiv Eikon Excel.
To activate the add-on, click the Eikon tab in Excel. Click "Sign In."
It will automatically log in after a few seconds. Click the tab "Datastream" to access the data navigator, download data or use the charting functions.
On the Datastream tab, click "Find Series" to open Datastream Navigator (DNO).
Datasets are organized by category, with the most indicators available under the Economics. You can find indicators by searching or browsing by category.
If you are looking for more than one item, you can check the box to add the items to your selections. to return a list of your selected indicators, click "My selections" in the upper right corner, then select "Return items."
A time series is a dataset that provides data for a series, indicator or instrument over a period of time, at a set interval like daily, weekly or monthly. When you are looking for series in Datastream, make note of the frequency because the available frequency and the frequency entered in the data request need to match.
From the Datastream tab, click "Time Series Request."
Enter the series code if you have it, or click find series to open Datastream Naviagtor. You can enter multiple series codes separated by a comma.
Select the dates and frequency you want and click submit. The data will be returned starting in the cell you selected on the spreadsheet.
In the screenshot above, you can see that the selected cell is a formula. You may want to copy & paste this formula in to a document to save in case you want to come back and use this indicator again in the future. This is a live formula that only works when you are logged in to Eikon.
In order to access your data from your own computer, you must copy and paste values from your extraction in a new spreadsheet before uploading or emailing it to yourself.
NOTE: You must copy and paste values from your extraction in a new spreadsheet before uploading or emailing it to yourself.
Try the following if the Eikon or Datastream tabs are not showing in Excel:
If you don't see the Refinitiv Eikon or Refinitiv Datastream tabs in Excel, search the computer for Eikon. Select the result for "Refinitiv Eikon -Microsoft Excel".
If it does not open, confirm that the add-on is activated:
If the above steps don't work, restart the computer.
If restarting the computer does not work, email firstname.lastname@example.org for help.