《bloomberg 数据库教学课件.ppt》由会员分享,可在线阅读,更多相关《bloomberg 数据库教学课件.ppt(109页珍藏版)》请在金锄头文库上搜索。
1、IntroductoryBloombergTraining Createdby JoryJ McCuskeyjjmccuskey Editedby BillyPrather TutorialOutline KeyboardandNavigationGettingStartedEquityFunctionsDebtFunctionsOptionFunctionsNewsFunctionsConclusionDataExport TheKeyboard Overview CommandStructureIdentifier TickerSymbol MarketSector Yellowkeys
2、ex F8orEquityFunction Bloomberglistedcode ex FAforFinancialAnalysisExample DELLequityFA Navigation MENUReturnsyoutopreviouspagePAGEBACK PAGEUPScrollsthroughmultipagedocumentsHELPKeywordsearch TheKeyboard Continued Rulesofthumb Green GoRed StopYellow InformationAllyellowboxesareadjustableinputs TheKe
3、yboard Continued LogIntoBloombergTerminal Step1 PressCONNDFLTbuttonontoprightsideofkeyboard Step2 Loginusingcredentialsprintedonkeyboardormonitor Step1 PresstheEQUITYF8keythenpressGO enter TheEquitiesPage Note Thispageisyourmainresourceforallequityrelatedfunctions FunctionsCovered TK QSRC MA SearchF
4、unctions Equities EquitySearchFunctions TK WhereamI TK Overview Quicklysearchforequitiesbypartialissuername EquitySearchFunctions TK Ticker CountryCode CompanyName EquitySearchFunctions TK NowTryThis UsingtheTKEquitySearchFunction Instructions ThinkofaU S companywho stickeryoudon tknowandusetheTKfun
5、ctiontofinditsEquitypage QSRC EquitySearch SelectthesearchyouwishtoRUNorEDIT Choosefromtheavailableoptions QSRC EquitySearchEditingSearchCriteria CustomizedEquitySearchFunctions QSRC OverviewGeneratesalistofequitysecuritiesbasedonasetofcriteriayouselectsuchas Country state exchange securitytype inde
6、x industrygroupandavarietyofnumericalvaluessuchasGrossprofitmarginQuicklyscreenforopportunitiesbasedonfundamentalandtechnicaldataToaccesstype QSRC WhereamI QSRC CustomizedEquitySearchFunctions QSRCInteractiveExample WhereamI QSRC Overview CreateasearchthatfindsallU S Investmentbankslargerthan 500Mln
7、 CustomizedEquitySearchFunctions QSRCInteractiveExample WhereamI QSRC Givethesearchaname ex BIGGESTINV BANKS presstosave Selectasearchfield CustomizedEquitySearchFunctions QSRCFeatures WhereamI QSRC Type MarketCap inthe SearchAllFields boxandpressSelectoption21 CurrencyAdjMktCapLastCloseSettheminimu
8、mforCurrencyAdjMktCapto 500MlnSelectoption19 IndustryGroups CustomizedEquitySearchFunctions QSRCFeatures WhereamI QSRC Select8 FinancialSelect25 DiversifiedFinanServSelect28 InvestmentBnkr BrkrPresstwice note 1IndustryGrouphasbeenselected CustomizedEquitySearchFunctions QSRCInteractiveExample Wherea
9、mI QSRC ClickEdit SearchDisplayClick Selectdisplayfield typeMarketCap selectCurrencyAdjMktCapType4intheorangeboxnexttoCurrencyAdjMktCapSet1stSortColumnto4 and2forDescendingOrder then1toviewresults CustomizedEquitySearchFunctions QSRCInteractiveExample WhereamI QSRC Press toscrollthroughresultsClicko
10、nacompanytoviewdescription pricegraph corporateactionornewspages EquitySearchFunctions MA WhereamI MA OverviewProvidescoverageonglobalmergerandacquisitionactivityUsestandardizeddealsearchorcreateacustomizedsearchViewM AlegalandfinancialleaguetablesaswellascomprehensiveglobalM AstatisticsToaccesstype
11、 MA EquitySearchFunctions MA1 M ASearch WhereamI MA 1 OverviewQuickCompanySearchallowsyoutosearchbycompanynameortickerStandardCategoriesallowyoutoviewresultsfrompredefinedsearchesCustomSearchprovidescustomizablesearchcategoriessoyoucandefinespecificcriteriafordisplayingtransactions EquitySearchFunct
12、ions MAInteractiveExample M ACustomSearch WhereamI MA 1 EquitySearchFunctions MA7 M ALeagueTables WhereamI MA 7 EquitySearchFunctions MA8 M AStatistics WhereamI MA 1 NowTryThis UsingtheM ASearchFunctions Instructions CreateanM ACustomsearchforallU S M Adeals In2003IntheRealEstateIndustryByGoldmanSac
13、hsUsingtheM ALeagueTablesfunction comparemarketshareforRealEstaterelatedtransactionsNorthAmericaamongbothfinancialandlegaladvisorsUsingtheM AStatisticsfunction findtheaveragepremiumpaidforRealEstaterelatedM AtransactionsinMarch04 Howdoesthispremiumcomparewiththeaveragepremiumpaidacrosstheworld Searc
14、hFunctions UNDWCustomUnderwriterRankings ex IPOs WhereamI UNDW SearchFunctions LEAG WhereamI LEAG NowTryThis UsingtheLEAGorUNDWSearchFunctions Instructions SeewholeadstheLeagueTablesforU S High yieldDebtCreateacustomsearchforallIPOsintheUSWholeadstheleaguetablesforCanadianGovernmentDebt EquityMarket
15、sFunctions Functionstobecovered WEI WorldEquityMarketsviewLVI LargestVolumeIncreasesWPE WorldPEWEIS WorldEquityRankedReturnsNN EquityNewsSearchCategoryEMI EquityMarketIndicatorsIMOV IndexMoversMOST MostActiveEMTK EquityMarketTickerCSDR SovereignDebtRatings WhereamI QSRC EquityMarketsFunctionsWEI Wor
16、ldEquityMarketsView WhereamI WEI EquityMarketsFunctionsLVI LargestVolumeIncreases WhereamI LVI EquityMarketsFunctionsLVI LargestVolumeIncreases WhereamI LVI EquityMarketsFunctionsWPE WorldPE WhereamI WPE EquityMarketsFunctionsWEIS WorldEquityRankedReturns WhereamI WEIS EquityMarketsFunctionsWEIS WorldEquityRankedReturns WhereamI WEIS EquityMarketsFunctionsWEIS WorldEquityRankedReturns WhereamI WEIS EquityMarketsFunctionsWEIS WorldEquityRankedReturns WhereamI WEIS EquityMarketsFunctionsNN EquityN