bloomberg 数据库(教学课件）

1、Introductory Bloomberg Training Created by: Jory J. McCuskey Edited by: Billy PratherTutorial Outline Keyboard and Navigation Getting Started Equity Functions Debt Functions Option Functions News Functions Conclusion Data ExportThe Keyboard: Overview Command Structure Identifier (Ticker Symbol) Mark

2、et Sector (Yellow keys) ex. F8 or Equity Function (Bloomberg listed code) ex. FA for Financial Analysis Example: DELL equity FA Navigation: MENU Returns you to previous page PAGE BACK/ PAGE UP Scrolls through multipage documents HELP Keyword searchThe Keyboard: Continued Rules of thumb: Green = Go R

3、ed = Stop Yellow = Information All yellow boxes are adjustable inputsThe Keyboard: ContinuedLog Into Bloomberg TerminalStep 1: Press CONN DFLT button on top right side of keyboardStep 2: Log in using credentials printed on keyboard or monitorStep 1: Press the EQUITY F8 key then press GO (enter)The E

4、quities PageNote: This page is your main resource for all equity related functionsFunctions Covered: TK, QSRC, MASearch Functions: EquitiesEquity Search Functions: TKWhere am I? TK Overview: Quickly search for equities by partial issuer nameEquity Search Functions: TKTickerCountry CodeCompany NameEq

5、uity Search Functions: TKNow Try This!Using the TK Equity Search Function Instructions: Think of a U.S. company whos ticker you dont know and use the TK function to find its Equity pageQSRC: Equity SearchSelect the search you wish to RUN or EDITChoose from the available optionsQSRC: Equity SearchEdi

6、ting Search CriteriaCustomized Equity Search Functions: QSRCOverviewGenerates a list of equity securities based on a set of criteria you select such as:Country, state, exchange, security type, index, industry group and a variety of numerical values such as Gross profit marginQuickly screen for oppor

7、tunities based on fundamental and technical dataTo access type: QSRC Where am I? QSRC Customized Equity Search Functions: QSRCInteractive ExampleWhere am I? QSRC Overview:Create a search that finds all U.S. Investment banks larger than $500MlnCustomized Equity Search Functions: QSRCInteractive Examp

8、leWhere am I? QSRC Give the search a name (ex: BIGGEST INV-BANKS) (press to save)Select a search fieldCustomized Equity Search Functions: QSRCFeaturesWhere am I? QSRC Type “Market Cap” in the Search All Fields box and press Select option 21) Currency Adj MktCap Last CloseSet the minimum for Currency

9、 Adj MktCap to $500MlnSelect option 19) Industry GroupsCustomized Equity Search Functions: QSRCFeaturesWhere am I? QSRC Select 8) FinancialSelect 25) Diversified Finan ServSelect 28) Investment Bnkr/BrkrPress twice (note: 1 Industry Group has been selected)Customized Equity Search Functions: QSRCInt

10、eractive ExampleWhere am I? QSRC Click Edit, Search DisplayClick Select display field, type Market Cap, select Currency Adj MktCapType 4 in the orange box next to Currency Adj MktCapSet 1st Sort Column to 4, and 2 for Descending Order, then 1 to view resultsCustomized Equity Search Functions: QSRCIn

11、teractive ExampleWhere am I? QSRC Press / to scroll through resultsClick on a company to view description, price graph, corporate action or news pagesEquity Search Functions: MAWhere am I? MA OverviewProvides coverage on global merger and acquisition activityUse standardized deal search or create a

12、customized searchView M&A legal and financial league tables as well as comprehensive global M&A statisticsTo access type: MA Equity Search Functions: MA 1) M&A Search Where am I? MA , 1 OverviewQuick Company Search allows you to search by company name or tickerStandard Categories allow you to view r

13、esults from predefined searchesCustom Search provides customizable search categories so you can define specific criteria for displaying transactionsEquity Search Functions: MAInteractive Example: M&A Custom SearchWhere am I? MA , 1 Equity Search Functions: MA7) M&A League TablesWhere am I? MA , 7 Eq

14、uity Search Functions: MA8) M&A StatisticsWhere am I? MA , 1 Now Try This!Using the M&A Search Functions Instructions: Create an M&A Custom search for all U.S. M&A deals: In 2003 In the Real Estate Industry By Goldman Sachs Using the M&A League Tables function, compare market share for Real Estate r

15、elated transactions North America among both financial and legal advisors Using the M&A Statistics function, find the average premium paid for Real Estate related M&A transactions in March 04. How does this premium compare with the average premium paid across the world?Search Functions: UNDWCustom U

16、nderwriter Rankings: ex: IPOsWhere am I? UNDW Search Functions: LEAGWhere am I? LEAG Now Try This!Using the LEAG or UNDW Search Functions Instructions: See who leads the League Tables for U.S. High-yield Debt Create a custom search for all IPOs in the US Who leads the league tables for Canadian Gove

17、rnment Debt?Equity Markets Functions Functions to be covered: WEI: World Equity Markets view LVI: Largest Volume Increases WPE: World PE WEIS: World Equity Ranked Returns NN: Equity News Search Category EMI: Equity Market Indicators IMOV: Index Movers MOST: Most Active EMTK: Equity Market Ticker CSD

18、R: Sovereign Debt RatingsWhere am I? QSRC Equity Markets FunctionsWEI: World Equity Markets ViewWhere am I? WEI Equity Markets FunctionsLVI: Largest Volume IncreasesWhere am I? LVI Equity Markets FunctionsLVI: Largest Volume IncreasesWhere am I? LVI Equity Markets FunctionsWPE: World PEWhere am I? W

19、PE Equity Markets Functions WEIS: World Equity Ranked ReturnsWhere am I? WEIS Equity Markets Functions WEIS: World Equity Ranked ReturnsWhere am I? WEIS Equity Markets Functions WEIS: World Equity Ranked ReturnsWhere am I? WEIS Equity Markets Functions WEIS: World Equity Ranked ReturnsWhere am I? WE

20、IS Equity Markets Functions NN: Equity News Search CategoryWhere am I? NN Equity Markets Functions NN: Equity News Search CategoryWhere am I? NN 36 Equity Markets Functions EMI: Equity Market IndicatorsWhere am I? EMI Equity Markets Functions EMI: Equity Market IndicatorsWhere am I? EMI 31 Equity Ma

21、rkets Functions EMI: Equity Market IndicatorsWhere am I? EMI 31 Equity Markets Functions EMI: Equity Market IndicatorsWhere am I? EMI 31 Equity Markets FunctionsIMOVWhere am I? QSRC Equity Markets FunctionsMOSTWhere am I? QSRC Equity Markets Functions EMTK: Equity Market TickerWhere am I? EMTK Equit

22、y Markets Functions EMTK: Equity Market TickerWhere am I? EMTK 11 Equity Markets Functions EMTK: Equity Market TickerWhere am I? EMTK 11 11 CSDR: Sovereign Debt RatingsWhere am I? CSDR CSDR: Sovereign Debt RatingsWhere am I? CSDR 1 Multiple Security Analytics Functions Useful functions to explore: H

23、MS: 4-in-1 Price Graph MRA: Multiple Regression Analysis CORR: Correlation MatrixPrice Graphing Functions Useful functions to explore: HP: Historical Price Table GIP: Intraday Price Graph GPO: Price & Volume Graph w/ Moving Avg.Financial Analysis Functions Functions covered: FA: Financial Analysis D

24、VD: Dividend Summary (not shown) CF: Company Filings (not shown)Financial Analysis FunctionsWhere am I? 9Financial Analysis FunctionsWhere am I? FAFinancial Analysis FunctionsWhere am I? FA 9 Valuation, Risk & Return Functions Functions covered: RV: Relative Value DDM: Dividend Discount Model WACC:

25、Weighted Average Cost of Capital BETA: Beta Calculations COMP: Comparative Return Analysis EQRP: Equity Risk Premium (CAPM) CRP: Country Risk PremiumValuation, Risk & Return FunctionsRV: Relative ValueWhere am I? RV Valuation, Risk & Return FunctionsDDM: Dividend Discount ModelWhere am I? DDM Valuat

26、ion, Risk & Return FunctionsWACC: Weighted Average Cost of CapitalWhere am I? WACC Valuation, Risk & Return FunctionsBETA: Beta CalculationWhere am I? BETA You can change several inputs Date Range Frequency Make sure you have enough data points Otherwise your Beta will be inaccurate Most professors

27、use Adjusted BetaValuation, Risk & Return FunctionsBETA: NotesValuation, Risk & Return FunctionsCOMP: Comparative ReturnsWhere am I? COMP Valuation, Risk & Return FunctionsEQRP: Equity Risk Premium (CAPM) Inputs Expected Market Return Risk Free Rate Rate on current 10-yr Treasury Bonds Applied Beta

28、Country Premium (CRP) Market Premium Market return Risk free rateValuation, Risk & Return FunctionsEQRP: Equity Risk Premium (CAPM) NotesValuation, Risk & Return FunctionsCRP: Country Risk Premium (Market Premium)Earnings Functions Functions Functions covered: EE: Earnings Estimates EEG: Earnings Es

29、timate Graph ERN: Earnings Summary (not shown)Earnings Functions FunctionsEE: Earnings EstimatesWhere am I? EE Inputs Type of Estimate Revenue etc. Currency Time Period Usually the larger the company the more types of estimates our availableEarnings Functions FunctionsEE: Earnings Estimates NotesEar

30、nings Functions FunctionsEEG: Earnings Estimate GraphWhere am I? EEG Other Functions Functions covered: AIRS: Airline Statistics HDS: Holdings Search CACS: Corporate Action Calender CACT: Corporate Action Global ACDR: Earnings Announcement Calender RELS: Related SecuritiesOther FunctionsAIRS: Airlin

31、e Statistics Displays air travel statistics by the U.S. Department of Transportation Information Statistics include: On Time Arrivals, Mishandled Baggage Consumer Complaints,and Passenger Traffic Value is the number per 100,000 passengers Sort or view a graph of each statistic over timeWhere am I? A

32、IRS Other FunctionsAIRS: Airline StatisticsWhere am I? AIRS Other FunctionsHDS: Holdings SearchWhere am I? CMCSK HDS Other FunctionsCACS: Corporate Action CalendarOverview Displays a list of corporate actions taken by a company over a date range Customize the date type (effective, announcement), act

33、ion type (acquisition, dividend, shareholder meeting) and date rangeWhere am I? CACS Other FunctionsCACT: Corporate Action GlobalOther FunctionsCACT: Corporate Action Global Inputs Date Range Corporate Action Type 4 pages of action types Company Name CountryOther FunctionsCACT: Corporate Action Glob

34、alOther FunctionsACDR: Earnings Announcement Calendar Overview ACDR displays earnings estimates and announcement dates for companies in a specified country or region Use to compare actual with estimated earningsWhere am I? ACDR Other FunctionsRELS: Related Securities Overview RELS allows you to quic

35、kly find all equity and debt securities issued by a company as well as brands, subsidiaries, people, news, major physical assets such as power plants or pipelinesWhere am I? RELS Debt FunctionsGovernment Securities (F2)Debt FunctionsGovernment Securities: Lookup (TK)Debt FunctionsLookup: TK (continu

36、ed)Debt FunctionsLookup: TK (continued)Debt FunctionsLookup: TK (continued)Debt FunctionsYield Curve Spread: FMCSDebt FunctionsYield Curve Spread: FMCS (continued)Debt FunctionsYield Curve Spread: FMCS (continued)Debt FunctionsYield Curve Spread: FMCS (continued)Debt FunctionsCorporate Bonds (F3)Deb

37、t FunctionsCorporate Bonds: Lookup TKDebt FunctionsCorporate Bonds: Lookup TK (continued)Debt FunctionsCorporate Bonds: Lookup TK (continued)Debt FunctionsCorporate Bonds: Lookup TK (continued)Option FunctionsIntroduction Option Functions are under Equity (F8) Market Sector OMON: Option Monitor CALL

38、: List of Calls PUT: List of Puts Other functions (not shown) GP: Price Graph HP: Historical Price DES: DescriptionOption FunctionsOMON: Option Monitor Click and hold to see menu for a specific optionOption FunctionsCALL: List of CallsOption FunctionsPUTS: List of PutsNews Functions Functions covered: N Main News MenuNews FunctionsWhere am I? N News Functions: T