140 likes | 279 Views
LIB310 USING DATASTREAM. Lingnan University Library Feb 2014 TERENCE CHEUNG – REFERENCE LIBRARIAN. http://www.library.ln.edu.hk/services/library-workshops/handouts. By the end of this workshop, you will be able to :
E N D
LIB310 USING DATASTREAM Lingnan University Library Feb 2014 TERENCE CHEUNG – REFERENCE LIBRARIAN http://www.library.ln.edu.hk/services/library-workshops/handouts
By the end of this workshop, you will be able to: • have an overview on different types of information available in Datastream in order to know the strengths and weaknesses of Datastream. • apply different search strategies in using Datastreamin order to extract relevant information efficiently and effectively. • use Excel to extract information from Datastream in order to make better use of the data for further analysis and build complex models and reports.
What is Datastream? • Historical financial database • Create customised reports and charts • Dynamic downloads into MS Office Applications (AFO) • Wide content coverage
NAVIGATION– 5 STEPS • Select a data category • Search for and select series using the Datastream Navigator • Select the type of request • Set the time period and/or frequencies • Click on Run Now to execute your request. 4 2 1 5 3
Task One Get Overview of Company Performance of Cheung Kong Holdings
Task Two Get Key Account Ratio Report and Simple Charts of HSBC
Task Three Retrieve Historical Stock Prices of Cheung Kong Holdings
Task Four Download Financial Data of all HK clothing companies with Market Value Over 2 Billions HKD
Task Five Download the Unemployment Rate of HK
DS AFO – EXCEL ADD-IN • An Excel Add-In component which allows users to build complex models and reports • Static data for a specific date e.g. price, market capital value, PE for HSBC at 3 Oct 2012) • Time series data for a particular time period e.g. daily price for Cheung Kong from 01/01/1974 to 01/01/2012
Task Six Download Statistics using Excel DS-AFO: Looking for Imports & Exports of Goods/Services for Singapore
Guide to Datastream http://www.library.ln.edu.hk/sites/default/files/content/libguides/datastream_userguide.pdf
NEED HELP? • Ask A Librarian • http://www.library.ln.edu.hk/research/ask-librarian • Integrated Helpdesk • refstaff@ln.edu.hk • 2616-8571 • Chat Reference Service • 2pm-5pm, Mon-Fri