Concepts

BQL: Bloomberg Query Language

BDP: Bloomberg Data Point

Description

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.

Usage

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

Description

for historical end of day and historical intraday data. It returns the historical data for a selected security/set of securities and timeframe.

Usage

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