120 likes | 240 Views
LIB310 Using Datastream. Lingnan University Library Feb 2012. 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
E N D
LIB310 Using Datastream Lingnan University Library Feb 2012
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 2011) • Time series data for a particular time period e.g. daily price for Cheung Kong from 01/01/1974 to 01/01/2011 • Company reports
Task Six Download Statistics using Excel DS-AFO: Looking for Imports & Exports of Goods/Services for Singapore
Getting Help • Integrated Helpdesk at Information Commons (1/F, Library) • Tel: 2616 8571 • Ask A Librarian (Electronic Reference) http://www.library.ln.edu.hk/help/eref/ • Contact Us http://www.library.ln.edu.hk/aboutus/contactus.html • FAQ http://www.library.ln.edu.hk/help/wiki/index.php/Frequently_Asked_Questions_About_the_Library