BQL stands for Bloomberg Query Language, which is the language used to perform analytics with and retrieve data from the Bloomberg Database. New functions have been added to the Bloomberg Excel Add-in that can be used to retrieve data using BQL. Like the Excel functions BDH and BDP, it’s possible to retrieve both current and historical data using BQL. Uniquely, BQL is also capable of performing complex tasks like screening, interval calculations, time series calculations, and supports the declaration of custom fields.A useful feature of BQL is the ability to manipulate data before retrieval. This includes arithmetic operations, rounding, finding the highest number in a set, etc. The advantage of performing calculations within BQL rather than in Excel is that it retrieves fewer pieces of information through the API and is therefore easier to process.
Share this post
Using Bloomberg Query Language in Excel
Share this post
BQL stands for Bloomberg Query Language, which is the language used to perform analytics with and retrieve data from the Bloomberg Database. New functions have been added to the Bloomberg Excel Add-in that can be used to retrieve data using BQL. Like the Excel functions BDH and BDP, it’s possible to retrieve both current and historical data using BQL. Uniquely, BQL is also capable of performing complex tasks like screening, interval calculations, time series calculations, and supports the declaration of custom fields.A useful feature of BQL is the ability to manipulate data before retrieval. This includes arithmetic operations, rounding, finding the highest number in a set, etc. The advantage of performing calculations within BQL rather than in Excel is that it retrieves fewer pieces of information through the API and is therefore easier to process.