Home > Business Databases, company information > Combine a static request into a time series request in Datastream

Combine a static request into a time series request in Datastream

Thomson Reuters logoOne of the fundamental concepts of Thomson Reuters Datastream is the distinction of two classes of datatypes (variables), namely static and time series. Their requests (searches) are performed separately and in different ways. This blog post summarises the difference and shows how to combine them in a single request. It assumes you are familiar with the basic Datastream request concept of selecting an entity, a datatype and date period. It uses the Datastream Advance for Office Excel add-in (DAO); the principle equally applies to the newer 64-bit Datastream for Office add-in (DFO).

Datastream combined request 01What are static and time series requests?

  • A time series request looks at datatypes which change with regular frequency (daily to yearly) and includes a specified date range and frequency. Examples of time series datatypes include share price, market value, GDP and turnover.
  • A static request looks a datatypes which seldom or never change, with often just the latest value available. Examples of static datatypes include company name, base date, currency of a stock and country of origin.

There is a separate command in Datastream to request each of these classes of datatypes. If you want to get some of both for a list of entities or companies, you could perform two separate requests and carefully line up the results of both in Excel. There is an easier way, however.

How do I add static data into a time series request?

You can include static datatypes in the header of a time series request. Follow these steps to get the monthly price and market value for the last two years for Tesco, Sainsbury and Morrison supermarkets along with their ISIN codes and price currency.

Datastream combined request 02

Steps 1 and 2: start a time series request with custom header.

Datastream combined request 03

Steps 3 and 4: select static datatypes for the custom header.

  1. Start a new Time Series Request as usual. Select the entities (e.g. TSCO, SBRY, MORW) and time series datatypes (e.g. P, MV) as usual, but do not click “Submit” yet. Set the date period and frequency (e.g. -2y and monthly).
  2. In the Options panel, choose the option “Display Headings” and “Display Custom Header” then click the “Edit” button next to the latter.
  3. In the new dialog window, click the “Datatypes” button. Use the Datastream Navigator to restrict the search to just Static datatypes (you may need to “Stop Filtering” a previous search), then search as usual and tick the variables you wish to use (e.g. ISIN, PCUR). Click the blue “Use” link when finished.
  4. Remember to click the plus “+” button to add this selection of static datatypes to the “Selector” box. Click “OK”, then click “Submit”.
  5. The results should look like this (below).
Datastream combined request 04

A time series Datastream request with a custom header including static datatypes.

  1. 8 March 2018 at 4:33 pm


    how can you set datastream in Excel to an output format you are using? When give the same input as you, datastream in excel looks completely messed up – e.g. with the company name in front of every seperate item.

    Thanks in advance

    • Phil Reed
      15 March 2018 at 9:25 am

      Hi Martin, the short answer is to use Request Tables to have more control over the output. https://wp.me/pEmVJ-GG

  1. 10 July 2015 at 3:28 pm
  2. 17 July 2015 at 3:22 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.