Get the 34 page document and more with the price of a coffee

☕

• Getting Started with Bloomberg Terminal 

• Familiar with Bloomberg Page 

• Put keywords in the "Name" column and further filter by "Category" and "Subcategory" {SECF } Securities Search 5 Machine Translated by Google 6 {DES } 

• Securities Introduction 

• Stock valuation function

• Financial data analysis {FA } 

• {EEO } Forecast comprehensive opinion 

• {EEB } Forecast summary details 

• Company financial segment forecast {MODL } 

• {ANR } Analyst Recommendations 

• {WACC } Weighted Average Cost of Capital

• {EQRP } Equity Risk Premium

• {BETA } History Beta

• {EQRV } Relative stock valuation

• {EQRV } Relative stock valuation

• {CCB } Company Industry Classification

• {EQS } Stock Screening

• {EQS } Stock Screening

• {RV } Relative Valuation

• {PEBD } PE Band

• {XLTP} Bloomberg Excel Template Library

• {XLTP} Bloomberg Excel Template Library

• {HELP DAPI } Bloomberg Excel API + Formula Explanation

• Keyword examples: "revenue growth ", "PE", "return" Enter keywords to search for available data columns, click into the column to view specific definitions + available rewrites + whether there are historical values

• Tips: 1. Combine FA to search for column names 2. The names with "BEst" are predicted values Bloomberg Estimates BEST_PE_RATIO vs PE_RATIO

• {FLDS } Bloomberg Excel API data column query

• Column rewrite, only used in a certain column, you can click on the column in FLDS to view the available rewrites =BDP(“700 HK Equity”, “SALES_REV_TURN”, “EQY_FUND_CRNCY=USD”, “FUND_PER=2020”) 31 =BDH("700 HK Equity","PX_VOLUME","20230101","", "per=m","dir=h")

• The date format is "YYYYMM =BDH("CNGDPYOY Index","PX_LAST","20210101","","per=q") Quarterly GDP data The end date of "Daily" is empty, which means extracting to the latest day =BDP(“700 HK Equity”,“PX_VOLUME”,“Fill=B”) formula parameters, applicable to all BDP formulas Formula Examples

• {USER , BPS , SMNR } Functional exploration