Datastream access at the University of Toronto

Content: Introduction | Citing Datastream time-series | Access | Interface selection | Macros | Documentation | Installation instructions | Additional information


Introduction

The Data Library Service has acquired an account with Datastream International which provides the University with access to a remote database of circa 1.5 billion time-series of financial and economic statistics, covering all countries of the world. The Datastream database covers company, financial and economic data from all major markets in the world. The data are grouped as: equities, bonds, company accounts, stock market indices, interest and exachange rates, economic statistics, futures and options, warrants, and commodities.

The data are restricted access, for University of Toronto faculty, students, and staff, for purposes of academic university research and teaching only.


How to cite Datastream time-series

The Datastream service agreement requires that users cite Datastream as the source of all data from that source used in publications etc. The bibliographic citation of Datastream data should follow these guidelines:

Elements of a citation:
ElementDescription
Author or Corporate-authorThe entity responsible for the intellectual content of the item, i.e. Datastream International Ltd.
TitleA unique, identifying title for the item, i.e. Datastream database
Medium designatorThe phrase '[computer file]' to distinguish the item from a book, a periodical, etc..
SeriesThe individual time-series identifiers that were retrieved from the database. E.g. BBDEM1F, BBDM3F, VWCAD3F
PlacePlace in which corporate headquarters are located, i.e. London
PublisherThe producer of the database, i.e. Datastream International Ltd.
DateThe date on which the time series used in your analysis were retrieved from the database

Example:

Datastream International Ltd./ Datastream database [computer file]: BBDEM1F, BBDM3F, VWCAD3F. London: Datastream International Ltd., retrieved August 6, 1999.


Access

In order to access Datastream at the University of Toronto, you must use specific computers that have the proprietary Datastream interface software installed and are authorized to access the Datastream network.

Workstations with the Datastream software are available in the following locations:

Because the University has only one account with which to access Datastream, only one user can access the Datastream database at any one time. The following schedule has been agreed upon between the BIC and the DLS, to avoid problems of clashing simultaneous users at different locations.

When the access is needed at another location, the scheduled location should be notified; to notify the BIC call 978-3421, and to notify the DLS call 978-5365 or 978-5589.

Access schedule
Time Day of the week and location
  Monday Tuesday Wednesday Thursday Friday Saturday Sunday
00:00-
01:00
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
02:00-
07:00
Other locations Other locations Other locations Other locations Other locations Other locations Other locations
08:00 DLS BIC BIC BIC BIC Other locations Other locations
09:00 DLS BIC BIC BIC BIC Other locations Other locations
10:00 BIC BIC BIC BIC BIC Other locations Other locations
11:00 BIC BIC BIC BIC BIC Other locations Other locations
12:00 BIC BIC BIC BIC BIC BIC Other locations
13:00 BIC BIC BIC BIC BIC BIC BIC
14:00 BIC BIC BIC BIC BIC BIC BIC
15:00 BIC BIC BIC BIC BIC BIC BIC
16:00 BIC BIC BIC BIC BIC BIC BIC
17:00 BIC BIC BIC BIC BIC BIC BIC
18:00-
20:00
BIC BIC BIC BIC BIC Other locations Other locations
21:00-
23:00
Other locations Other locations Other locations Other locations Other locations Other locations Other locations
23:00 Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use
Code updates scheduled,
Do not use


Interface selection

The Datastream database can be accessed via three different retrieval interfaces. All three programs access the main Datastream database, but all have different strengths and weaknesses. The following table outlines some of those strengths and weaknesses:

Interface Strengths Weaknesses
Advance
  • good for small requests, ie. max. 10 time-series or 1 or 2 graphs or reports
  • casual users (user-friendly)
  • cannot use for large downloads
  • more difficult to find background information on time-series
  • on-line help screens and procedures are cumbersome
DSDDE
  • good if you only want to download to Excel
  • better coverage information than Advance
  • cannot use for large downloads (max. 10 codes & 1 datatype, or 1 code & 10 datatypes, 3,650 datapoints)
  • little on-line help
  • must produce graphs in Excel
  • good if you know the program well
DSWindows
  • provides lots of background information on time-series
  • reports are more customizable
  • macros provide capability of automating repetitive tasks
  • more difficult to learn
  • little on-line help
  • consists of multiple programs


Useful macros

A number of macros are included with the Datastream installation. They are to be found, on the harddrive of a computer with the Datatream software installed, normally in the subdirectory: c:\dswindows\files\ and have extension .mac.

A macro to download a number of time-series, in comma-separated format, however, is not included in their default installation. Such a macro is download.mac.

In order to use this macro, download it to your workstation into the subdirectory c:\dswindows\files\, edit it as appropriate, adding Datastream time-series codes as required, and select in the DSWindows interface Macro/Run macro/download.mac to retrieve and download the specified series.


Documentation

The bulk of the Datastream documentation is in print format. A non-circulating copy of each of the following titles is available for consultation in the Data Library Service (5th Floor, Robarts Library) as well as in the Business Information Centre, Irving Rotman School of Management:

SeriesTitleDate
ResearchGetting started1998
Program summary1999
Datatypes [Note. Spanish language]1996
Time series analysis user guide. Issue 1. Oct. 1991
Global equity indices1998
Bond research user guide. Issue 1.June 1993
Data channel user guide. Issue 1.Jan. 1993
SoftwareDatastream Advance user guide. Version 2.0. Issue 2.1999
DDE server user guide. Issue 1.March 1997
Changes to DSDDE since version 2.2 update sheet 
DSWindows user guide. Issue 1.March 1997
DSWindows macros user guide. Issue 1.March 1997
DSGate 3.1user guide. Issue 1.Oct. 1997
 User created indices user guide1995
User created lists user guide1996
Economics user guide. Issue 1.Dec. 1993
Company accounts user guide. Issue 2.March 1999
Equity research user guide. Issue 1.Aug. 1991
Futures user guide. Issue 1.1994
Traded options user guide. Issue 1.Sept. 1992

In addition, some brief guides to using Datastream are available on the WWW at the following locations:


Installing the software

Installation instructions are available as a: flat ASCII text file, a RTF file, and as a MSWord document.

Installation software is available at: <http://prod.library.utoronto.ca:8090/datalib/datart/datalib/datastream/software/>.

Note that all software files should be downloaded in binary format. Note also that merely installing the software on your workstation will not provide access to the Datastream database. You will also need to have your IP address authorized by Datastream. To do so, contact Laine G.M. Ruus at the UT Data Library Service.


Additional information

Question: When and where can I get training on using Datastream.

Answer: training sessions will be organized in the fall of each year (September and/or October). Dates and locations will be announced here. Alternatively, contact Laine G.M. Ruus for information.

Question: the Datastream database doesn't respond.

Answer: ping Datastream at 159.104.6.51

Question: who can help me with Datastream?.

Answer:

Question: I need to contact the Datastream helpline Answer: Contact:


Html document by Laine G.M. Ruus, University of Toronto Data Library Service
Created: 05/08/99. Last updated: 2004/12/20