Questions tagged [bloomberg]

Bloomberg L.P. is a privately held financial software, data and media company headquartered in New York City.

46 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
64 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 ...
user avatar
  • 93
4 votes
2 answers
3k views

Bloomberg Ticker mapping with Reuters RIC

I am trying to map Bloomberg ticker into Reuters one. For example this one: EDZ3C 96.625 COMDT Few years ago aforementioned BBG ticker would be mapped to Reuters ...
user avatar
  • 41
3 votes
1 answer
10k views

Historical volatility on bloomberg API

Is there a way to obtain the historical volatility of a stock from the bloomberg API? I would be looking for the data in the HVT table. Actually 3-months historical volatility from now would be enough....
user avatar
  • 203
3 votes
0 answers
1k views

what is the definition of resetting tenor and time to maturity tenor in libor rates

I have a question about the definition and understanding of libor rates. We have the time to maturity tenor, $T$, which is the time over which i borrow or lend money. For libor we also have the reset ...
user avatar
  • 1,638
3 votes
1 answer
4k views

How to compute for basis adjusted forward rate?

To give you a brief background, I'm valuing a fixed-for-float Interest Rate Swap (IRS) using Bloomberg. I put in a notional amount in (USD) and a assigned 6MO USD LIBOR as the reference index for the ...
user avatar
2 votes
1 answer
202 views

Bloomberg - Index Constituents over a period of time

I basically require a list of the FTSE 350 constituents from 02 Jan 2002 (this is as far back as BB has for member data) to 31/12/2017. I tried to create this dataset using the spreadsheet builder ...
user avatar
2 votes
0 answers
74 views

Which financial database has the most extensive coverage of person-level data and uses person-level identifiers

For some empirical research, I need to retrieve data relating to the board members of companies corresponding to all securities in a major index. The data points I am looking for include gender, ...
user avatar
2 votes
0 answers
485 views

Can you tell me what this RBloomberg formula means?

I've been asked to re-create a spreadsheet that used RBloomberg using a different data source. But I'm having trouble figuring out exactly what one of the spreadsheet's formulas does. Can anyone tell ...
user avatar
1 vote
0 answers
41 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 ...
user avatar
  • 155
1 vote
0 answers
298 views

How Bloomberg calculates discount rates for zero rate curves?

I would like to ask about discount rates calculation algorithm by Bloomberg terminal. In the image above is possible to notice the discount rate for each term. The short end, instruments from 1 DY up ...
user avatar
1 vote
0 answers
42 views

Data on historical, cross-country REAL yield curves (i.e. inflation-linked bonds)

I asked here about data on a data source for historical yield curves for many countries. Many central banks (linked there, in Helin's answer) publish estimates for their nominal yield curves. But most ...
user avatar
  • 113
1 vote
0 answers
285 views

Bloomberg Excel API for Hourly Volume Data

I'm trying to download hourly trading volume data via the Bloomberg Excel API. For context, this is the formula I'm using, which pulls hourly trading data for Apple between Dec. 10, 2021 and Dec. 17, ...
user avatar
1 vote
0 answers
176 views

Replicating Bloomberg's zero rates bootstrapping

I'm interested in manually replicating the bootstrapping procedure that Bloomberg uses to built ICVS179 (RUB vs MosPrime 3M) curve up to a two years tenor as of October 12th 2021. These are the market ...
user avatar
  • 535
1 vote
0 answers
214 views

Is Total Return data for mutual funds on Bloomberg adjusted for fees/expense ratio?

I'm comparing the performance of mutual funds using monthly returns data from Bloomberg. I use the Day to Day Total Returns (Gross Dividends) field represented in Excel by ...
user avatar
  • 11
1 vote
0 answers
173 views

How to use quantlib Excel for valuation of european swaption with vol surface to calibrate?

I would like to replicate the following Bloomberg pricer in quantlib using Quantlib xl. Is it possible? Thanks
user avatar
1 vote
0 answers
445 views

Bloomberg SWPM Zero Rate Curve Conventions

Referencing : Bloomberg SWPM: Day count to calculate discount factor for US0003M Hi, I have a hard time reproducing the conversions between Discount factors and zero rates for an XCCY Swap I have ...
user avatar
1 vote
0 answers
323 views

Bloomberg Treasuries PX_Last and daily returns

I tried to search for this specific question, although I didn’t found a conclusive answer. I have a dataset containing the yields of several T-Bills and T-Notes that were downloaded from a Bloomberg ...
user avatar
  • 11
1 vote
0 answers
89 views

Bloomberg C# / CS.NET SDK for STDY Functions

I have downloaded and installed the CS.NET SDK from STDY. I have installed this as admin and had no problems with the install. However, when I open VS2017 (last version supported by BBG) I do not see ...
user avatar
  • 2,101
1 vote
0 answers
286 views

Collecting historical coupon data on sovereign generic bonds in Bloomberg

In the Bloomberg terminal, a generic bond (e.g. GGR >> Australia >> 5Y bond) has a coupon rate stated in the Security Description (DES). I have daily historical yield data for the generic bonds, and ...
user avatar
  • 113
1 vote
0 answers
5k views

Swaption : Bloomberg Black implied volatility quotes and pricing in the Black model

I used a lot Bloomberg's VCUB for data, but never used its integrated swaption pricer "Quick Pricer for Swaptions", nor Bloomberg's "full" swaption pricer from "SWPM -OV". I am retrospectively quite ...
user avatar
  • 1,162
1 vote
0 answers
97 views

Do Reuters or Eikon have intraday exchange rate data for minor currencies?

I need historical intraday exchange rate data (for a minor european currency - EURRSD) for my thesis. Not necessarily tick by tick - just prices at any interval below an hour will work. I guess there ...
user avatar
  • 131
1 vote
0 answers
42 views

Getbars for matured interest rate products

Using the getbars function from rblpapi package. Can you extract intraday data for a matured interest rate product? For example a German bubill The function works for interest rate products that are ...
user avatar
1 vote
0 answers
817 views

Bloomberg zero rate calculation using shift

I used Bloomberg to calculate a zero rate under a parallel shift of 100 basis points, however I can not understand the results neather duplicate them. I included the +100 basis points by using the ...
user avatar
  • 11
1 vote
0 answers
627 views

bloomberg api: how to handle the max 1000 requests limit

I am using the Bloomberg API in R (package Rblpapi) to find the nearby price at elevator locations for Soybean/Corn in given states in the US. I use the function lookupSecurity: ...
user avatar
  • 141
1 vote
0 answers
677 views

Commodity index member weights (historical) for S&P GSCI and BCOM

Does anyone know a datasource for retrieving the historical index member weights for the two major commodity indices S&P GSCI and Bloomberg Commodity Index? My institution provides access to ...
user avatar
  • 111
1 vote
0 answers
467 views

Does OpenFIGI have precanned files?

From what I understand, Bloomberg Open Symbology is now transitioning to OpenFigi: http://bsym.bloomberg.com/sym/ "BSYM.bloomberg.com will be SHUT-OFF on June 1st. It is being replaced by OpenFIGI....
user avatar
  • 111
1 vote
0 answers
197 views

Returning historical yield rates for Mortgage Backed Securities in a Bloomberg Terminal?

Forgive me if this isn't the right place, and direct me to the correct place to post. I've been trying to figure out how to get the yield rates for Mortgage Backed Securities (MBS's) in the United ...
user avatar
  • 11
1 vote
0 answers
3k views

Exporting Time Series Data For Securities Prices From Bloomberg to Excel

I have a list of securities over a thousand entries long that I want to construct a time series of prices for over a specified historical period (e.g. 2/01/10-2/20/10). Doing this manually would take ...
user avatar
  • 612
1 vote
0 answers
1k views

where to find historical option prices?

I have a dataset of options (traded in European exchanges such as NYSE Euronext) and I would like to find their price history. Where to find it? I see that ...
user avatar
1 vote
0 answers
117 views

Clarifying the way in counting number of weeks for calculating historical weekly volatility in Bloomberg

I would like to confirm the way to counting number of weeks for calculating historical weekly volatility in Bloomberg. Given an option with issue date from 14/1/2014 to 13/1/2019, is the proper way to ...
user avatar
  • 501
1 vote
1 answer
919 views

Which models do Bloomberg/Reuters use to derive implied volatility for interest rate derivatives with negative forward rates?

can anybody tell me which models Bloomberg and Reuters ares using to derive implied volatility for interest derivatives with negative forward rates? I know that Black-76 is the standard model, and ...
user avatar
  • 11
0 votes
0 answers
39 views

Is there a Bloomberg field for bonds that captures the coupon payment amount for a particular day?

For a bond, I want to know what the coupon payment amount would have been made (for today or any specific day) based on the payment schedule. Is there a bloomberg/bpipe field that would return that ...
user avatar
0 votes
0 answers
45 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 ...
user avatar
0 votes
1 answer
71 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 ...
user avatar
0 votes
0 answers
87 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 ...
user avatar
  • 93
0 votes
0 answers
50 views

Bloomberg / Norgate Historical S&P 500 Constituents/Universe

I am trying to get the daily S&P 500 constituents/universe from Bloomberg as I have been having trouble matching ticker names between Norgate and Bloomberg, meaning I need to use Bloomberg for all ...
user avatar
  • 13
0 votes
0 answers
315 views

Bloomberg OVML| FX option pricing | Python

Wanted to check if any API for python is available to replicate Bloomberg's OVML. The objective is to perform FX options pricing for multiple positions, and we are getting stuck in calculating ...
user avatar
0 votes
1 answer
203 views

Bloomberg: Get Historical Benchmarks

New on the terminal, was wondering if I could get some help. I am looking to find a time series for what the active benchmark was for a given tenor on the Canadian yield curve. I know that GTCAD5Y ...
user avatar
0 votes
0 answers
70 views

DI futures contract value on bloomberg

I am trying to understand the Contract value for DI1 futures on bloomberg. I assume the Price of 4.630 below is the CDI one day interest rate. Where does the Tick value of 9.6169 come from and how ...
user avatar
0 votes
0 answers
155 views

Help with aligning discount factors and forwards for Interest Rate Swap valuation using Quantlib

I am trying to price an IRS using Quantlib. As a natural benchmark for pricing, I use Bloombergs SWPM function. Before digging into the actual pricing, I want to see if my bootstrapping of the curves ...
user avatar
  • 151
0 votes
0 answers
66 views

Spread duration curve by issuer or by sector

I was surprised to see that spread duration was not offered as a curve in Bloomberg. As a result, I'm trying to find a curve (in Bloomberg) or build a curve (maybe using the Excel API) which ...
user avatar
  • 1
0 votes
0 answers
249 views

Fama-French factors creation using Bloomberg data

The standard FF factors as published by K. French (https://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html) are created using CRSP data. If one downloads the (US) factors, the first ...
user avatar
  • 243
0 votes
0 answers
83 views

reading a table of US treasury yields

I attached screenshot of US treasury yields from bloomberg today and try to understand it. A few questions are below, taking the example of 2-year bond: Is maturity exactly 2-year later today? If not,...
user avatar
  • 157
0 votes
0 answers
176 views

OHLC inconsistencies in bloomberg

This may be clear to a practitioner, but consider the following rows of OHLC points: 55.20 56.50 55.35 55.45 (low > open) 53.30 53.30 53.20 53.325 (close > high) These are taken from ...
user avatar
  • 503
0 votes
0 answers
70 views

BSE India best data source for foreigners (Bloomberg terminal?)

I'm looking for a best possible data source for BSE India realtime L2 data (at least 5 levels of book) equities only (F&O welcome, but not needed). I have an access to bloomberg terminal, have ...
user avatar
  • 201
-2 votes
2 answers
2k views

Bloomberg APIv3 Get reference data overrides

I have an Excel function that I want to move into Python. The BDP function is: =BDP("IBM US Equity","BEST_EBITDA","BEST_FPERIOD_OVERRIDE","1FY") ...
user avatar
  • 75