Home » Libraries » C.B. "Bud" Johnston Library

Datastream International

Datastream is a Thomson Product.

(In Library Use Only - Not Available Remotely)

Datastream can be searched on a designated PC in the Business Library.

The Business Library guide to Datastream using the classic view is provided here.


Business Library guides to Datastream using the Excel & Advance formats are here:

EXCEL 1 - simple search for an equity's price and volume
EXCEL 2 - using a constituent list to gather price and volume
EXCEL 3 - using Datastream Explorer to build a local list
EXCEL 4 - using Datastream Advance to gather static data for a list for a specific date
EXCEL 5 - using Datastream Advance to screen equities
EXCEL 6 - creating and using a Local List

Datastream provides daily pricing and volume information on over 37,000 equities from 57 countries, 12,000 market stock and bond indices, 87,000 macroeconomic series from the International Financial Statistics of the World Bank, OECD and other central statistical offices, over 2,000 daily foreign exchange rates, 1,000 daily and weekly interest rate series, 68,000 fixed income instruments from 23 countries and more than 260 financial and commodity futures and options contracts. More About Datastream (coverage dates, geographic coverage, data sources) For other helpful guides see: Princeton University, Univ. of California (Berkeley), Univ. of British Columbia, Univ. of Pennsylvania,Duke University













Accessing Data Datastream uses codes to identify the many instruments (i.e. companies, bonds, interest rates, etc.) and datatypes (i.e. opening price, dividened yield, etc.) used by its programs to produce reports or charts. Two methods of determining instrument codes and datatype codes are outlined below.  An instrument code used alone returns a default datatype code.  The following defaults apply:
        Equities = adjusted closing middle price
        Bonds = market price
        Industry Group = price index
        Exchange Rates = closing middle rate
        Any other series = series value Code Lookup   Method 1 Enter the bolded text (below) next to the "Program Number" on the main screen and press <enter>.  Follow the instructions on the screens until the required code appears.  Record the code for use later in Datastream programs. 

TO FIND ....                                   TYPE ....
EQUITIES                                     CODE 
INTEREST RATES                       HELP IR? 
INDICES                                       HELP SI? 
EXCHANGE RATES                     HELP ER?                
COMMODITIES                            HELP CO?                  
ECONOMICS                                150Z 
OPTIONS                                     click on CODE icon
ANY DATATYPE                          HELP DT?
  Method 2

With this method you can search for instrument and datatype codes and paste the code into fields in Datastream programs.
This method can be used from any point within Datastream programs. Click on the "Code" button in the top menu bar or hit F9. A window titled "Datastream Codes - Datatypes" will appear.  Click on the down arrow at the end of the bar window displaying "Datatypes".  Scroll through the list of datatypes that appear in the popup window and click on the datatype you wish to search.  A new popup window will appear.  If you have chosen equities as the datatype for example, the window will be titled "Datastream Codes - Equities". Use the Find box to search for the instrument you wish to research and highlight the appropriate line. If you wish to use the default datatype for the instrument you have selected, double click on the line and the code will be passed back to the original screen. If you wish to use a datatype other than the default for the instrument, type "control D".  A new popup window will appear.  Once again if you are working with equities the window will be titled "Datastream Codes -Equities(Datatypes)". Browse through the list of choices or use the Find box to locate the correct datatype.  Double click on the desired code and the combination of instrument and datatype codes will be passed back to the original screen. Running Datastream Running Datastream is a two step process.  On one screen you select the program you wish to run and on a second screen you specify the data you wish to use. Program selection is made on the main Datastream screen. The main screen  is divided into three basic sections: Type of Request (upper left window), Type of Data (upper right window), Programs Available (Bottom window).   Choose one criterion from each of the three windows. First choose the type of request (ex. reports, time series, or graphs), then the type of data (ex. equities, indices, exchange rates, or economics), and finally the programs available. When choosing an option from the "Programs Available" window, double click on the item. A search string (ex. 301D) will appear next to "Program Number" at the top of the screen, and then a data selection window will appear. Data selection windows vary for each Datastream program.  See the examples below in this guide. Downloading Finally, be sure to read the section on exporting from datastream. Essentially, dowloading data from this program takes the form of a data capture. That requires that you turn the capture on before initiating their search. Once the search is completed, and the user has scrolled through the results screens, the capture feature has to be turned off.

EQUITIES

.
NOTE: Generally the codes for companies include the company ticker symbols. For Canadian equities, precede the ticker symbol with C: to indicate the equity is listed on a Canadian exchange. (ex. C:AC or C:NT) For USA use U:. (ex. U:MMM or U:IBM) NOTE: The default datatype for equities is closing prices. (ie. If no datatype code is included in the search, closing prices will be retrieved.) Search Example:
  •  
      - At "Program Window" type CODE.

      - Type Air Canada. Press <enter>. - From the list retrieved, you'll notice the stock listed on the Canadian exchange has ticker AC. The search code is C:AC.

      - Press F2 to return to main screen.

      - Type HELP DT? at "Program Window".

      - Choose 3 - Equities, Investment Trusts from the list that appears and press <enter>. - Choose 1 - Equities Only and press <enter>. - Press <enter> to move through the screens until "Price: high" appears. The code is PH.

      - Press F2 to return ot main screen.

      - The main screen is divided into three windows: Type of Request, Type of Data, and Programs Available. To begin, choose the following search criteria by highlighting:

      Type of Request = Time Series Type of Data = Equities

      Programs Available = Up to 104 Values for any Series
      .

    • - Find the daily high prices for Air Canada stock between January 9, 1996 and the present.

    - First find the Search Code for Air Canada.

    - Next find the code for the datatype - opening prices.- Perform search.- The following window will appear. Enter the bolded text as shown below. Remember the "Series or expression" field may be filled in using Method 2 described in "Code Lookup" above.

    _____________________________________________________________________________________

This program displays up to 104 values for any series or expression. Enter ? where help required.
  •   
      						Series or expression (C) C:AC(PH)____________
		Display Frequency    (O) D        D,W,M,Q,Y or Blank
		Start Date           (O) 01-09-96 EG. MM-DD-YY or MM/YY or -3M, -30D, etc...
		End Date             (O) ________ (Note: when left blank, system will assume end
		
      						                                   date is equal to most current date.)
C = Compulsory, O = Optional ___________________________________________________________________
    - The search results will appear as follows. Use the <enter> key to retrieve the next page of data. Click on the printer icon to print results. See the section on Exporting for downloading procedures.

    _____________________________________________________________________________________ 

301V     AIR CANADA - PRICE HIGH                                    11-15-96
HIGH VALUE          5.60        4-22-96       LOW VALUE     4.60    3-18-96
WEEK         MONDAY      TUESDAY     WEDNESDAY      THURSDAY       FRIDAY

COMMENCING -------------------------- ----------------- --------------- ------------
1-8-96                     4.85        4.80         4.75            4.75

1-15-96       4.75         4.75        4.75         4.75            4.80

1-22-96       4.75         4.75        4.80         4.80            4.85

1-29-96       4.90         4.95        4.95         4.95            5.25

2-5-96        5.25         5.25        5.13         5.13            4.90

                               ......
INTEREST RATES

Finding Datastream Code/Mnemonic for Interest Rates:

    - Press F2 to return to main screen.

    - At "Program Number" type HELP IR? <enter> - Move through screens until you find the correct code.

    - Press F2 to return to the main screen.

Search Example:

- Graph the following interest rates over a two year period: Short term (1-3 year) Canadian Government Bonds, Mid term (3-5 years) Canadian Government Bonds, Long term (>10 years) Canadian Government Bonds.

  •  
      - Type of Request = Graphics

      - Type of Data = Interest Rates

      - Program = Line Chart of up to 3 Series

    • - First find the DataStream search codes by using the method outlined above (or later, use Method 2 described in "Code Lookup" above).

    - To initiate search choose the following options at the main screen.

    - The following window will appear. Enter the bolded text as shown.
_____________________________________________________________________________________

DATASTREAM 401A THIS PROGRAM PLOTS VALUES FOR UP TO THREE SECURITIES, SERIES OR EXPRESSIONS FROM A SPECIFIED DATE. ENTER ? WHERE HELP REQUIRED. ENTER ! FOR SECURITIES CODES. FOR OTHERCODES CLEAR AND USE HELP CDS? ENTER VALUES REQUIRED IF OTHER THAN DEFAULT VALUES SHOWN. 

    CODE OR EXPRESSION 1 CN13864__________________________________________
CODE OR EXPRESSION 2 CN13865__________________________________________
CODE OR EXPRESSION 3 CN13867__________________________________________
START DATE -2Y____
END DATE _______              Y  AXIS SCALE (LIN/LOG) LIN 
VALUES MAY BE PLOTTED 
1 AS ACTUAL VALUES            3 SECOND AND THIRD SERIES REBASED TO THE
2 ALL VALUES SHOWN IN INDEX      STARTING VALUE OF THE FIRST SERIES 
FORM STARTING AT 100        4 SECOND SERIES REBASED TO THE 
STARTING VALUE OF THE FIRST SERIES
ENTER 1, 2, 3, OR 4 1 
GRAPH TITLE _____________________________________
HLL DISPLAY _ 
___________________________________________________________________________________
INDICES

Finding Datastream Code/Mnemonic For Indices:

    - Press F2 to return to the main screen.

    - At "Program Number" type HELP SI? <enter> - Make note of the code/mnemonic required for your search.

    - Press F2 to return to the main screen.

Search Example:
  •  
      - Type of Request = Time Series

      - Type of Data = Indices

      - Programs Available = Up to 104 Values for any Series in a Calendar Format

    • - Produce a table of monthly values for the TSE300 Composite dating back to Jan. 1995.

    - Begin by finding the code/mnemonic for the TSE300 as outlined above (or later, use Method 2 described in "Code Lookup" above. - To initiate search, choose the following criteria from the main screen.

    - The following search screen will appear. Insert the bolded text as shown. _____________________________________________________________________________________
THIS PROGRAM DISPLAYS UP TO 104 VALUES FOR ANY SERIES OR EXPRESSION ENTER ? WHERE HELP REQUIRED. 
SERIES OR EXPRESSION (C) TTOCOMP_________________________________________
DISPLAY FREQUENCY    (O) M        D,W,M,Q,Y OR BLANK
START DATE           (O) 01/95__  EG. MM-DD-YY OR MM/YY OR -3M, -30D ETC...
END DATE             (O) ______
C=COMPULSORY, O=OPTIONAL

_____________________________________________________________________________________
- The search results screen appears as follows.
_____________________________________________________________________________________ 
301V  TORONTO SE (300) COMPOSITE - PRICE INDEX                     11-15-96
HIGH VALUE     5591.31     11-1-96      LOW VALUE     4019.10        2-1-95
FROM 1-1-95 TO 11-14-96
1995 JAN       4213.60    FEB    4019.10   MAR    4083.80   APR    4277.20 
MAY       4292.40    JUN    4445.60   JUL    4527.20   AUG    4586.90 
SEP       4525.90    OCT    4494.90   NOV    4453.00   DEC    4674.00
1996 JAN       4713.50    FEB    5011.10   MAR    4956.50   APR    4994.30 
MAY       5151.10    JUN    5234.29   JUL    5044.07   AUG    4952.97 
SEPT      5143.43    OCT    5329.55   NOV    5591.31 
_____________________________________________________________________________________
Exchange Rates

Finding Datastream Code/Mnemonic for Exchange Rates:

    - Press F2 to return to main screen.

    - At "Program Number" type HELP ER? <enter> - Make note of the appropriate code.

    - Press F2 to return to main search screen.

NOTE: Canada is not listed among the national exchange rate codes. There are two options available for locating Canadian exchange rates. One method entails an exchange rate search for lists of currencies, which include Canada. The following codes can be used: LERALL (currencies to UK), NYRUSC (US$ to currencies), and NYRCUS (currencies to US$). See the examples below for further clarification. The second method of locating Canadian exchange rates is to search through the ECONOMIC data. See the section on ECONOMICS.

Search Examples:

  •  
      - Type of Request = Reports

      - Type of Data = Exchange Rates

      - Programs Available = Values at Two Dates - high/low/avg. & % change for a list or series

    • - Find the value of the CDN$ as it is trading today.

    - Typically a search would start with the user looking for the Datastream code (as outlined above). However, it has already been explained that Canada in not listed among the search codes. Use one of the list of currencies mentioned above, NYRUSC. - Retrieve search window by choosing the following criteria at the main screen.

    - The following search screen appears. Enter the bolded text.
_____________________________________________________________________________________

THIS PROGRAM DISPLAYS VALUES AT TWO DATES FOR LIST OF SERIES/EXPRESSIONS ENTER ? WHERE HELP REQUIRED. 

LIST OF SERIES/EXPRESSIONS (C) NYRUSC_________________________________________
(SEPARATED BY COMMAS) _________________________________________________
EXPRESSION FOR STORED LIST (O) __________________________________________________
1ST DISPLAY DATE           (O) -3M_____       DATE FORMATS _______________

2ND DISPLAY DATE           (O) ________       MM-DD-YY OR MM/YY OR

                                              EG. -5D, -3M, -4Q, -5Y

C=COMPULSORY, O=OPTIONAL

_____________________________________________________________________________________
- Search results appear as follows:

_____________________________________________________________________________________ 

DATASTREAM 301D                                                    11-15-96

                      VALUE AT VALUE AT              ---RANGE OVER PERIOD---

                      8-14-96   11-14-96 CHANGE       HIGH     LOW     AVGE
....
US $ TO CANADIAN $-   0.72750    0.74840  2.87 %    0.75200  0.72740  0.73661
EXHANGE RATE                                        11-7-96  8-15-96
....
_____________________________________________________________________________________
Commodities

Finding Datastream Code/Mnemonic for Commodities:

    - Press F2 to return to main screen.

    - At "Program Number" type HELP CO? <enter>. - Make note of the appropriate search codes.

    - Press F2 to return to main screen.

Search Example:
  •  
      - Type of Request = Graphics

      - Type of Data = Commodities

      - Programs Available = Percentage Change

    • - Plot the percent change in natural gas prices over a 52 week period.

    - First find the Natural Gas search code using the method outlined above (or later, use Method 2 described in "Code Lookup" above). - Retrieve the search window by choosing the following criteria from the main screen.

    - The following search window will appear. Enter the bolded text as outlined below.
_____________________________________________________________________________________

DATASTREAM 401C THIS PROGRAM PLOTS PERCENTAGE CHANGES OF A SERIES OVER A SPECIFIED PERIOD. 

ENTER ? WHERE HELP REQUIRED. 
ENTER ! FOR SECURITIES CODES. FOR OTHER CODES CLEAR AND USE HELP CDS? ENTER VALUES REQUIRED IF OTHER THAN THE DEFAULT VALUES SHOWN.
CODE OR EXPRESSION NATLGAS_____________________________ 
START DATE -4Y_______
END DATE __________ 
Y AXIS SCALE (LIN/LOG) LIN 
PERIOD FOR % CHANGE 1Y__
_____________________________________________________________________________________
Economics

Finding Datastream Code/Menmonic for Economics:

    - Press F2 to return tomain screen.

    - At "Program Number" type 150Z <enter>. - Locate and record appropriate search codes.

    - Press F2 to return to main screen.

NOTE: For Canadian exchange rates ... which are difficult to locate when searching the Exchange Rates section, use the following codes: CN$EF (CDN$ effective exchange rate, monthly average) or USX$CN$ (average exchange rate - CDN$ to 1 US$). See the examples that follow for search techniques.

The next few pages contain four separate search examples highlighting some of the data available through Datastream's Economic search option. Search Example #1:

  •  
      - Type of Request = Reports

      - Type of Data = Economics

      - Program Number = Values over time for up to 12 Series

    • - Find the Canada/USA monthly average exchange rates since Jan. 1995.

    - First, find the Datastream Code using the procedures outlined above (or later, use Method 2 described in "Code Lookup" above). - To retrieve search window, enter the following at the main screen:

    - The following screen will appear. Enter the bolded text as outlined below. _____________________________________________________________________________________ 
DATASTREAM: 150C - ECONOMICS
This program displays a time series for a requested period.
Enter series required separated by comma. (MAXIMUM twelve series).
Enter ? where HELP required.
Series: USX$CN$________________________________________________________________
________________________________________________________________________
Display frequency (M or Q or A):  M
        Starting period (format XXYY):    0195 
Ending period (format XXYY):      ____ (optional)
_____________________________________________________________________________________
- Sample search results follow. _____________________________________________________________________________________ 
UNITED STATES 
SERIES:          CANADIAN $ TO  US $ 
UNITS: 
FREQUENCY:       MONTHLY 
DATA DISPLAYED:  MONTHLY
1995 JAN       1.414      1996 JAN      1.367 
FEB       1.400           FEB      1.376 
MAR       1.408           MAR      1.365
APR       1.377           APR      1.359 
MAY       1.361           MAY      1.369 
JUN       1.377           JUN      1.366 
JUL       1.362           JUL      1.369 
AUG       1.356           AUG      1.372 
SEP       1.351           SEP      1.369 
OCT       1.345           OCT      1.351 
NOV       1.353        
DEC       1.370
_____________________________________________________________________________________
Search example #2:
  •  
      - Type of request = Reports

      - Type of Data = Economics

      - Program Number = Economic Indicators by Country (no codes required)

    • - Retrieve a list of key economic indicators for Canada over the past six months, use the method outlined below. Notice that no Datastream code/nmemonic is required for this search.

    - At the main search screen, choose the following search options:

    - The following search window will appear. Enter the bolded text.
_____________________________________________________________________________________ 
DATASTREAM: 150F - ECONOMICS      COUNTRY / PRESENT DISPLAY SELECTION SCREEN,

Enter codes for one or more categories and one or more countries, separated by
commas.  Enter ? where help is required.

Enter category code(s) e.g. KEY,GDP

     KEY ________________________________________________________ 
KEY INDICATORS      (KEY) GDP/GNP        (GDP)  INDUSTRIAL ACTIVITY    (IND) 
INDUSTRIAL ORDERS   (ORD) RETAIL TRADE   (RET)  EMPLOYED/UNEMPLOYED    (EMP) 
EXTERNAL TRADE      (EXT) PRICES         (PRC)  WAGES/LABOUR COSTS     (WAG)
MONEY SUPPLY        (MON) CREDIT/DEBT    (CRD)  INTEREST/FX RATES      (INT) 
COMMENTARY          (COM) SURVEYS        (SUR)  LEADING INDICATORS     (LID)

Enter country code(s) below or on next page e.g. US,JP

     CN _________________________________________________________________

                   * * * For COUNTRY CODES see NEXT PAGE * * *

To get to next page, you must enter a category code on this page first and then hit return.
_____________________________________________________________________________________
- The above search for key economic indicators for Canada will produce at least five pages of data. Statistics included: unemployment rate, passenger car sales, GDP, retail sales, housing starts, manufacturing shipments and inventories, CPI, trade statistics, .....

Search example #3:

  •  
      - Type of Request = Reports

      - Type of Data = Economics

      - Program Number = Global Economic Indicator Comparisons (no codes required)

    • - Retrieve a table of various exchange rates against the US $.

    - At the main screen, enter the following criteria:

    - Notice that this search does not require an initial search for a Datastream code/nmemonic. The following search window will appear. Enter 23 to retrieve exchange rates against the US$.
_____________________________________________________________________________________ 
DATASTREAM: 150G - ECONOMICS          INTERNATIONAL INDICATOR DISPLAY
This program enables you to view one or more International Indicator
displays. Enter display number(s) required separated by comma. (MAXIMUM
fifteen displays). 
Enter ? where help required. 
23 _________________________________________________________________
1 Gross domestic product                                   15 Current account balances ( & in US$)
2 Industrial production                                        16 Government budget balances 
3 Unemployment(%)rates                                     17 Official reserves in US$ 
4 Consumer prices                                                18 Central bank discount rates 
5 Wholesale output prices                                    19 Short term ( 3 month ) interest rates
6 Export prices                                                      20 Long term Government bond yields 
7 Forecasts - OECD                                                21 JP MORGAN bond total return indices 
8 Forecasts - Consensus Economics                        22 Exchange rates agains the UK( 
9 Forecasts - Consensus Economics                        23 Exchange rates against the US$ 
10 D&B business survey-prices,employment            24 European Monetary System 
11D&B survey-profits,sales,inventories                    25 Effective exchange rates 
12 Consumer confidence indices                           26 Real effective exchange rates 
13 Leading indicators/Capacity utilisn.                  27 Money supply,narrow measure
14 Visible trade balances(& in US$ )                     28 Money supply,broad measure
____________________________________________________________________________________
    - The above search will retrieve the following results. When viewing the results on the screen, press the <enter> key to move to the next page of data.
____________________________________________________________________________________ 
      AVERAGE MONTHLY EXCHANGE RATES AGAINST THE DOLLAR
SOURCE: BANK OF ENGLAND
1996 
OCT    SEP    AUG    JUL    JUN    MAY    APL    MAR

 POUNDS STERLING       0.630  0.641  0.645  0.644  0.649  0.660  0.660  0.655 
% CHANGE YEAR AGO     -0.5   -0.1   +1.2   +2.7   +3.4   +4.7   +6.1   +4.8 
JAPANESE YEN          112.4  109.8  107.9  109.2  109.9  106.4  107.2  105.9
% CHANGE YEAR AGO     +11.5  +9.4  +14.0  +25.2  +28.9  +24.9  +27.9  +17.1 
.....
Search example #4:
  •  
      - Type of Request = Reports

      - Type of Data = Economics

      - Program Number = Latest values, background information and source for up to 12 series

    • - Find country risk information pertaining to Vietnam.

    - First find the datastream code/nmemonic as outlined above. When searching for the codes, look for FORECASTS - Economist Intelligence Unit ... There is a significant amount of country risk data available including population, GDP, exports, imports, service output, and industrial output. - At the main screen choose the following options to retrieve the search window:

- The following search window will appear. Enter the search codes as shown.

_____________________________________________________________________________________ DATASTREAM: 150A - ECONOMICS This program provides backgroung information for selected series. Enter series required separated by comma. (MAXIMUM twelve series). Enter ? where HELP required 

    			Series: VIGDPD, VIYPCA, VIPOPN, VIINDP ____________________________________
	______________________________________________________________________
_____________________________________________________________________________________
    - Each series will appear on a separate screen of search results. Press the <enter> key to move through the screens of results. Sample results follow.
_____________________________________________________________________________________ 
                 VIET NAM 
SERIES CODE:      VIGDPD.. 
TITLE:                   GDP (NOMINAL US$) 
SOURCE:               ECONOMICST INTELLIGENCE UNIT 
UNITS:                   U. S. $ BILLION 
FREQUENCY:         ANNUALLY 
STARTING DATE:  1985 
LATEST DATA:     1998
RECENT VALUES    1998    1997    1996    1995    1994    1993 
16073   23326   21767   19108   15620   12860
% CHG YEAR        11.8    7.2     13.9    22.3    21.5    30.3
_____________________________________________________________________________________

Futures

*****The Business Library does not have access to most FUTURES information on Datastream.*****

Options

Finding the Datastream Code/Mnemonic for Options:

    - Press F2 to return to main screen.

    - Click on CODE. - Click on the arrow to the right of the "Datatypes" window. - Select Options from the list that appears. - Enter search at Find prompt.

    - Make note of the CLASS code.

Note: To search an option, the following data may be required: the code, expiry date, exercise price, and either C (for call) or P (for put).

Search Example:

  •  
      - Type of Request = Reports

      - Type of Data = Options

      - Program Number = Prices and Volume

    • - Find the prices and volume traded of the option -- Japanese Yen.

    - Begin by finding the CLASS code as outlined above (or later, use Method 2 described in "Code Lookup" above). -To retrieve the search window, choose the following criteria at the main screen.

- The following search window will appear. Enter the bolded text as shown.

_____________________________________________________________________________________ DATASTREAM : 201A

    LATEST PRICES AND VOLUME

    ENTER ? WHERE HELP REQUIRED CLASSES REQUIRED PJY ___________________________________________

    CALLS PUTS OR BOTH __ C, P OR BLANK _____________________________________________________________________________________

- The results appear on the next page. Press <enter> to move through screens of data.

_____________________________________________________________________________________ 

201A                                      11 - 20- 96 TIME:14.39 
U.S.            JAPANESE YEN (PHLX)                       DATA DELAYED 15 MINS
CALLS        LATEST PRICE: U$89.97 
OPTION        CLOSE    LAST    MARKET    QUOTE    CUMULATIVE    MARGIN 
BID       OFFER     VOL TODAY   BUYER WRITER
DEC 80        1.615 
DEC 81        1.585 
DEC 82        0.060            0.030      0.090      0 
DEC 83        1.465 
DEC 84        5.800 
DEC 85        9.860 
DEC 86        3.880 
DEC 87        1.515 
DEC 87.5      2.430            2.370      2.490      0 
DEC 88        1.980            2.260      2.380      0 
DEC 88.5      1.575            1.530      1.620      0 
DEC 89        1.215            1.430      1.520      0 
DEC 89.5      0.895            1.080      1.170      0 
DEC 90        0.635            0.770      0.860      0 
DEC 90.5      0.445            0.530      0.620      0 
DEC 91        0.330            0.360      0.420      0  
DEC 91.5      0.220            0.260      0.320      0
_____________________________________________________________________________________

Exporting from Datastream

To print search results on Datastream click on the printer icon at the top of the screen. The system will print the data currently displayed on the screen. Press <enter> to retrieve more data and click on the printer icon to make a copy. Downloading from Datastream takes the form of a screen capture or dump. Users have to turn on the capture before initiating their search. Once the search results appear on the screen, press <enter> to scroll through the data. This prompts the system to capture all of the data to a file. Remember that any search on Datastream begins with a search for the Datastream Code/Mnemonic. Users can complete that part of their search before activating the capture function. There are two methods of downloading: Capturing Plain Text and Exporting for Spreadsheets. Both are outlined below. Please read through all of the instructions before attempting to export. Downloading Text:

    - First find the Datastream codes/nmenonics required to perform search.

    - Press F2 to return to main screen - Click on File. - Click on Capture to Plain Text... - Insert 3 1/2" disk in drive. - Enter a filename (ex. A:\test.txt). - Click on OK. - Perform search. - Press <enter> to scroll through screens of text. - Once through all the screens, click on File.

    - Click on Stop Capture to Save File.

Exporting for Spreadsheets:
    - First find the Datastream codes/nmemonics required to perform search.

    - Press F2 to return to main screen. - Insert a 3 1/2" disk in drive. - Click on File. - Click on Convert Data Channel/Fundline... - Choose CSV File type. - Enter a filename (ex. A:\test). - The main screen appears. - Choose Type of Report and Type of Data. In the Programs Available section, highlight the program of interest. Next, move cursor to the Program Number field at the top of the screen. Insert 900B in that field and press <enter>. The search screen will look different. Follow the instructions as they appear. - Press <enter> to scroll through screens of text. - Once through all the screens, click on File. - Click on Stop Convert Data Channel/Fundline. It is at this point that the data is transferred to the disk.

    (rev. JL99 JBP)