While the Data Wizards are the easiest way to download 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:
Basically, there are 3 types of BBG Formulas:
Bloomberg Formulas | Example |
BDP (Bloomberg Data Point)
Formula Syntax: =BDP("Security", "Field")
|
To retrieve the price of the last trade of Google Stock: =BDP("GOOG US EQUITY","PX_LAST") |
BDH (Bloomberg Data History)
Formula Syntax: =BDH("Security", "Field", "Start Date","End Date", "Optional Arguments")
|
To retrieve annual EBIT data for HSBC from 2009 to 2011: =BDH("5 HK EQUITY","EBIT","01/01/2009", "12/31/2011","PER=CY","CURR=USD") |
BDS (Bloomberg Data Set)
Formula Syntax: =BDS("Security", "Field", "Optional Arguments")
|
To retrieve company (601398 CH) decription: =BDS("601398 CH EQUITY","DES") |
The following templates show you how to use Bloomberg formulas to extract data
1. Downloading Time Series Data (e.g. LAST_PRICE) for Multiple Securities (vertical format) (HKUST Only)
2. Downloading Time Series Data (e.g. LAST_PRICE) for Multiple Securities (horizontal format)
3. Downloading Fundamental Data Using Override Method