Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [bloomberg]

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

2
votes
1answer
2k 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 ...
2
votes
1answer
387 views

Rblpapi millisecond resolution

I'm using Rblapi to get tick data, using the nice getTicks function. Much to my dismay the index is rounded to the second, while milliseconds time stamp could be provided. Tried returnsAs xts, fts(?) ...
0
votes
1answer
247 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
3answers
77 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 ...
31
votes
11answers
86k views

Mapping symbols between tickers, Reuters RICs and Bloomberg tickers

Is there any known solution (preferably open source) to map between ticker symbols, Reuters and Bloomberg symbols. For example: Ticker: AAPL Reuters: AAPL.O (may be prefixed with RSF.ANY. dependent ...
5
votes
1answer
9k views

Bloomberg Currency Exchange Rate Data (London and New York)

I'm new to Bloomberg terminals (a paper I'm reading uses data from a terminal - my first exposure) and I'm having trouble figuring out how to download a few different time series: (1) daily closing ...
-1
votes
1answer
84 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
27 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
17 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
24 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
162 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 ...
0
votes
0answers
25 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? ...
-1
votes
4answers
1k views

How to download bloomberg intraday data efficiently with API

so I would download a bunch of intraday data, for a bunch of securities, but we keep hitting our monthly cap limit. We don't want to upgrade to a more expensive package as this is simply a research ...
0
votes
1answer
719 views

Pulling portfolio from bloomberg

I am not sure wether I should post this question here or on stack overflow, but I'll give it a shot anyway. I am trying to get my portfolio from PORT in bloomberg. Basically I am trying to automate a ...
1
vote
0answers
43 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
28 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 ...
2
votes
1answer
131 views

Sovereign bond CDS data

Does anyone know where I can download from historical data for sovereign bond CDS (credit default swaps) rates? preferebly free?
1
vote
1answer
113 views

CDS Spread sensitivity

I am computing HVaR for corporate bonds using CDS spread to approach credit risk. I have data on cds spread for different maturities along the bond life and I need the sensitivity to spread change for ...
-1
votes
1answer
361 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 ...
0
votes
0answers
40 views

Best database source to download large number of stock prices [duplicate]

I am wondering what databases exists where I can download stock prices from 2006 to today with the following features 1) using Python API 2) using Bloomberg tickers (e.g. AAPL US Equity) 3) free ...
-2
votes
2answers
39 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 ...
0
votes
1answer
74 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 ...
0
votes
1answer
77 views

bds with field in R returning error

I am using Rblpapi and trying to query the following: bds("FN1 Comdty","FUT_CHAIN", overrides = "CHAIN_DATE=20170101") However, I am getting the following error:...
0
votes
1answer
182 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 ...
1
vote
1answer
375 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
120 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: ...
0
votes
1answer
729 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
1answer
711 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") ...
-1
votes
1answer
85 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 ...
2
votes
0answers
102 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
73 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
234 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? ...
5
votes
2answers
28k views
0
votes
1answer
3k views

Bloomberg formula for bond total return

Do you know a bloomberg excel formula to retrieve the dayly total return of a bond over a period? By total return I mean : (change in price + coupon)/initial price Same as for a stock but with ...
1
vote
0answers
506 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 ...
3
votes
1answer
554 views

Garman-Kohlhagen (Black-Scholes) Formula vs. Bloomberg OVML Calculator

I'm trying to price a European call option on USDJPY. We have that $S = 112.79, K = 112.24, \sigma = 6.887\%, r_d = 1.422\%, r_f = -0.519\%, T = 0.25$. My model, based on Black-Scholes, returns the ...
0
votes
1answer
922 views

Generic bond yields

I was looking on historical sovereign bond yields for a project. I was wondering what is meant by "generic bond yields" mentioned on bloomberg. Somewhere else i found data about the same country but ...
2
votes
1answer
496 views

Bloomberg Python Question - How do you access PRTU via python?

I am having some trouble using python to access Bloomberg as I cant find much documentation. All I really need to do is a simple lookup of dates in the PRTU function of Bloomberg, PRTU via a python ...
1
vote
0answers
350 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: ...
2
votes
2answers
3k views

Getting Index constituents along with returns from Bloomberg

I am interested in getting constituents of an index along with individual stock returns on a 1m,1y, 5y basis through bloomberg terminal as well as through api. Do we have a single command which can ...
0
votes
3answers
676 views

Alternative to Bloomberg Excel Add-In for EOD Stock Prices

Is there a more cost-effective alternative to Bloomberg Excel Add-In? 90% of the time I only use Bloomberg to download security (hundreds of U.S. and international stocks) historical price data. The ...
1
vote
1answer
3k views

What is the EUR swap curve on Bloomberg? I.e. what is the EUR equivalent of S23 curve on Bloomberg?

I am trying to understand the currency basis calculation and whether there is a difference in currency basis when quoted vs. OIS and -IBOR rates.
0
votes
1answer
884 views
2
votes
2answers
496 views

Database of ETF and underlying index from Thomson Reuters or Bloomberg

I want to generate a table of ETFs listed in the US and declared benchmarks. The idea is that I want to have the possibility to use the benchmark as a proxy of the ETF to run longer backtests when ...
0
votes
1answer
288 views

Where can I find historical daily term repo data?

DTCC appears to provide historical o/n repo data for US Treasuries but does not do so for term repo data. If I want to analyze the term repo curve, where would I be able to find historical term repo ...
7
votes
5answers
6k views

Monthly data for popular indices (constituents).

Trying to be concise: I am interested in the most popular indices (SP500, FTSE100, DAX30, CAC40, SMI30, etc). For each index I want to know its constituents in a monthly basis. For each constituent (...
0
votes
2answers
3k views

EUR Implied Forward Rate from Bloomberg

does anyone know about the EUR Forward Implied 3 Month Rate published by Bloomberg on the Bloomberg Page EURI3M ? First question: this is the rate from a forward curved, forward curve being ...
0
votes
0answers
53 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 ...
0
votes
1answer
10k views

Price at Specific Time from Bloomberg

I have a file where I easily export real-time prices to excel using the Bloomberg Add-In, using the formula BDP. Is there a way to get these prices of a specific time? For example, =BDP("EURGBP ...
1
vote
1answer
504 views

Instantaneous Forward Rate from Bloomberg

I am calibrating the Hull-White model which involves finding the level of mean-reversion from the market instantaneous forward rate? Is the market instantaneous forward rate directly available from ...