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
40 views

Download Curve in the past via TIA Bloomberg in Python

I am using TIA package in Python to download an interest rate curve. Using the following script I get the last curve. How do I specify a date in the past to have a curve in the past? ...
1
vote
0answers
24 views

Appropriateness of the Bloomberg CLO Cashflow Generator

Since CLOs seem to gain in popularity because of the COVID-19 crisis, I came across the possibility in Bloomberg to generate cashflows for newly issued CLOs through the function "weighted average ...
0
votes
0answers
36 views

How does Bloomberg calculate beta?

I tried manually calculating Bloomberg's historical beta based on the historical spread of SPY and equity price data, but I couldn't get the same result. I read somewhere that Bloomberg's default ...
0
votes
1answer
57 views

Populating price data from Bloomberg in Excel with BDH via macro not returning time series

Though issue has been addressed before on stackoverflow and reddit, I was not able to find any useful answers. I'm running a macro to populate price data with a macro via excel bloomberg API, say <...
0
votes
1answer
44 views

About BDP formula on getting Volatility of stocks from Bloomberg

I have tried VOLATILITY_90D to get the VOLATILITY of stocks from Bloomberg in excel. However, I found that I cannot get the VOLATILITY of some Stocks,such as 330 HK, 3800 HK. Could anyone help me to ...
1
vote
3answers
84 views

Where can one find implied OIS and Libor interest rates in Bloomberg?

I am struggling to find future interest rates for various tenors: **EUR: Eonia OIS rates: O/N (fixing), 1W, (2W), 1M, 3M, 6M, (9M), 12M Euribor rates: 1W, (2W), 1M, 3M, 6M, (9M), 12M, 18M, 2Y NOTE: ...
0
votes
0answers
64 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,...
0
votes
0answers
35 views

Bloomberg excel overrides

I'm looking to obtain SPX index quarterly returns for the past 10 years in Excel. I'm trying to use this BDP formula (=BDP("SPX Index", "CUST_TRR_RETURN_HOLDING_PER", "...
1
vote
0answers
40 views

Which is the “correct” 5Y5Y Inflation Expectation on Bloomberg, and what are the differences?

When the market talks about 5Y5Y expectation, is it referring to FWISUS55 Index, or G0169 5Y5Y BLC2 Curncy on Bloomberg? I ...
1
vote
0answers
98 views

How to connect Bloomberg's xbbp api to “Bloomberg Anywhere”

Due to COVID's remote work situation I found myself unable to access my physical terminal so I've had to use bloomberg anywhere (bba), the issue I'm having is that when I try to use python's xbbg on ...
2
votes
0answers
68 views

Why Bloomberg USD swap curve (YCSW0023 Index) changes last month?? and why put a Financial commodity future into this curve?

The Bloomberg USD swap curve (YCSW0023 Index) had changed and bloomberg put a Financial commodity future. Why changes? What the factor make this changes? Why bloomberg put into a financial commodity ...
1
vote
0answers
66 views

Download data from Bloomberg with R

I was trying to download daily data from a few tickers from Bloomberg with Rblpapi. I wanted all calendar data, not just trading days, but, when I put these options,...
0
votes
2answers
80 views

Bloomberg European equities tickers

I am trying to understand the abbreviations in the Bloomberg European stock or STOXX data. Each ticker represents company name abbreviation - Listed exchange. For example, CSP - LN is Countryside ...
3
votes
3answers
612 views

Python libraries for bloomberg?

I am very new with python, and I am used to work with bloomberg formulas for excel. I am starting to use a lot more python in my analysis, is there any library that performs same functions as bdp, bdh ...
1
vote
0answers
76 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
0
votes
0answers
40 views

Extract Accrued Interest in R using Bdlpapi package

I want to extract the accrrued interest of a bond in R using Rblpapi package, so my function is: bdp(securities = "CA135087D507@BGN Corp",fields = "INT_ACC", "SETTLE_DT=20200413") but this error is ...
0
votes
1answer
286 views

Pricing IRS: bootstrapping zero rate (spot rate) from the swap curve

I would like to ask about swap zero curve calculation algorithm used by Bloomberg. Below is a plain vanilla EUR IRS. I want to calculate >= 2 year spot rates from the market rates. I don't know how to ...
0
votes
1answer
176 views

Calculation of the Bid-Ask Spread on Bloomberg

I downloaded the bid-ask spread from Bloomberg, but did not check how they calculate them. Is it only the ask minus bid price or is it weighted in a way? I appreciate your help!
1
vote
1answer
259 views

why is ADBSC currency positive?

Hi guys I am new to cross currency. Could anyone explain why ADBSC <curncy> (Australian Dollar 3 month cross currency basis) in Bloomberg is always ...
0
votes
0answers
109 views

How can I download NYSE market capitalization by using Data Stream?

I am downloading the monthly New York Stock Exchange (NYSE), AMEX and NASDAQ's market capitalization between 31/12/1991 and 31/12/2019 on DataStream. Firstly, I tried to use both 'NYSE composite' and ...
0
votes
1answer
150 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
155 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
174 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
243 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
127 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
51 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 ...
1
vote
2answers
852 views

setting up bloomberg api for python [duplicate]

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 ...
1
vote
0answers
59 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
323 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
1k 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
203 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
60 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
77 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
5k 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 ...
1
vote
1answer
97 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
316 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 ...
2
votes
3answers
121 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
177 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
1k 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
2k 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
1answer
783 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
122 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 ...
1
vote
1answer
824 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
2k 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
3answers
1k 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
3k 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
74 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 ...
1
vote
0answers
53 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. ...
3
votes
3answers
238 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
85 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 ...