Please make sure you have the Bloomberg Excel Add-In installed before trying out the following Bloomberg formulas and templates. (Installation Steps)
While the Spreadsheet Builder are the easiest way to download Bloomberg data to Excel, the Bloomberg Formulas give you more flexibility to create your own data set and its layout. When using any of the formulas, specify these:
- Security instrument (e.g. equity, bond, fund, etc.)
- Data field, and the field must be represented by its field mnemonic.
- To find a particular field name, use FLDS
Basically, there are 3 types of BBG Formulas:
| Bloomberg Formulas |
Example |
|
BDP (Bloomberg Data Point)
- Contains only one ticker and one data field
- One static or real time data point only
Formula Syntax: =BDP("Security", "Field")
|
To retrieve the last price of Alphabet Inc:
=BDP("GOOG US EQUITY","PX_LAST")
|
|
BDH (Bloomberg Data History)
- Contains only one ticker and one data field
- One static or real time data point only
Formula Syntax: =BDH("Security", "Field", "Start Date","End Date", [optional parameters])
|
To retrieve closing prices for HSBC from 2020 to 2021:
=BDH("5 HK EQUITY","PX_LAST","01/01/2020","12/31/2021")
|
|
BDS (Bloomberg Data Set)
- Provides descriptive data
- One static or real time data point only
Formula Syntax: =BDS("Security", "Field", [optional parameters])
|
To retrieve company's (601398 CH) description:
=BDS("601398 CH EQUITY","CIE_DES_BULK")
|
