Questions tagged [bloomberg]
Bloomberg L.P. is a privately held financial software, data and media company headquartered in New York City.
247
questions
0
votes
0
answers
35
views
Problem with BDH function in Excel/Bloomberg [closed]
I have a simple BDH function drawing time series into Excel. Whenever i change a field, it twitches, as if accepting the change and then reverts back to the old inputs. Eg if i use start date 31/12/...
0
votes
0
answers
44
views
Matching of Symbols from Bloomberg and refinitiv , for OTC derivatives trade clearing
I have been researching on this Scenario , since few days : -
Actually I have scenario , where we are dealing with OTC derivatives and BUY/SELL order can be punched in on different systems like Buy ...
- 1
3
votes
0
answers
137
views
Is Bloomberg's global equity data sufficiently high quality that it can be used for backtests?
I have used other data sources like CIQ, CRSP / Compustat, and Refinitiv. While each has issues, the data were sufficiently high quality that reasonably reliable backtests could be run. I may need to ...
- 131
0
votes
1
answer
101
views
What is "position" when referring to the holders of a bond?
A bond has a "holders" list, available on Bloomberg. I can see "held amount" of each party in USD, but what is the meaning of "position"? Is it a USD value (if you ...
- 101
0
votes
0
answers
62
views
Creating a Bloomberg bquant portfolio
As an ex-investment banker (salesperson to be specific) and amateur programmer, I’d like to move into quant work.
I’d like to create a coding portfolio using Bloomberg’s bquant, but as I’ve left the ...
- 1
0
votes
0
answers
94
views
How do I get the maturity date of an OIS with the Bloomberg Excel add-in?
I have an Excel sheet where I want USD OIS rates for tenors between 1 week and 1 year, as well as the maturity date of the swap as of 13/09/2018. Below picture shows what I currently have.
Column C ...
0
votes
1
answer
322
views
How does Bloomberg compute the cross currency swap basis?
First, look at the FXFA for EURUSD
The EUR and USD Yield & FX swap rate on 10/18/2023 are given as:
The computations are shown in this answer.
........................................................
- 115
1
vote
2
answers
603
views
How to Bloomberg compute the implied Yield ? What is FX swap basis spread?
Question 1:
You can see Bloomberg EUR/USD FXFA<go> page attached below
EUR 3 months yield=3.9412
US 3 months yield= 5.6683
Spot Rate: 1.0580
How does it find FX swap rate as 1.062732?
Question ...
- 115
0
votes
1
answer
70
views
Difference between two Bloomberg codes SIX Market
23
Bloomberg always have two codes for the same instruments. For example, for CIE CIE FINANCIERE
RICHEMO, Bloomberg has CFR SE and CFR SW.
I am wondering what is the difference between these two codes?...
0
votes
0
answers
106
views
Intraday Data Frequency for Bid and Ask Prices vs Trade Prices
When performing the following BDH query for a particular stock:
=BDH("AT0000652011 ISIN","LAST_PRICE","1/3/2023 0:00:00AM","1/9/2023 0:00:00AM","BarTp=B&...
- 559
0
votes
0
answers
35
views
How to compute Bloomberg T-Bill yield in BXT? [duplicate]
could any kind soul explain how are the Discount and Yield computed? Also, do they refer to “Discount Yield (daycount Act/360)” and “Yield (daycount Act/365)” respectively? Thank you!
2
votes
0
answers
41
views
CDS data for different industries/rating? [duplicate]
I have come across below CDS data (index values) based on different Rating, Industries, and Regions,
I am wondering where can I get more complete data i.e. such ...
- 41
0
votes
1
answer
190
views
Calculating the Delta of FX option
I'm tying to reconcile the delta value for an FX option. I'm comparing the results to Bloomberg to verify our calculation is correct.
I've looked at this - Quantlib: Greeks of FX option in Python but ...
2
votes
1
answer
384
views
How does Bloomberg use the OIS curve to get the zero rates?
I'm trying to reproduce the zero rates using the market rates, but I have not been able to. I read the Bloomberg's "Building the Interest Rate Curve" paper and followed the formulas exactly ...
0
votes
0
answers
236
views
Building a forward curve for multiple tenors - Quantlib python
I am attempting to build a forward curve for multiple tenors (1M / 3M / 6M / 12M) using the quantlib library. The input to my model are sofr swaps(1W through 50Y). It appears I am building my curve ...
1
vote
1
answer
200
views
What could the cashflows of US0SFR1Z Curncy be?
So this "SOFR vs fixed" swap has a fixed leg paying 5.231% yearly and a floating leg paying yearly the yearly compounded SOFR rate, and has a 1W term. If it has started today, it won't have ...
- 231
1
vote
1
answer
158
views
Bloomberg FXFM: what is the point of knowing risk neutral probabilities?
Among other things, Bloomberg FXFM function allows you to check risk neutral probabilities for currencies. For instance, you can check the probability of the euro depreciating 5% vs the dollar in 6 ...
- 45
0
votes
2
answers
100
views
Bloomberg access from publishing platforms such as Posit Connect
It is easy to download Bloomberg data in Python or R using their blpapi API. The only requirement is that one is logged on the local Bloomberg terminal.
We often find ourselves working on publishing ...
- 101
0
votes
0
answers
51
views
Difference in Bloomberg and I/B/E/S earnings data
I‘m looking at monthly 12-months trailing earnings for the S&P 500 Index since 1995. Index level earnings, not individual constituents.
I got the earnings time series for the index from Bloomberg ...
- 1
1
vote
0
answers
172
views
Why is Bloomberg showing difference yields than US Dept of Treasury
I am using historical 30yr US treasury rates for a project. When I downloaded the rates from Bloomberg by queuing the history of the USGG30YR index, I found the numbers different from what US ...
- 31
0
votes
0
answers
285
views
Bloomberg BQNT vs Dektop API
I am currently looking at alternatives to the Bloomberg Desktop API as I frequently reach the daily or even monthly data limit. One alternative which was proposed to me was switching from a desktop ...
- 1
0
votes
0
answers
625
views
Bloomberg field name to get implied volatility of options
I am trying to get option data from bloomberg api. I got the all available options on a given underlying eg:"ASML NA" and Field "PX_LAST" gave the last traded price for each option....
3
votes
1
answer
601
views
Is LEI and Bloomberg Ticker one to one mapping. How about LEI, Bloomberg Ticker, Bloomberg ID, ISIN and CUSIP?
I am working on a project and need to map different IDs. Is LEI and Bloomberg Ticker one to one mapping? I can use Bloomberg formular =BDP(A1,"LEGAL_ENTITY_IDENTIFIER") to convert ticker &...
- 31
0
votes
1
answer
256
views
Risk-free yield curve creation for Euro
I'm working on a Interes Rate Risk in Banking Book model for EVE calculation. It doesn't matter if you know what it is or not, I just need help with one step. That step is the creation of risk free ...
- 13
1
vote
0
answers
382
views
Historical data on Credit default swap
I am aware that there is an active CDS market for insurance from US sovereign default (in terms of treasury bond) as Dimitri Vulis
commented. I am looking for the ...
- 11
1
vote
1
answer
895
views
Intraday (non-tick) Historical Data - Bloomberg Python API
Is it possible to get hourly or minute-by-minute data (in the form of a dataframe) in Python using one of the API wrappers (xbbg or ...
- 151
2
votes
1
answer
1k
views
Bloomberg FWCM vs FWCV
I'm helping my team to project 90-day T-bill forward rates. I have two options: using FWCM or FWCV in Bloomberg. My team has used FWCM. Today I opened FWCV and found that the rates for the same curve (...
- 31
4
votes
1
answer
280
views
FX-swap market convention question for o/n
Can someone enlighten me regarding the market convention for quoting an overnight fx swap where one leg is USD and today is a USD-holiday (but not a holiday in the other currency)? An example is ...
- 91
-2
votes
1
answer
1k
views
How does bloomberg calculate the discount rate from EUR estr curve? [closed]
I'm currently reading bloomberg's paper "Building the Bloomberg Interest Rate Curve – Definitions
and Methodology." but I cannot rederive the discount rates even for the most simple terms.
I ...
- 3
2
votes
1
answer
391
views
How does Bloomberg calculate the 2 year swap rate using the current eurodollar futures prices? [closed]
I am getting hung up on the front and back stub periods and convexity adjustment. I've read a ton of similar posts but so far have not been able to tie out to this 2 Yr rate exactly. Any help is ...
- 21
0
votes
0
answers
46
views
Formula to convert Bloomber ticker to ISIN, RIC or Factset ticker [duplicate]
I want to convert Bloomberg tickers (for equities) that to either of ISIN, CUSIP, RIC, Datastream code or Factset Ticker. I don't have access to Bloomberg but say if I just want to convert Bloomberg ...
1
vote
1
answer
2k
views
What is the difference between Discount Yield and Yield on US Treasury Bills
I would like to understand the fundamental difference between yield and discount yield, specifically relating it to zero coupon treasury bills.
Please see image below:
For those who are terminal ...
- 31
0
votes
0
answers
104
views
Adjusted beta for short positions, should we re-adjust the formula?
I see in BBG that the beta of XSPS (an inverse SP500 ETF) to SPX Index is -1.05 and the adjusted beta is -0.37.
I get that -1.05 * 2/3 + 0.33 matches the adjusted beta. However, does this adjusted ...
- 527
2
votes
1
answer
437
views
FX Option Vol Quotes (Days or Days+Time to Expiry)
I understand FX Options are often quoted via ATM, RR, BF for 10/25 deltas. There are many resources that outline how to convert those quotes back into absolute strike space (using spot delta or ...
- 1,192
1
vote
1
answer
508
views
How does Bloomberg bootstrap CASH Instruments?
Given the following datas :
If we do the bootstrap methodology for CASH Instrument we gotta :
Calculate the DF associated to the Market Quoted Rate (2.91157). For the 3M Fixing we have :
T = 0.26115.
...
- 333
1
vote
1
answer
425
views
BLOOMBERG Strike vs Straddle Volatility
In Bloomberg's VCUB, what is the difference between the "strike" volatility and changing this option to "straddle"? It seems like the "straddle" vol should be the same as ...
- 11
3
votes
1
answer
384
views
Question about swaption premium quote on the bloomberg terminal
This is my first question here and I hope that my question is appropriate.
I have some data about swaptions that are from the bloomberg terminal and basically I am performing a risk-neutral ...
1
vote
2
answers
2k
views
How do you extract only prices for an index from Bloomberg?
I’m trying to get data from an index on Bloomberg terminal into excel with BDH command. Specifically I am trying to get all of the closing prices for each company in the Russell 2000 index for every ...
2
votes
2
answers
948
views
Understanding FX forward points and market usage
I've been trying to make sense of how the FX forward market works.
Let's say today is June 13, 2022. And we have the next market info as seen in Bloomberg for the FX cross between USDMXN, assuming mid ...
- 282
0
votes
1
answer
647
views
Trying to check this 1Y1Y forward treasuries calculation
here is a screenshot of the FWCM screen on Bloomberg:
https://i.stack.imgur.com/2BT3y.jpg
I'm trying to check that I understand this by calculating the 1Y1Y which according to this matrix is 3.6877%.
...
- 119
4
votes
0
answers
92
views
Level 1 NBBO - what is going on?
Looking at some level 1 quotes data (QRM) on the bloomberg terminal for a DAX index option. Why is there always a 1 lot quote for 450 just popping in every other tick? Seems like there is a single MM ...
- 93
4
votes
1
answer
407
views
API for Commodities Stock markets
I would like to have a clear picture about lithium investments all over the World.
I like this website where I can see all companies related to lithium on the Australian Market.
The website also ...
1
vote
1
answer
522
views
Bloomberg DLIB BLAN in Python
The title describes the question. Below provides more details. Kindly let me know how industry is working on this.
I am a heavy user of Bloomberg excel API, including WAPI and DTK (formula such as ...
- 11
0
votes
0
answers
460
views
Bloomberg, historical intraday government bond data
I would like to get 10Y and 5Y intraday historical government bond prices (best bid and ask) for different countries. I thought that I have found a solution on Bloomberg, but there are some issues.
I ...
- 43
-1
votes
1
answer
155
views
Model-Free Implied Volatility: Data of Expired Options and Bond Price
I am attempting to calculate Model-Free Implied Volatility for several equity indices (S&P500, NASDAQ100, CAC40, FTSE100, DJIA, EUROSTOXX50, NIKKEI225, NIFTY50). I wish to get historical data of ...
0
votes
3
answers
1k
views
Fixed vs float swap interest rate risk
I have some technical questions about what are the best settings in Bloomberg to calculate the interest rate risk of a swap.
When Bloomberg calculates the DV01, it simply bumps the par swap curve by +/...
- 29
0
votes
0
answers
134
views
Put call parity with real time tick data
I am working with some real time options tick data (mainly futures options and index options), and in many cases the quotes are single sided (as seen on bloomberg terminal). I will denote a quote as ...
- 93
3
votes
1
answer
1k
views
Quantlib: day-by-day evaluation of option value
I'm using Quantlib in Python to price an FX option. I'm comparing the result to Bloomberg, to make sure the code is working correct.
I want to calculate the P&L of a certain option trading ...
- 105
4
votes
1
answer
3k
views
Quantlib: Greeks of FX option in Python
I'm using Quantlib in Python to price an FX option.
I'm comparing the result to Bloomberg, to make sure the code is working correct.
I also want to calculate all the Greeks, and eventually use those ...
- 105
1
vote
0
answers
53
views
Downloaded data is quote-driven or order-driven?
I downloaded data from Refinitiv Datastream (But I think that you get the same data from Bloomberg) to write my thesis. I downloaded prices and volumes.
I have a crucial question now: Are the prices ...
- 165