bloomberg-数据库教学课件

bloomberg数据库教学课件bloomberg数据库教学课件bloomberg数据库教学课件TutorialOutlineKeyboardandNavigationGettingStartedEquityFunctionsDebtFunctionsOptionFunctionsNewsFunctionsConclusionDataExport人有了知识，就会具备各种分析能力，明辨是非的能力。bloomberg数据库教学课件bloomberg数据库1TutorialOutlineKeyboardandNavigationGettingStartedEquityFunctionsDebtFunctionsOptionFunctionsNewsFunctionsConclusionDataExportTutorialOutlineKeyboardandNTheKeyboard:OverviewCommandStructureIdentifier(TickerSymbol)MarketSector(Yellowkeys)ex.F8orEquityFunction(Bloomberglistedcode)ex.FAforFinancialAnalysisExample:DELLequityFATheKeyboard:OverviewCommandNavigation:MENUReturnsyoutopreviouspagePAGEBACK/PAGEUPScrollsthroughmultipagedocumentsHELPKeywordsearchTheKeyboard:ContinuedNavigation:TheKeyboard:ContiRulesofthumb:Green=GoRed=StopYellow=InformationAllyellowboxesareadjustableinputsTheKeyboard:ContinuedRulesofthumb:TheKeyboard:CLogIntoBloombergTerminalStep1:PressCONNDFLTbuttonontoprightsideofkeyboardStep2:LoginusingcredentialsprintedonkeyboardormonitorLogIntoBloombergTerminalSteStep1:Pressthe

EQUITY

F8keythenpressGO(enter)TheEquitiesPageNote:ThispageisyourmainresourceforallequityrelatedfunctionsStep1:PresstheEQUITYF8keFunctionsCovered:TK,QSRC,MASearchFunctions:EquitiesFunctionsCovered:TK,QSRC,EquitySearchFunctions:TKWhereamI?<Equity>TK<GO>Overview:QuicklysearchforequitiesbypartialissuernameEquitySearchFunctions:TKWheEquitySearchFunctions:TKTickerCountryCodeCompanyNameEquitySearchFunctions:TKTicEquitySearchFunctions:TKEquitySearchFunctions:TKNowTryThis!

UsingtheTKEquitySearchFunctionInstructions:ThinkofaU.S.companywho’stickeryoudon’tknowandusetheTKfunctiontofinditsEquitypageNowTryThis!

UsingtheTKEquQSRC:EquitySearchSelectthesearchyouwishtoRUNorEDITChoosefromtheavailableoptionsQSRC:EquitySearchSelecttheQSRC:EquitySearch

EditingSearchCriteriaQSRC:EquitySearch

EditingSeCustomizedEquitySearchFunctions:QSRCOverviewGeneratesalistofequitysecuritiesbasedonasetofcriteriayouselectsuchas:Country,state,exchange,securitytype,index,industrygroupandavarietyofnumericalvaluessuchasGrossprofitmarginQuicklyscreenforopportunitiesbasedonfundamentalandtechnicaldataToaccesstype:QSRC<GO>WhereamI?<Equity>QSRC<GO>CustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

InteractiveExampleWhereamI?<Equity>QSRC<GO>Overview:CreateasearchthatfindsallU.S.Investmentbankslargerthan$500MlnCustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

InteractiveExampleWhereamI?<Equity>QSRC<GO>Givethesearchaname(ex:BIGGESTINV-BANKS)(press<GO>tosave)SelectasearchfieldCustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

FeaturesWhereamI?<Equity>QSRC<GO>Type“MarketCap”inthe‘SearchAllFields’boxandpress<GO>Selectoption21)CurrencyAdjMktCapLastCloseSettheminimumforCurrencyAdjMktCapto$500MlnSelectoption19)IndustryGroupsCustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

FeaturesWhereamI?<Equity>QSRC<GO>Select8)FinancialSelect25)DiversifiedFinanServSelect28)InvestmentBnkr/BrkrPress<MENU>twice(note:1IndustryGrouphasbeenselected)CustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

InteractiveExampleWhereamI?<Equity>QSRC<GO>ClickEdit,SearchDisplayClick‘Selectdisplayfield’,typeMarketCap,selectCurrencyAdjMktCapType4intheorangeboxnexttoCurrencyAdjMktCapSet1stSortColumnto4,and2forDescendingOrder,then1<GO>toviewresultsCustomizedEquitySearchFunctCustomizedEquitySearchFunctions:QSRC

InteractiveExampleWhereamI?<Equity>QSRC<GO>Press<PAGEFWD>/<PAGEBACK>toscrollthroughresultsClickonacompanytoviewdescription,pricegraph,corporateactionornewspagesCustomizedEquitySearchFunctEquitySearchFunctions:MAWhereamI?<Equity>MA<GO>OverviewProvidescoverageonglobalmergerandacquisitionactivityUsestandardizeddealsearchorcreateacustomizedsearchViewM&AlegalandfinancialleaguetablesaswellascomprehensiveglobalM&AstatisticsToaccesstype:MA<GO>EquitySearchFunctions:MAWheEquitySearchFunctions:MA

1)M&ASearchWhereamI?<Equity>MA<GO>,1<GO>OverviewQuickCompanySearchallowsyoutosearchbycompanynameortickerStandardCategoriesallowyoutoviewresultsfrompredefinedsearchesCustomSearchprovidescustomizablesearchcategoriessoyoucandefinespecificcriteriafordisplayingtransactionsEquitySearchFunctions:MA

1EquitySearchFunctions:MA

InteractiveExample:M&ACustomSearchWhereamI?<Equity>MA<GO>,1<GO>EquitySearchFunctions:MA

InEquitySearchFunctions:MA

7)M&ALeagueTablesWhereamI?<Equity>MA<GO>,7<GO>EquitySearchFunctions:MA

7)EquitySearchFunctions:MA

8)M&AStatisticsWhereamI?<Equity>MA<GO>,1<GO>EquitySearchFunctions:MA

8)NowTryThis!

UsingtheM&ASearchFunctionsInstructions:CreateanM&ACustomsearchforallU.S.M&Adeals:In2003IntheRealEstateIndustryByGoldmanSachsUsingtheM&ALeagueTablesfunction,comparemarketshareforRealEstaterelatedtransactionsNorthAmericaamongbothfinancialandlegaladvisorsUsingtheM&AStatisticsfunction,findtheaveragepremiumpaidforRealEstaterelatedM&AtransactionsinMarch04.Howdoesthispremiumcomparewiththeaveragepremiumpaidacrosstheworld?NowTryThis!

UsingtheM&ASeSearchFunctions:UNDW

CustomUnderwriterRankings:ex:IPOsWhereamI?<Equity>UNDW<GO>SearchFunctions:UNDW

CustomSearchFunctions:LEAGWhereamI?LEAG<GO>SearchFunctions:LEAGWhereamNowTryThis!

UsingtheLEAGorUNDWSearchFunctionsInstructions:SeewholeadstheLeagueTablesforU.S.High-yieldDebtCreateacustomsearchforallIPOsintheUSWholeadstheleaguetablesforCanadianGovernmentDebt?NowTryThis!

UsingtheLEAGoEquityMarketsFunctionsFunctionstobecovered:WEI:WorldEquityMarketsviewLVI:LargestVolumeIncreasesWPE:WorldPEWEIS:WorldEquityRankedReturnsNN:EquityNewsSearchCategoryEMI:EquityMarketIndicatorsIMOV:IndexMoversMOST:MostActiveEMTK:EquityMarketTickerCSDR:SovereignDebtRatingsWhereamI?QSRC<GO>EquityMarketsFunctionsFunctiEquityMarketsFunctions

WEI:WorldEquityMarketsViewWhereamI?<Equity>WEI<GO>EquityMarketsFunctions

WEI:EquityMarketsFunctions

LVI:LargestVolumeIncreasesWhereamI?<Equity>LVI<GO>EquityMarketsFunctions

LVI:EquityMarketsFunctions

LVI:LargestVolumeIncreasesWhereamI?<Equity>LVI<GO>EquityMarketsFunctions

LVI:EquityMarketsFunctions

WPE:WorldPEWhereamI?<Equity>WPE<GO>EquityMarketsFunctions

WPE:EquityMarketsFunctions

WEIS:WorldEquityRankedReturnsWhereamI?<Equity>WEIS<GO>EquityMarketsFunctions

WEISEquityMarketsFunctions

WEIS:WorldEquityRankedReturnsWhereamI?<Equity>WEIS<GO>EquityMarketsFunctions

WEISEquityMarketsFunctions

WEIS:WorldEquityRankedReturnsWhereamI?<Equity>WEIS<GO>EquityMarketsFunctions

WEISEquityMarketsFunctions

WEIS:WorldEquityRankedReturnsWhereamI?<Equity>WEIS<GO>EquityMarketsFunctions

WEISEquityMarketsFunctions

NN:EquityNewsSearchCategoryWhereamI?<Equity>NN<GO>EquityMarketsFunctions

NN:EquityMarketsFunctions

NN:EquityNewsSearchCategoryWhereamI?<Equity>NN<GO>36<GO>EquityMarketsFunctions

NN:EquityMarketsFunctions

EMI:EquityMarketIndicatorsWhereamI?<Equity>EMI<GO>EquityMarketsFunctions

EMI:EquityMarketsFunctions

EMI:EquityMarketIndicatorsWhereamI?<Equity>EMI<GO>31<GO>EquityMarketsFunctions

EMI:EquityMarketsFunctions

EMI:EquityMarketIndicatorsWhereamI?<Equity>EMI<GO>31<GO>EquityMarketsFunctions

EMI:EquityMarketsFunctions

EMI:EquityMarketIndicatorsWhereamI?<Equity>EMI<GO>31<GO>EquityMarketsFunctions

EMI:EquityMarketsFunctions

IMOVWhereamI?QSRC<GO>EquityMarketsFunctions

IMOVWbloomberg-数据库教学课件EquityMarketsFunctions

MOSTWhereamI?QSRC<GO>EquityMarketsFunctions

MOSTWEquityMarketsFunctions

EMTK:EquityMarketTickerWhereamI?<Equity>EMTK<GO>EquityMarketsFunctions

EMTKEquityMarketsFunctions

EMTK:EquityMarketTickerWhereamI?<Equity>EMTK<GO>11<GO>EquityMarketsFunctions

EMTKEquityMarketsFunctions

EMTK:EquityMarketTickerWhereamI?<Equity>EMTK<GO>11<GO>11<GO>EquityMarketsFunctions

EMTKCSDR:SovereignDebtRatingsWhereamI?CSDR<GO>CSDR:SovereignDebtRatingsWhCSDR:SovereignDebtRatingsWhereamI?CSDR<GO>1<GO>CSDR:SovereignDebtRatingsWhMultipleSecurityAnalyticsFunctionsUsefulfunctionstoexplore:HMS:4-in-1PriceGraphMRA:MultipleRegressionAnalysisCORR:CorrelationMatrixMultipleSecurityAnalyticsFuPriceGraphingFunctionsUsefulfunctionstoexplore:HP:HistoricalPriceTableGIP:IntradayPriceGraphGPO:Price&VolumeGraphw/MovingAvg.PriceGraphingFunctionsUsefulFinancialAnalysisFunctionsFunctionscovered:FA:FinancialAnalysisDVD:DividendSummary(notshown)CF:CompanyFilings(notshown)FinancialAnalysisFunctionsFuFinancialAnalysisFunctionsWhereamI?<Ticker><Equity>9<GO>FinancialAnalysisFunctionsWhFinancialAnalysisFunctionsWhereamI?<Ticker><Equity>FA<GO>FinancialAnalysisFunctionsWhFinancialAnalysisFunctionsWhereamI?<Ticker><Equity>FA<GO>9<GO>FinancialAnalysisFunctionsWhValuation,Risk&ReturnFunctionsFunctionscovered:RV:RelativeValueDDM:DividendDiscountModelWACC:WeightedAverageCostofCapitalBETA:BetaCalculationsCOMP:ComparativeReturnAnalysisEQRP:EquityRiskPremium(CAPM)CRP:CountryRiskPremiumValuation,Risk&ReturnFunctValuation,Risk&ReturnFunctions

RV:RelativeValueWhereamI?<Ticker><Equity>RV<GO>Valuation,Risk&ReturnFunctValuation,Risk&ReturnFunctions

DDM:DividendDiscountModelWhereamI?<Ticker><Equity>DDM<GO>Valuation,Risk&ReturnFunctValuation,Risk&ReturnFunctions

WACC:WeightedAverageCostofCapitalWhereamI?<Ticker><Equity>WACC<GO>Valuation,Risk&ReturnFunctValuation,Risk&ReturnFunctions

BETA:BetaCalculationWhereamI?<Ticker><Equity>BETA<GO>Valuation,Risk&ReturnFunctYoucanchangeseveralinputsDateRangeFrequencyMakesureyouhaveenoughdatapointsOtherwiseyourBetawillbeinaccurateMostprofessorsuseAdjustedBetaValuation,Risk&ReturnFunctions

BETA:NotesYoucanchangeseveralinputsVValuation,Risk&ReturnFunctions

COMP:ComparativeReturnsWhereamI?<Ticker><Equity>COMP<GO>Valuation,Risk&ReturnFunctValuation,Risk&ReturnFunctions

EQRP:EquityRiskPremium(CAPM)Valuation,Risk&ReturnFunctInputsExpectedMarketReturnRiskFreeRateRateoncurrent10-yrTreasuryBondsAppliedBetaCountryPremium(CRP)MarketPremiumMarketreturn–RiskfreerateValuation,Risk&ReturnFunctions

EQRP:EquityRiskPremium(CAPM)NotesInputsValuation,Risk&ReturnValuation,Risk&ReturnFunctions

CRP:CountryRiskPremium(MarketPremium)Valuation,Risk&ReturnFunctEarningsFunctionsFunctionsFunctionscovered:EE:EarningsEstimatesEEG:EarningsEstimateGraphERN:EarningsSummary(notshown)EarningsFunctionsFunctionsFuEarningsFunctionsFunctions

EE:EarningsEstimatesWhereamI?<Ticker><Equity>EE<GO>EarningsFunctionsFunctions

EInputsTypeofEstimateRevenueetc.CurrencyTimePeriodUsuallythelargerthecompanythemoretypesofestimatesouravailableEarningsFunctionsFunctions

EE:EarningsEstimatesNotesInputsEarningsFunctionsFunctEarningsFunctionsFunctions

EEG:EarningsEstimateGraphWhereamI?<Ticker><Equity>EEG<GO>EarningsFunctionsFunctions

EOtherFunctionsFunctionscovered:AIRS:AirlineStatisticsHDS:HoldingsSearchCACS:CorporateActionCalenderCACT:CorporateActionGlobalACDR:EarningsAnnouncementCalenderRELS:RelatedSecuritiesOtherFunctionsFunctionscoverOtherFunctions

AIRS:AirlineStatisticsDisplaysairtravelstatisticsbytheU.S.DepartmentofTransportationInformationStatisticsinclude:OnTimeArrivals,MishandledBaggageConsumerComplaints,andPassengerTrafficValueisthenumberper100,000passengersSortorviewagraphofeachstatisticovertimeWhereamI?AIRS<GO>OtherFunctions

AIRS:AirlineOtherFunctions

AIRS:AirlineStatisticsWhereamI?AIRS<GO>OtherFunctions

AIRS:AirlineOtherFunctions

HDS:HoldingsSearchWhereamI?CMCSK<EQUITY>HDS<GO>OtherFunctions

HDS:HoldingsOtherFunctions

CACS:CorporateActionCalendarOverviewDisplaysalistofcorporateactionstakenbyacompanyoveradaterangeCustomizethedatetype(effective,announcement),actiontype(acquisition,dividend,shareholdermeeting)anddaterangeWhereamI?<Ticker>

<EQUITY>CACS<GO>OtherFunctions

CACS:CorporaOtherFunctions

CACT:CorporateActionGlobalOtherFunctions

CACT:CorporaOtherFunctions

CACT:CorporateActionGlobalOtherFunctions

CACT:CorporaInputsDateRangeCorporateActionType4pagesofactiontypesCompanyNameCountryOtherFunctions

CACT:CorporateActionGlobalInputsOtherFunctions

CACT:COtherFunctions

ACDR:EarningsAnnouncementCalendarOverviewACDRdisplaysearningsestimatesandannouncementdatesforcompaniesinaspecifiedcountryorregionUsetocompareactualwithestimatedearningsWhereamI?<EQUITY>ACDR<GO>OtherFunctions

ACDR:EarningOtherFunctions

RELS:RelatedSecuritiesOverviewRELSallowsyoutoquicklyfindallequityanddebtsecuritiesissuedbyacompanyaswellasbrands,subsidiaries,people,news,majorphysicalassetssuchaspowerplantsorpipelinesWhereamI?<Ticker>

<EQUITY>RELS<GO>OtherFunctions

RELS:RelatedDebtFunctions

GovernmentSecurities(F2)DebtFunctions

GovernmentSecuDebtFunctions

GovernmentSecurities:Lookup(TK)DebtFunctions

GovernmentSecuDebtFunctions

Lookup:TK(continued)DebtFunctions

Lookup:TK(conDebtFunctions

Lookup:TK(continued)DebtFunctions

Lookup:TK(conDebtFunctions

Lookup:TK(continued)DebtFunctions

Lookup:TK(conDebtFunctions

YieldCurveSpread:FMCSDebtFunctions

YieldCurveSprDebtFunctions

YieldCurveSpread:FMCS(continued)DebtFunctions

YieldCurveSprDebtFunctions

YieldCurveSpread:FMCS(continued)DebtFunctions

YieldCurveSprDebtFunctions

YieldCurveSpread:FMCS(continued)DebtFunctions

YieldCurveSprDebtFunctions

CorporateBonds(F3)DebtFunctions

CorporateBondsDebtFu