130 likes | 153 Views
LIB310 USING DATASTREAM. Lingnan University Library Feb 2013 TERENCE CHEUNG – REFERENCE LIBRARIAN. http://www.library.ln.edu.hk/services/library-workshops/handouts. AFTER THE WORKSHOP, YOU SHOULD BE ABLE TO KNOW:. What kind of information is available in Datastream.
E N D
LIB310 USING DATASTREAM Lingnan University Library Feb 2013 TERENCE CHEUNG – REFERENCE LIBRARIAN http://www.library.ln.edu.hk/services/library-workshops/handouts
AFTER THE WORKSHOP, YOU SHOULD BE ABLE TO KNOW: • What kind of information is available in Datastream. • How to retrieve relevant information from Datastream. • How to retrieve data from Datastream in Excel.
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
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