I have the following query in Excel using BQL: =BQL("MEMBERS('INEMCBI LX Equity',type=holdings)";"name";"cols=2;rows=223") This shows a table of securities of a specif...

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 am a Bloomberg terminal user and am trying to get the API to work via Python. I have Python 3.7.0 64-bit on my Windows 7 64-bit computer installed to: C:\Users\gp\AppData\Local\Programs\Python\...

I have an Excel sheet with ~300,000 BDH formulas to download securities prices. I want to open the file and get all prices paste them as values save and close the file. However, I do not know...

I would like to know if there's a way in VBA code forcing the bloomberg functions (In spreadsheet) to update its value( Any BDH functions) Targeting Developers have faced similar issue/ have Bloom...

I'm using Bloomberg Java api to download trading data. I need somebody to tell me if there exists a function which can return a list of trading holidays. I looked through the manual but couldn't fi...

I am trying to get set up with the Bloomberg Python API. I have been following along with this tutorial. I am able to successfully python -m pip install — index-url=https://bloomberg.bintray.com/pi...

I've written some code which successfully pulls data from the bloomberg api by using python to write a query in excel, it then launches excel gets the data via the bloomberg plugin, transfers the d...

I would like to know if there was a way to do : Bloomberg - > Refresh Workbook But not with my hand and in VBA or using something else.. : Workbook.calculate does not work some times form...

I'm currently trying to connect to the Bloomberg API but after trying for a day still not able to get it running. Below is sample code from the API Guide, the part where I keep getting "Could not ...

Is there a way to implement BQL using python API or even any language`s API?

Is there anyway to determine how many requests or how much data you have in your remaining request limit amount for Bloomberg API?

For some reason the following code runs fine but the file overwrite alert keeps coming up even though I have set xl.EnableEvents = False, the code won't execute further unless I manually click the ...

Does anyone know any good resources/ tutorials/ books to get started with Bloomberg's API blpapi in python? I have searched everywhere and I haven't found anything at all.

pdblp allows daily historical Bloomberg requests via: con = pdblp.BCon(debug=False) con = start() df = con.bdh(['SPY Equity'], 'PX_LAST', '20150103', '20150619') How can intraday price/volume/op...

I'm running a macro in a blank Excel 2007 workbook on a PC with a Bloomberg license. The macro inserts Bloomberg functions into sheet1 that pull yield curve data. Some additional functions' results...

I have excel with the Bloomberg API ( which uses simple calls like =BDP("MS equity","ask") ). I also have a C# application that opens an excel file (through interop) that uses the Bloomberg API. I ...

I recently started using Python so I could interact with the Bloomberg API, and I'm having some trouble storing the data into a Pandas dataframe (or a panel). I can get the output in the command pr...

I'm trying to setup my Mac OS X system to use the pdblp Python library which requires me to first install the Bloomberg Open API libary for Python. After cloning the git repo and running python set...

This is my development environment: Windows 7 on a 64-bit HP Pavilion laptop Python 2.7, 32-bit in folder C:\python27 Development environment is Eclipse with PyDev, but this doesn't seem to matte...

I get following error, when I use bdp with ISIN or CUSIP. bdp ("US25470XAB10 ISIN","ULT_PARENT_TICKER_EXCHANGE") bdp ("25470XAB1 CUSIP","ULT_PARENT_TICKER_EXCHANGE") Error in bdp_Impl(con, securi...

I'm starting to use the python api for Bloomberg and I'm wondering if anyone has written a wrapper to convert responses from Bloomberg into pandas timeseries? pybbg is a wrapper for the old C...

I have a list of ISINs which is my only source of information. In Excel I can catch the Bloomber ticker which is needed in many cases because it specifies the code of the exchange on which the asse...

I have to download historical end of day data for a huge list of stocks. I found on the bloomberg excel add-in the function BDH that is very useful. That is what I need but there is an issue: my st...

A popular financial software vendor distributes a "private" .NET framework: What exactly is a private .NET framework? Why might someone want to have their own, private version of the .NET frame...