文档详情

bloomberg数据库教学课件

ni****g
实名认证
店铺
PPT
2.62MB
约106页
文档ID:586512007
bloomberg数据库教学课件_第1页
1/106

Introductory Bloomberg Training•Created by:•Jory J. McCuskey•jjmccuskey@•Edited by:•Billy Prather Tutorial Outline•Keyboard and Navigation–Getting Started•Equity Functions•Debt Functions•Option Functions•News Functions•Conclusion–Data Export •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–Red = Stop–Yellow = Information–All yellow boxes are adjustable inputsThe Keyboard: Continued Log Into Bloomberg TerminalStep 1: Press CONN DFLT button on top right side of keyboardStep 2: Log in using credentials printed on keyboard or monitor Equity Search Functions: TKWhere am I? TK •Overview:–Quickly search for equities by partial issuer name Equity Search Functions: TKTickerCountry CodeCompany Name Equity Search Functions: TK Now Try This!Using the TK Equity Search Function•Instructions:–Think of a U.S. company who’s ticker you don’t know and use the TK function to find its Equity page QSRC: Equity Search1.Select the search you wish to RUN or EDIT2.Choose from the available options QSRC: Equity SearchEditing Search Criteria Customized Equity Search Functions: QSRC•Overview–Generates 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 margin–Quickly screen for opportunities based on fundamental and technical data–To 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 $500Mln Customized Equity Search Functions: QSRCInteractive ExampleWhere am I? QSRC 1)Give the search a name (ex: BIGGEST INV-BANKS) (press to save)2)Select a search field Customized Equity Search Functions: QSRCFeaturesWhere am I? QSRC 1)Type “Market Cap” in the ‘Search All Fields’ box and press 2)Select option 21) Currency Adj MktCap Last Close3)Set the minimum for Currency Adj MktCap to $500Mln4)Select option 19) Industry Groups Customized Equity Search Functions: QSRCFeaturesWhere am I? QSRC 1)Select 8) Financial2)Select 25) Diversified Finan Serv3)Select 28) Investment Bnkr/Brkr4)Press

twice (note: 1 Industry Group has been selected) Customized Equity Search Functions: QSRCInteractive ExampleWhere am I? QSRC 1)Click Edit, Search Display2)Click ‘Select display field’, type Market Cap, select Currency Adj MktCap3)Type 4 in the orange box next to Currency Adj MktCap4)Set 1st Sort Column to 4, and 2 for Descending Order, then 1 to view results Customized Equity Search Functions: QSRCInteractive ExampleWhere am I? QSRC 1)Press / to scroll through results2)Click on a company to view description, price graph, corporate action or news pages Equity Search Functions: MAWhere am I? MA •Overview–Provides coverage on global merger and acquisition activity–Use standardized deal search or create a customized search–View M&A legal and financial league tables as well as comprehensive global M&A statistics–To access type: MA Equity Search Functions: MA 1) M&A Search Where am I? MA , 1 •Overview–Quick Company Search allows you to search by company name or ticker–Standard Categories allow you to view results from predefined searches–Custom Search provides customizable search categories so you can define specific criteria for displaying transactions Equity Search Functions: MAInteractive Example: M&A Custom SearchWhere am I? MA , 1 Equity Search Functions: MA7) M&A League TablesWhere am I? MA , 7 Equity 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 related 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 Underwriter 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 Government 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–CSDR: 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? WPE 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? WEIS 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 Markets 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 Equity 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:–HMS: 4-in-1 Price Graph–MRA: Multiple Regression Analysis–CORR: Correlation Matrix Price 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–DVD: Dividend Summary (not shown)–CF: Company Filings (not shown) Financial Analysis FunctionsWhere am I? 9 Financial Analysis FunctionsWhere am I? FA Financial Analysis FunctionsWhere am I? FA 9 Valuation, Risk & Return Functions•Functions covered:–RV: Relative Value–DDM: Dividend Discount Model–WACC: Weighted Average Cost of Capital–BETA: Beta Calculations–COMP: Comparative Return Analysis–EQRP: Equity Risk Premium (CAPM)–CRP: Country Risk Premium Valuation, Risk & Return FunctionsRV: Relative ValueWhere am I? RV Valuation, Risk & Return FunctionsDDM: Dividend Discount ModelWhere am I? DDM Valuation, 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 use Adjusted BetaValuation, Risk & Return FunctionsBETA: Notes Valuation, 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•Country Premium (CRP)–Market Premium•Market return – Risk free rateValuation, Risk & Return FunctionsEQRP: Equity Risk Premium (CAPM) Notes Valuation, Risk & Return FunctionsCRP: Country Risk Premium (Market Premium) Earnings Functions Functions•Functions covered:–EE: Earnings Estimates–EEG: Earnings Estimate 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 Notes Earnings 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 Securities Other FunctionsAIRS: Airline 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? AIRS Other FunctionsAIRS: Airline StatisticsWhere am I? AIRS Other FunctionsHDS: Holdings SearchWhere am I? CMCSK HDS Other FunctionsCACS: Corporate Action Calendar•Overview–Displays a list of corporate actions taken by a company over a date range–Customize the date type (effective, announcement), action type (acquisition, dividend, shareholder meeting) and date rangeWhere am I? CACS Other FunctionsCACT: Corporate Action Global Other FunctionsCACT: Corporate Action Global •Inputs–Date Range–Corporate Action Type•4 pages of action types–Company Name–CountryOther FunctionsCACT: Corporate Action Global Other 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 quickly 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 (continued) Debt FunctionsLookup: TK (continued) Debt FunctionsLookup: TK (continued) Debt FunctionsYield Curve Spread: FMCS Debt FunctionsYield Curve Spread: FMCS (continued) Debt FunctionsYield Curve Spread: FMCS (continued) Debt FunctionsYield Curve Spread: FMCS (continued) Debt FunctionsCorporate Bonds (F3) Debt FunctionsCorporate Bonds: Lookup TK Debt 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: List of Calls–PUT: List of Puts–Other functions (not shown)•GP: Price Graph•HP: Historical Price•DES: Description Option FunctionsOMON: Option Monitor Click and hold to see menu for a specific option Option FunctionsCALL: List of Calls Option FunctionsPUTS: List of Puts News Functions•Functions covered:–N Main News Menu News FunctionsWhere am I? N News Functions: TNIWhere am I? TNI News Functions: TNIWhere am I? TNI Economic Functions•Functions (Not Shown):–ECST: Economic Statistics–IBQ: Industry Overview–CBQ: Country Overview The Help Function-As a search function- -For instructions and Definitions- Data Export• –Print Screen (Action Menu)–Send Screen (Action Menu)•Screen capture sent to your email•Excel Download–You can cut and paste non-menu pages•The data will need to be reformatted•use Ctrl-C (Cut) and Ctrl-V (paste)–There is no direct Excel Download Questions? 。

下载提示
相似文档
正为您匹配相似的精品文档