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

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.

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.

2017年5月10日 · 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:

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年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")

2016年9月26日 · Short of creating a custom BQL operator, you can achieve "Starts with" by using the LIKE operator, with the % wildcard at the end. The BQL field you're filtering on could be a DAC property with custom code in the get accessor, which takes your user-entered field and adds the wildcard character at the end, like that:

2018年2月25日 · This will allow you to use A and B in your BQL query. (You can find more info about that in T200 Training, Example 3.1: Providing Data for the Inquiry Page) (you can use PX.Data.Constant<int>, PX.Data.Constant<decimal>, etc. depending on parameter type) After that you can compose BQL: PXSelect<Table, Where<Table.field, In3<constantA, constantB>>>

2012年1月9日 · The daily limit is clearly stated - it is the monthly limit that is not to my knowledge disclosed in writing. I have been told the following in the context of discussions about Data Licence, which is one Bloomberg product for bulk data subscripti