2021年6月3日 · 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:

2021年8月20日 · 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 ...

2019年8月13日 · 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.

2020年6月25日 · 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.

2021年8月5日 · 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")

2021年12月10日 · 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.

2021年12月16日 · 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 …

2022年3月27日 · =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: