Figure it out with DataStream

By Jun.23, 2016

DataStream is a database for financial and economic research data from Thomson Reuters.  It contains current and historical data on stocks, indices, bonds, funds, futures, options, interest rates, commodities, and economic indicators with coverage back to the 1960s.   PGR students can use DataStream in the PGR room in the Maxwell Building.  It is also available on the first floor of Clifford Whitworth where it can be used by all students – see the map below for the location:

Map showing location of the software.

To carry out a simple search in DataStream:

  • Open Excel & click the DataStream tab on the tool bar.
  • Click on the Time Series Request option – this allows you to request data for a specific time period.

DataStream 1Capture

  • The following box will appear:

DataStream 2Capture

  • Use the Find Series button to search for the code for the company, commodity, index etc. you are interested in.
  • Use the Datatypes button to search for the type of data you are interested in – if you leave this box blank the default code P (price) will be used.
  • Use the Start and End Date boxes to specify a time period.
  • In the Options section choose which items you want to display e.g. column headings, currency etc.  Make sure that you do not have Auto Refresh selected – this function will try to update your spreadsheet  whenever you open it.

This guide is just a starting point – a collection of video guides are available on the Thomson Reuters site.

If you need to find a specific piece of data use the Thomson Reuters Help desk which is available via the Contact Us link on the DataStream tool bar:

DataStream 3Capture

Use your University of Salford email address in the Corporate Email box:

DataStream 4Capture

 

Leave a comment