Short User Guide for Datastream 5.0 Datastream (DS) provides a
Contents
1. Short User Guide for Datastream 5 0 Datastream DS provides a user friendly interface figure 1 with series grouped into 13 data category types plus Local Lists allowing for easy access The Help option in the Menu bar is very useful The left hand side of the main window of DS gives options for the type of data e g equities unit trusts bonds etc the type of request e g single series multiple series chart report or data and data ranges and currency adjustments can be selected from the right hand side top corner The results are displayed in the main window at the bottom Figure 1 Datastream Interface hn Datastream E imi ed File Edt View Toos Help SoM 2 2 4 66 8 B G Contact Us Data Cate cherie E Find Seri aA From TY To 16 a 7 Piso ase O an On ogy Cay aay CM OM i Bac Equity indices Unt trusts Investment trusts 6 Currency Local Currency X Bonds k convercobles Bond ndices amp 5 ize i rt ee 3 e ssena necesn ean ee i amnia i ea aae m mme o aeee aee emaa am omiman e a m P aaar p c x tA hito exiranet datsstream comindes rtm 2U C C BL wepe F EA pe eg PW Dk Sk T er bga ichande rates i Oe f Add series Eo current chart g 2 i THOMSON REUTERS DAT AS ji R EA MI O Adi series to new chart Pors a r en Depla current chart fje tak eaae Oo cel e Library aoa 27 Apri anne Analysis PRODUCTS AND CATA Overview of Company Performan PESEE RSE intl Overvicw o2. astream options in the toolbar In the LS List Creation dialog type in the list description e g three indices and list name e g index llt and save it The list can then be used as a single request A list can also be created through Datastream directly In excel select Datastream Time Series Request From the Time Series Request Dialog select the List Picker button FE and look for the list you have created index llt Select the date range click on Submit and the list will show up in the spreadsheet This is very useful for updating a list of items
3. d in the Name field e After finding the series you can select the type of request and the time range e Select Run Now and the requested series will be displayed in the results window e To export the request to Excel select Transfer to Excel from the Tools menu or select Example Search Data for a company equity gt Ensure the data category is set to equities gt Click on DS Navigator and under the search criteria type in name contains box Tesco and select Search Now gt A number of tescos series will be displayed with a note of what data are available If looking for UK data i e Tesco on UK stock exchange use the one with the most years and earliest base date gt Inthis case TSCO Click TSCO gt This code DS mnemonic will be placed in the Name field You can then select the type of data and the time range and click a Figure 2 DS Navigator page Name ff Datastream Navigator COR Charting UCI UCTS Help Browse Extranet ContactUs Help Series Search Datastream Navigator i THOMSON REUTERS oo Data Category Equities Free Text Search Equities Explorer Advanced Search Name Contains zj tesco EA Search Now And Contains X ols sea DS Mnemonic Contains x k e Dfi Search Operator Ds Code Contai r aa ee E Datastream Navigator Market Equals a as a k Series Search Charting UCI UCTS Help Browse E
4. e Ernbed i Dieplsy How Thes Depa Ex piesa ion b Clesplay Douari Tikes Tsk Seties eae Name TESCO F Depey Headings i Demiin M Vinble fulton DS Mnemonic TSC Beee an i DS Code sorata r r aa Tr Market United emodem P Mal ti E beans Base Tale Ben 30 See Dipl Cunene ny Currency United Kingdom Pound HERMITE D Depa Latest Value First IBES Yas E Hyoetlnb be ketadi KEREI m Ws TRE Primary Deote Yas Datatypes F 125 Ply l2e4 Di lees PE 125d Rl Major Securihy Tez He Dalii O Cantal an 3 at g Adjusted Prices Yoe Shahus Arhvs Instrument Type Equity i Exchange Leriar a B Sector Food amp Crug Retadere 1 Aolierah i VODAFONE SARACLATS ae SEDOL ia beta i Code natty ee A fay ISIN SEDOSE4 7096 22 ae ee cet SSE Local Cone LEITECO 3 03 04 2007 136 2 Tszi 4515 TRES Thckor HOTSE g 407 137 1 76s 04 53 Expanded Hame Tasto Es 05 04 2007 136 7 Tiza 45e l wisa rane Sel ue ie facet HET Tog Teia T Creating a list of items using DS Advance for Office Excel Add In Lists are a good way to make requests for a group of series that you use frequently Instead of making individual requests you can make one request to get results of all the series you are interested in To create a list after having identified the series and their DS codes In Excel type in the DS mnemonic of a set of series e g FTSE100 S amp PCOMP NASCOMP in consecutive rows or columns Select the names and click on E3 Create List from Range from the Dat
5. es No Yes Yes P 1197 MV DY PI RI 1197 PH 1197 more Equity E Bikage Tradd TESCO SPN ADR 1 3 klj g nited Kingdo Jan 23 1995 United States Dollar es o Yes es P 0195 MV DY PE PI RI 0195 more TESCOM a f 2 srae Feb 24 2004 Israeli Sheqel es io es Yes P 0204 MV DY PI RI 0204 UP more Instrument Type M all I Genussschein Profit Participation Certificate I Global Depositary I Investment Trust Preference Share 2 Items 1 12 of 12 I United States Warrant Exchange Sector oss A v gt Downloading Data using DS Advance for Office Excel Add In Figure 3 e Open an Excel file and click on Datastream AFO option on the toolbar e Select a Request Type usually Time Series Request A Time Series Request allows you to specify a time period over which you can view individual series or a list of items Type in the code of the series if known or click on the Find Series button to be taken to the DS Navigator as before e After selecting your series and the time range click on Submit and the data will be downloaded on the spreadsheet Figure 3 Time Series Request AFO Excel ie Kopet ladak Senesftists gt OD BARC T SCO er C Cisplap Data ds hehe C5 1S ate el VS bar eech ilinin bet OTT Cocke mam fE if AL Stat aa a Fagan Ds f TESICD internet Explorer Erd Vale E aia f vines ir a Ophiors eo Peto oroduct detestream com navigstorEronamic i f
6. f any Series AONANCE E NBJE S Daastisan Deta Loaver Welcome to the Research Extranet ne ea ee pages La INE eta Corl Online support for Datastream content and desktops with prorat AE ocho Content Factsheet ancive rai i of i rT SESSA eh to the extensive range of Thomson Reuters financial produ amp in is baat Equity richces PRE IRE S Cenaeneis Product amp Content News Codes and Informacion Favourkes JANES Goce Aqgrecates Thomson Reuters Proprietary Research incisive Timely Releve Equity Screening WORSC ORE With Thomeon Reuters Proprietary Recestth we ap lores wide range of investing Ml i BES pitter Bar Single Series CVETNE Egutiss Making a Request e Select the series you are interested in from the Data Category window e If you know the Datastream mnemonic or code of the series check the Expert entry box and just type in the name in the Enter Series field on the main top window Otherwise you can enter part of the name of the series and then click on the Find Series button For basic search e Use the Datastream Navigator to find and select the series Click on and use the set criteria page of the DS Navigator for the most basic search see figure 2 You can choose as many of the criteria offered and also add second criteria to narrow down your search When done click on the Search Now button e From the results displayed find and select the series you want The name of the series will be displaye
7. xtranet ContactUs Help a Datastream Navigator iS THOMSON REUTERS ddimm Before x ede see oe cla oo Data Category Equities A Free Text Search Equities Explorer Currency uji Results for Advanced Search Name contains tesco Ml Back To Search Criteria Primary Quote V All a Yes g No Name S Mnemonic S Code arke Currenc y 5 S rimar uote Datatypes EVER GOTESCO RES amp HDG l 23 ilippines Sep 16 1996 Philippine Peso Yes o Yi es P MV DY PE PI RI more p x NABTESCO b 3 326 apan Jan 1 1973 Japanese Yen Yes fes Yes Yes P MV DY PE PI RI more Major Security Mal T Yves T No sien NABTESCO FRA 3 3 5 apan Aug 24 2007 Euro o o Yes o P 0807 MV DY PE PI RI 0807 more TESCO DIE United States Dec 3 1996 United States Dollar es es es es P 1296 MV DY PE PI RI 1296 more Adjusted Prices M al l yes l No TESCO e nited Kingdom Dec 30 1964 United Kingdom Pound Yes Yes Y es P 1264 MV DY PE PI RI 1264 more TESCO BER bl 3 nite ates Feb 2 2004 Euro No No Yes No P 0204 MV DY PE PI RI 0204 more TESCO DUB lk nited Kingdo Jun 14 1999 Euro o o Yes o P 0699 MV DY PE PI RI 0699 more all M Active Dead Suspended TESCO FRA B oTe United Kingdom Aug 61998 Euro o io es lo P 0898 MV DY PE PI RI 0898 more TESCO OTC DIE nited Kingdo Dec 13 2000 United States Dollar o o Y o P 1200 MV DY PE PI RI 1200 more l american Depositary Receipt l Closed End Fund TESCO KIPA KITLE bil i urkey Nov 25 1997 Turkish Lira Y
Download Pdf Manuals
Related Search