The BQL works in Excel using what appears to be the same API add-in using the same fields to call the Bloomberg data, i.e PX_LAST. I currently run models in python using pdblp, that works great and I would love to move to the BQL version of the API to optimize data usage outside of the terminal. Is anyone aware of any effort to utilize the BQL in any package? I know someone asked about this last year... looking for an update.
The BQuant environment is built on open source tools like Python and Jupyter notebooks and is fully integrated with the Bloomberg Terminal®. Use the Bloomberg Query Language (BQL) Editor to create custom fields and analytics.
About pdblp pdblp attempts to provide a simple pandas wrapper around the Bloomberg Open API, specifically to give access to historical market data and reference data. This documentation provides a simple tutorial as well as a reference API.
BLPAPI PROGRAMMING INTERFACE Subscription services are used to receive data that changes frequently and/or at unpredictable intervals, for example equity pricing data or order-fill notifications.
Quite old but maybe someone comes along this thread... I talked to BBG recently and they have no intention to open the BQL API for Python. They couldn't give me a reason why, when I asked but I guess they want to promote their internal BQNT environment.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With