Concepts
BQL: Bloomberg Query Language
BDP: Bloomberg Data Point
For static or real time current data
It returns data to a single cell in your Excel spreadsheet
This formula contains only one security and only one field.
Syntax: =BDP(security, field)
Example: =BDP("goog us equity","px last") retrieves the price of the last trade on Google Inc.
BDH: Bloomberg Data History
for historical end of day and historical intraday data. It returns the historical data for a selected security/set of securities and timeframe.
Syntax:
=BDH(security,
field,
start date [mm/dd/yyyy],
end date [mm/dd/yyyy],
optional arguments)
Example: =BDH("goog us equity", "EBIT", "1/1/2005", "12/31/2009", "per=cy", "curr=USD") retrieves the annual Earnings Before Interest and Tax of Google Inc. from 1/1/2005 to 12/31/2009 in USD.
BDS: Bloomberg Data Set
informational bulk data or multi-cell descriptive data to your Excel spreadsheet
Last updated
Was this helpful?