Jun 3, 2021 · If you run BQNT<GO> on the terminal, you'll get access to Python BQL examples, but the examples won't work outside of BQNT. Since you mention using =BQL, I'm assuming you have access to a terminal. Example in BQNT:

Aug 20, 2021 · import pandas as pd import time import win32com.client as wc #Get a dispatch interface for the Excel app _xl = wc.Dispatch("Excel.Application") #Ensure the Bloomberg addin is loaded _xl.Workbooks.Open('c:\\blp\\API\\Office Tools\\BloombergUI.xla') #Create a new workbook wb = _xl.Workbooks.Add() ws = wb.Sheets(1) cl = ws.Cells(1,1) #Cell A1 on ...

Aug 13, 2019 · I know they are using bql and I found a few websites with some source codes but not enough to actually learn all the possibilities. Does anyone know where to find any documentation? or how the code would look like to import graph data from the terminal? I've managed to find a document for excel's BQL function but not much further than that.

Jun 25, 2020 · I am changing the inputs to a BQL.Query formula in the Excel sheet from a VBA script, and calling Application.Calculate to run the query. The display changes to "N/A Requesting Data ...". In the VBA I wait a bit (using Wait()) and even throw in a DoEvents() for good measure.

Aug 5, 2021 · In response to the follow-up, the best way to get the members of an index from Bloomberg is to use BQL (Bloomberg Query Language). There is a 'BQL Builder' option in the Bloomberg toolbar, or use the Function Builder (the sytnax is slightly different). For the OP's question, enter this formula in a cell: =BQL("members('SPX INDEX')","ID_ISIN")

Dec 10, 2021 · Bloomberg now offers an additional way to get data into Excel: the Bloomberg Query Language (BQL). This is more akin to an SQL query, and supports aggregation and analysis on the server side. It may be that this can provide more intraday data.

Dec 16, 2021 · Currently the BQL interface in Excel is not available via Python directly. There are clunky workarounds (driving Excel from Python and running the function in a spreadsheet), but in this case the information is accessible via the 'old school' data API, using Bulk Data (in the same way as the =BDS(...) function in Excel).

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 …

Mar 27, 2022 · =BQL("members('SPY US Equity',type='holdings')", "id().weights") The above code works but it only gives me the weights as off today. Is there a way to get a historical timeseries of this data?

I'm trying to get a recordset via a BQL query, but I can't figure out how to create a constant for a date. I'd like to filter based on a hard date value - but I see no examples anywhere for a date constant. I tried using a string constant with the date value, but that did not work, and if I try to use a DateTime as such: