📋
Bloomberg
  • Introduction
  • Bloomberg Terminal Basis
    • Keyboard Setting
    • Documentations
    • Equity
    • Fixed Income
    • Concepts
  • BQL
    • Bloomberg Query Language (BQL)
    • Documentation
  • Files
    • Useful Files
Powered by GitBook
On this page
  • BQL: Bloomberg Query Language
  • BDP: Bloomberg Data Point
  • BDH: Bloomberg Data History
  • BDS: Bloomberg Data Set

Was this helpful?

  1. Bloomberg Terminal Basis

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

PreviousFixed IncomeNextBloomberg Query Language (BQL)

Last updated 4 years ago

Was this helpful?