Questions tagged [pdblp]

26 questions
8
votes
3 answers

Has anyone found away to call Bloomberg BQL API using Pdblp or another package with Python?

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 the API…
3
votes
2 answers

Field override for bdh() in pdblp

Bloomberg help isn't very helpful for their API. Can anyone please explain how to replace PX_LAST with the dividend adjusted price field. I have attempted the following but have been unsuccessful import pdblp con = pdblp.BCon() con.start() df2 =…
Ali
  • 33
  • 1
  • 6
2
votes
2 answers

Bloomberg APIs - historical index members in Python

I'm trying to get index members using Bloomberg APIs in Python. I have no issues getting current constituents, but I want a historical list (example: what where Russell 1000 or S&P 500 constituents as of Q1 1995). To get the current index members I…
k0rnik
  • 472
  • 5
  • 13
2
votes
1 answer

Has anybody used Blpapi/Pdblp etc packages to export Supply chain data (SPLC) from Bloomberg?

I am using pdblp package to gather supply chain data. But I am facing two problems. First, it just gives me the just first five suppliers of current date, not even all. Also, it does not give any historical data. By changing any date, still get the…
2
votes
1 answer

query bloomberg api with python; tickers return nothing

I'm new to bloomberg terminals but I'm trying to pull data from bloomberg using the python API. The underlying c++ SDK seems to be working as I have pip installed the following python libraries: blpapi pdblp I can connect to the terminal and run…
user3062260
  • 1,584
  • 4
  • 25
  • 53
1
vote
0 answers

How to retrieve ETF constituents(holdings) weightings information by Bloomberg API?

How to retrieve ETF constituents(holdings) weightings information by bloomberg API? **xbbg or pdblp ** below is for Index and it's working import pdblp con = pdblp.Bcon() con.start() con.bulkref('BCOM Index','INDEX_MWEIGHT')…
1
vote
2 answers

Bloomberg Anywhere + pdblp or xbbg + not logged in

SO, I am hoping for some clarity on how the Python API works when you are not logged in. I have a Bberg Anywhere account and have some scripts I'd like to run in the morning before I start my day. Do I need to be logged in? If not, do I need to…
antonio_zeus
  • 477
  • 2
  • 11
  • 21
1
vote
1 answer

running a simple pdblp code to extract BBG data

I am currently logged on to my BBG anywhere (web login) on my Mac. So first question is would I still be able to extract data using tia (as I am not actually on my terminal) import pdblp con = pdblp.BCon(debug=True, port=8194,…
TRex
  • 445
  • 5
  • 14
1
vote
2 answers

How can I use a CSV file for Python pdblp instead of a ticker reference for getting API from con.ref

I very new to Python and I want to replace an exact ticker with a reference to a column of a Data Frame I created from a CVS file, can this be done. i'm using: import pandas as pd import numpy as np import pdblp as pdblp import blpapi as blp con =…
1
vote
1 answer

pdblp con.bdh() function pulling yield instead of price

I am interested in pulling the price of a bond using the con.bdh( ) function from the pdblp package. The below code keeps pulling the yield of the bond, instead of the price. Does anyone know how I can pull the price? import pdblp con =…
1
vote
0 answers

getting pdblp or pybbg to work in spyder python

I have been trying to get either pdblp or pybbg to work in python. I have installed blpapi via pip, and download the experimental c++ version and added it to my PATH environmental variables. When running the following code I get this error for…
runccoabcc
  • 11
  • 4
0
votes
0 answers

BDP using override currency provided in adjacent column of a dataframe

I have a dataframe which contains ticker name and currency in adjacent columns. Now I want to extract data for a field which uses currency as an override (consider for e.g. the field CRNCY ADJ MKT CAP which has an override EQY_FUND_CRNCY). To get…
x0nar
  • 125
  • 2
  • 10
0
votes
0 answers

pdblp: Return `Volume` Data from `event_type`

Is it possible to specify the columns I want to retreive for each event_type? For example, event_type = TRADE returns [Open, High, Low, Close, Volume, numEvents] but I just want to see [Volume]. I am pulling 30days of 1 minute interval data for 30…
Analyst
  • 139
  • 2
  • 9
0
votes
1 answer

Drawing ISINs of a ticker via Python-Bloomberg API

I have a question about drawing ISIN's of goverment bonds in python. Up to my knowledge the state of the art package for this is "blp" in python which is described as the next iteration of pdblp. What I want to do is to get all the ISIN's of a…
alphaH
  • 1
0
votes
1 answer

Looping through a CUSIPs and pulling data from Bloomberg using pdblp

I have a list of CUSIPs that I would like gather data for using pdblp (https://matthewgilbert.github.io/pdblp/tutorial.html). For example: List of CUSIPs (around 5,000 in total): /cusip/xxxxxxxxx, /cusip/yyyyyyyyy ... con = pdblp.BCon(debug=False,…
n8erg8er
  • 25
  • 3
1
2