BQL stands for Bloomberg Query Language, which is the language used to perform analytics with and retrieve data from the Bloomberg Database. Recently, Bloomberg has rolled out five new functions to its Excel Add-in that make it possible to use BQL queries in Excel.
• BQL
• BQL.Query
• BQL.Dates
• BQL.Params
• BQL.Expr
For more information and resources, see our BQL for Excel page and read our primer, Introduction to BQL. Official documentation is still under development, but for the most up-to-date notes from Bloomberg see HELP BQLX .
Like the BDH and BDP functions, the BQL functions can be used to retrieve current and historic data. Uniquely, they are also capable of performing more involved procedures like interval calculations, time series, and equity screens. The new functions are advantageous to implement because they allow API users to perform data-intensive calculations and manipulations on the Bloomberg cloud.
August 2018
AUG
2018
About the Author: