Questions tagged [bloomberg]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
79 views

Bloomberg: fetching returns based on identifiers

I have a list of about 8000 global companies identified using SEDOL identifiers and tickers (for whatever exchanges the companies are listed). I need to retrieve data about these for a regression, ...
1
vote
1answer
47 views

Bloomberg code for last trade price before the closing auction

I would like to run a study on stock prices before the closing auction. I would like the study to look at prices once a day for each stock. I do not currently have access to a Bloomberg terminal so ...
1
vote
0answers
37 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 ...
4
votes
2answers
164 views

Correlation Gold and SPX in BBG

I was always under the impression that gold as a safe haven was more or less inversely correlated to the general market. After using the HRA function in Bloomberg I saw that the correlation is just -...
1
vote
0answers
52 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 ...
1
vote
1answer
37 views

Confusion about bid- ask- and last-prices from option prices data

I’m struggling with the interpretation of quoted option prices I obtained from Bloomberg. The call options prices are available for a daily time series with different strikes at a given day. I ...
0
votes
0answers
29 views

Why TAS contract for CME gold futures expires earlier than the CME gold futures?

As you see in Bloomberg, the TAS(Traded at Settlement) contract for CME gold(for e.g. TASZ9 COMDTY) expires in 26/11/19. Whereas CME Gold(e.g. GCZ9 COMDTY) expires in 27/12/19. Why is this so?
0
votes
1answer
144 views

setting up bloomberg api for python

I am trying to configure bloomberg api in python. I have used pip to install the api, i also downloaded the BloombergWindowsSDK. I am not sure where to go from here. Can i please get a step by step ...
0
votes
0answers
38 views

Bloomberg - retrieving historical index values

I am looking at a Bloomberg index which goes out into the future (i.e. a mix of past realizations and future projections) - WNDFTTDE Index (Past and future wind capacity in Germany). While this ...
1
vote
0answers
46 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 ...
1
vote
1answer
83 views

Find Interest Rate Swap BUMPs from Bloomberg in Excel

I have a bunch of plain vanilla interest rate swap contracts with all the relevant details regarding payment structure such as notional, fixed rate, index, payment frequency, reset convention, etc.. ...
4
votes
1answer
200 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 ...
1
vote
0answers
77 views

Extract list of tickers bloomberg api [closed]

Does anyone know what is the python equivalent to the BQL.Query/BSRCH functions from the Excel API? I am essentially trying to get a list of tickers for all government bonds from a certain country ...
1
vote
0answers
57 views

How can I get real-time CDOR rate, swaps, and options pricing data refreshed on a daily basis in Excel?

I'm currently using "Bloomberg Anywhere", which is the same as Bloomberg Terminal except account-specific rather than PC/hardware-specific. I currently have to refresh the rates every morning at ...
2
votes
0answers
59 views

Valuing TRYUSD currency swap on Bloomberg

Usually a leg in a swap is discounted using the corresponding OIS curve if the deal is collateralized and if collateral is posted in a different currency teh discounting happens with the corresponding ...
2
votes
4answers
965 views

Px last in Bloomberg

This is my first post to this forum. I want to calculate security returns , so therefore, I have downloaded the PX last price from Bloomberg. My question is: What is PX last in Bloomberg? Is this ...
0
votes
0answers
22 views

Getting index sectors historical weightings from Bloomberg using python

I want to know how to download an index sectors' historical weightings from Bloomberg. For example, S&P 500 is comprised of Telecom Svc, Materials, Utilities, Energy, Consumer Staples, ...
1
vote
1answer
82 views

Availability of GC Repo Rates for Different Maturities

I am trying to replicate a Covered Interest Rate Parity arbitrage trade using General Collateral Repo rates for my Bachelor Thesis. My problem is that I do not have the necessary knowledge of what ...
0
votes
1answer
186 views

Do quants need to know bloomberg terminal and VBA? [closed]

I am a Pure Maths PhD student who will graduate in 2 years time. My aim is to land a quant job after gradauation. When collecting more information so that I can have some edges over others, I heard ...
1
vote
2answers
85 views

How do I derive a blend of a 3Y future and 10Y future risk?

So I have a portfolio of Govt. bonds that I'm trying to hedge with futures. Let's take one of the bonds out of the portfolio as an example. In bloomberg, every bond and its future counterparts has a ...
2
votes
1answer
93 views

Understanding VWAP and DMA in EMSX Bloomberg

I'm trying to better understand the difference between the VWAP and DMA Strategies in Bloomberg through the EMSX function. As far as I understand is putting orders in Direct market access(DMA) a way ...
1
vote
3answers
427 views

Interpolating the swap curve

Does anyone know how I can calculate the swap rate in between main tenors for specific dates? For example: what is the implied swap rate in 1 year, 60 days time. Is there an easy way to do this in ...
0
votes
1answer
572 views

What is Yield To Convention?

I know what gross redemption yield of a bond is. I am unaware of "Yield To Convention". It is a Bloomberg ticker code (multiple in fact) YLD_CNV_MID, YLD_CNV_ASK & YLD_CNV_BID The term "Last ...
0
votes
0answers
400 views

Mark-to-market cross-currency basis swap valuation

I'm looking to replicate the EUR vs USD cross-currency basis curve that Bloomberg outputs (EUR.OIS collateralized in USD). I understand that Bloomberg is currently using the mark-to-market ...
1
vote
0answers
43 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 ...
0
votes
0answers
179 views

Option Prices on Thomson Reuters Eikon Database

I would like to get hist. option prices from Eikon. I am not looking for the entire option chain and I was wondering if Eikon offers average data/prices. Average European call and put option prices ...
1
vote
1answer
366 views

Swaption valuation across time using vcub

On Bloomberg one has access to the rates vol cube with the VCUB function. For a given currency, today, one sees Black implied volatilities for swaptions of various expiries and strikes, for forward ...
0
votes
0answers
876 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 ...
0
votes
0answers
39 views

How to retrieve greeks and IVOL historically for listed options (using Bloomberg)?

Is there a way to get Prices, IVOL and greeks on historic option contracts (eg on the underlying RXM15) on Bloomberg, and follow this particular option with Strike K throughout its lifetime (eg on ...
0
votes
3answers
326 views

Definition of the field YAS_RISK for bonds on Bloomberg terminal

The Bloomberg terminal has the following definition for the field YAS_RISK (SP190): "Indicates the price sensitivity given shifts in interest rates." It does not specify, however, what currency is ...
-1
votes
1answer
1k views

How to get historical daily index values from Bloomberg Terminal?

I found a lot of questions asking about index returns and index constituents, however, i'm looking for just daily closing values for certain Total Return indices. (FTSE/MSCI/BBBarclays) - these are ...
1
vote
0answers
60 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 ...
0
votes
0answers
24 views

Termstrc data preparation from Bloomberg terminal

I am trying to use the R package termstrc to estimate yield curves for the Czech Republic. I have found the structure of the required class ...
1
vote
0answers
36 views

Extract historic share prices for certain securities at certain points in time with Bloomberg Excel Add-in? [closed]

In order to create some sort of basic framework for everything we are planning on doing in a research project, we would need to get historic intraday data about share prices at certain points in time. ...
0
votes
0answers
26 views

city level data in bloomberg

Does bloomberg terminal provide economic information on the city level such as GDP, etc for countries other than us? If yes, just can I use the GDP function or there are other available functions? ...
3
votes
3answers
205 views

Risk-neutral density from spot prices?

I am currently working on a university project and I hope someone can help me out with a rather silly question :-) I want to analyse the change in the shape of risk-neutral density functions of spot ...
1
vote
0answers
61 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 ...
1
vote
0answers
33 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 ...
-1
votes
1answer
1k views

Bloomberg SWPM: Day count to calculate discount factor for US0003M

I'm trying to replicate price I get for CCIRS in SWPM. This is USD3m float vs RUB 1Y. Second leg doesn't matter for my question. Suppose today is 7th of Jan 2019, deal date. Settlement will happen on ...
-2
votes
2answers
47 views

Search for all bond with particualar fields in bbg terminal [closed]

Is it possible to get list of e.g. bonds from bbg terminal with some particular fields. Example: Can I get list of all bond which has some particular day count convention, some frequency, a long ...
1
vote
1answer
546 views

Vol surface from Bloomberg API

Can someone tell me if it's possible to retrieve vol surface for different underlyings through the Bloomberg Open API (or else) for free or almost ? I precise that I have a BBG terminal so I have an ...
0
votes
1answer
296 views

Bloomberg's Open Market Data Initiative

I am reading about OMDI: https://www.bloomberg.com/company/announcements/bloomberg-opens-its-data-distribution-technology/ After reading that, I am still not sure: Is it free? If so, what kind of ...
0
votes
1answer
115 views

CNY IRS Fixed Vs 3 Month SHIBOR. Can any one please confirm the curve practices ?

AM trying to match CNY Swap Curve with Bloomberg. Yields unto 9 months can be converted to dfs using 1/(1+rt), where t = Actual Number of Days / 360. One year and boot strapping method was used with ...
1
vote
1answer
700 views

Using Bloomberg API on Excel to find a stock ticker change/acquisition

I am wondering if there is a way in Excel, using Bloomberg API, to find if tickers have changed or acquired by other firms. For example, given these values, ...
0
votes
1answer
225 views

Why is the number of accrued days equal to one on coupon dates for NL/365?

Accrued day should be zero on coupon dates. This is true for all day count conventions. However, I found that Bloomberg returns 1 accrued day on coupon dates only for NL/365 day count. Bond example: ...
-1
votes
1answer
195 views

How to compare bonds in terms of volume traded in Bloomberg Excel Add-in?

I want to compare how much bonds of a handful of companies have been traded over the last years and pick the most traded bond for each company via the Excel add-in. One example of what I have tried ...
0
votes
1answer
1k views

Bootstrap daily OIS forward rate

Can someone please show me how to derive the daily OIS forward rate in a OIS-fixed rate swap? For example, if price a paying fixed rate/receiving OIS swap in Bloomberg SWPM, Bloomberg will be able ...
2
votes
0answers
113 views

Chat bot for traders [closed]

In the framework of my internship at a bank, I want to write a chat bot program in Python that allows our bond traders via their Bloomberg terminal chat box application to type in structured command ...
0
votes
0answers
115 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 ...
-1
votes
1answer
380 views

(Bloomberg) BDP Formula question [closed]

Good Morning, I am using the below formula and need some help, how do I change the below strike price (400) to pull from a separate cell (T2) I have on the spreadsheet? ...