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 ...

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 …

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:

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.

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年9月12日 · The code presented is just BQL to to retrieve data from the Item view of the InventoryItemMaint graph. The fancy part of it is LINQ. Personally, I tend to use Search to find records of the primary view and Select to retrieve the data of a child view. The 2nd sample code is using BQL to select a record directly without use of a view.

2021年3月8日 · I'd like to use BQL to get a recordset from SOLine (joined to BCSyncDetails table/DAC) of just the distinct orderNbr values. I've tried using the PXSelectJoinGroupBy method: var solines = PXSelectJoinGroupBy<SOLine, InnerJoin<BCSyncDetail, On<SOLine.noteID, Equal<BCSyncDetail.localID>>>, Aggregate<GroupBy<SOLine.orderNbr, …