Datastream user guide

A modern-day Enigma machine.

Datastream user guide

If your browser does not support JavaScript, please read the page content below: Static requests To request data for a specific date. For more information, see Creating a static request. Time series requests To request data over a specific period, defined by a start date, end date, and frequency of data.

Datastream user guide

For more information, see Creating a time series request. Request Manager Use the Request Manager to manage your embedded requests.


All the chart and data requests in your Excel work book are listed with their details. You can edit, delete, or refresh the requests individually or together. For Datastream user guide information see Using the request manager. To select these options: Choose Options from the Thomson Reuters Datastream menu.

Datastream Excel - Database Guide: Datastream - Research Sources & Guides at Stanford University At the Datastream terminals in the library, click on the Excel for Datastream Users icon. From that dropdown menu, select Time Series.

The Options dialog is displayed. Select the Request Format tab. Select the options you require by checking the boxes: Clicking the Default Option button on these dialogs returns the format options back to the default settings on the Options dialog.

Changes to the settings on the Options dialog will only take effect after Excel has been re-launched, or if the Default Option button on the request dialog is used. The request format options are: Row Titles - displays the series code at the top of each row for each series.

Column Titles - displays the datatype mnemonic at the top of each column. Headings - displays a general heading for row and column titles.

For example, the date of the request. Currency - displays an additional column with the title Currency and with the traded currency of each selected series. Transpose Data - displays individual time series data across the Excel spreadsheet in rows. This is particularly useful if you are requesting data over very short time periods or larger reporting frequencies, that is quarterly or yearly.

The maximum number of columns that you can use in Excel is Latest Value First - displays the latest value first in the request result. Display code - displays the series mnemonic. This option is available for Time Series request.

Hyperlink to metadata or Datatype definition - Adds a hyperlink to the series code to link to the classifications and metadata pages from Navigator for the series also enable series that are now dead or inactive to be identified in your workbook. Cell Referencing - this enables this with or without the trigger cell.

This trigger uses a cell above the request to detect if the contents of the referenced cells have changed to initiate an update.

Embed Formula - ensures that the request is embedded in Excel as a dynamic, refreshable object when saved.


Suppress Comments - removes row headings e. Display Datatype - According to the option selected, the Datatype description or mnemonic is displayed in the Static request results.

Display Expression - According to the option selected, the Expression description or number is displayed in the Static and Time Series request results. Data options - The Not Available String field enables you to type the text that you want displayed in Excel when data is not available from Datastream.

Enter "Blank" word in Not Available String input field if you have not entered any. Select Information or Trace to view and delete logs, note that delete log clears all old logs except the current day's log.

Overwrite all values if series exists - to overwrite existing values. Using Excel with Datastream for Office Page 7 of 46 Performance and Logging — You can enable parallel request processing to improve the performance.FUTURES USER GUIDE. JANUARY Introduction.

Datastream user guide

This manual is intended for all users of the Datastream product. It focuses on the Commodity and Financial Futures content within the product, conventions, data attributes available and any related documentation. Datastream Global Equity Indices break down into six levels. Level 1 is the market index, this covers all the sectors in each region or country.

Level 2 divides the market into 10 industries and covers all the sectors within each. At other times, a user may want to create a unique list which can be saved and updates as needed.

MP2 Software |

To create a Local List, open Excel and click on the Datastream-AFO tab located at . This manual gives a short instruction of how to use the Datastream Add-In in Excel. The purpose of these notes is to show by example how most standard queries can be performed. Training for Thomson Reuters financial markets products.

View onDemand and instructor led courses for products including Thomson Reuters Eikon, Reuters Xtra and Datastream.

Datastream Futures. Overview: Most users can use the front contract continuous uses the price of the most current contract and pricing automatically rolls over when the original contract expires.

Datastream | ESSEC Knowledge Lab