bloomberg 数据库教学课件.ppt
《bloomberg 数据库教学课件.ppt》由会员分享,可在线阅读,更多相关《bloomberg 数据库教学课件.ppt(106页珍藏版)》请在三一文库上搜索。
1、Introductory Bloomberg Training,Created by: Jory J. McCuskey 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 Scrol
2、ls through multipage documents HELP Keyword search,The Keyboard: Continued,Rules of thumb: Green = Go Red = Stop Yellow = Information All yellow boxes are adjustable inputs,The Keyboard: Continued,Log Into Bloomberg Terminal,Step 1: Press CONN DFLT button on top right side of keyboard,Step 2: Log in
3、 using credentials printed on keyboard or monitor,Equity Search Functions: TK,Where am I? TK ,Overview: Quickly search for equities by partial issuer name,Equity Search Functions: TK,Ticker,Country Code,Company Name,Equity Search Functions: TK,Now Try This!Using the TK Equity Search Function,Instruc
4、tions: Think of a U.S. company whos ticker you dont know and use the TK function to find its Equity page,QSRC: Equity Search,Select the search you wish to RUN or EDIT,Choose from the available options,QSRC: Equity SearchEditing Search Criteria,Customized Equity Search Functions: QSRC,Overview Genera
5、tes 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 ,W
6、here am I? QSRC ,Customized Equity Search Functions: QSRCInteractive Example,Where am I? QSRC ,Overview: Create a search that finds all U.S. Investment banks larger than $500Mln,Customized Equity Search Functions: QSRCInteractive Example,Where am I? QSRC ,Give the search a name (ex: BIGGEST INV-BANK
7、S) (press to save) Select a search field,Customized Equity Search Functions: QSRCFeatures,Where am I? QSRC ,Type “Market Cap” in the Search All Fields box and press Select option 21) Currency Adj MktCap Last Close Set the minimum for Currency Adj MktCap to $500Mln Select option 19) Industry Groups,C
8、ustomized Equity Search Functions: QSRCFeatures,Where am I? QSRC ,Select 8) Financial Select 25) Diversified Finan Serv Select 28) Investment Bnkr/Brkr Press twice (note: 1 Industry Group has been selected),Customized Equity Search Functions: QSRCInteractive Example,Where am I? QSRC ,Click Edit, Sea
9、rch Display Click Select display field, type Market Cap, select Currency Adj MktCap Type 4 in the orange box next to Currency Adj MktCap Set 1st Sort Column to 4, and 2 for Descending Order, then 1 to view results,Customized Equity Search Functions: QSRCInteractive Example,Where am I? QSRC ,Press /
10、to scroll through results Click on a company to view description, price graph, corporate action or news pages,Equity Search Functions: MA,Where 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
11、 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 searche
12、s Custom Search provides customizable search categories so you can define specific criteria for displaying transactions,Equity Search Functions: MAInteractive Example: M&A Custom Search,Where am I? MA , 1 ,Equity Search Functions: MA7) M&A League Tables,Where am I? MA , 7 ,Equity Search Functions: M
13、A8) M&A Statistics,Where 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 No
14、rth 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:
15、ex: IPOs,Where am I? UNDW ,Search Functions: LEAG,Where 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?,Equi
16、ty 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 Deb
17、t Ratings,Where am I? QSRC ,Equity Markets FunctionsWEI: World Equity Markets View,Where am I? WEI ,Equity Markets FunctionsLVI: Largest Volume Increases,Where am I? LVI ,Equity Markets FunctionsLVI: Largest Volume Increases,Where am I? LVI ,Equity Markets FunctionsWPE: World PE,Where am I? WPE ,Equ
18、ity Markets Functions WEIS: World Equity Ranked Returns,Where am I? WEIS ,Equity Markets Functions WEIS: World Equity Ranked Returns,Where am I? WEIS ,Equity Markets Functions WEIS: World Equity Ranked Returns,Where am I? WEIS ,Equity Markets Functions WEIS: World Equity Ranked Returns,Where am I? W
19、EIS ,Equity Markets Functions NN: Equity News Search Category,Where am I? NN ,Equity Markets Functions NN: Equity News Search Category,Where am I? NN 36 ,Equity Markets Functions EMI: Equity Market Indicators,Where am I? EMI ,Equity Markets Functions EMI: Equity Market Indicators,Where am I? EMI 31
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- bloomberg 数据库教学课件 数据库 教学 课件
链接地址:https://www.31doc.com/p-8570987.html