Questions tagged [bloomberg]

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

31
votes
11answers
87k 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 ...
15
votes
1answer
16k views

Difference between the two Bloomberg codes

Bloomberg always have two codes for the same instruments. For example, for Apple, Bloomberg has AAPL US and AAPL UW. I am wondering what is the difference between these two codes? As far as I can ...
13
votes
1answer
684 views

What time are Bloomberg Open Symbology Files updated daily?

Does anyone know what time the Bloomberg Open Symbology precanned files are updated every day? I am planning on upating my view of them at 9 AM EST every morning. Furthermore, will the files for ...
8
votes
5answers
5k views

Technology stack used in Bloomberg

I figure this perhaps the best place to ask this. What technology stack is used in Bloomberg? I'm C++ developer, and I definitely prefer C++ to C, so I don't want to touch C unless it's strictly ...
8
votes
2answers
12k views

Market Data Sources Bloomberg Vs Reuter

In my project, we have two version of systems. One version is for derivative trades and other version is for bond trades.For derivatives we get the market data from Reuters and for Bonds we are ...
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 (...
6
votes
5answers
2k views

Bloomberg alternatives for fixed income data

I am looking for a (hopefully significantly cheaper) alternative to bloomberg - primarily for fixed income data. Perhaps some survice that has a more modular fee structure (so that I only have to pay ...
6
votes
2answers
28k views

What does the prefix PX stand for on a Bloomberg Terminal?

Regarding PX_LAST, PX_VOLUME etc... What does the "PX" prefix stand for?
5
votes
2answers
1k views

Bloomberg implied volatility smile for equities

I was wondering if someone knows how Bloomberg does their computations for the implied volatility smile for equities. As far as I understand, they use a lognormal mixture to model the stock prices. ...
5
votes
1answer
1k views

comparing total returns from various data vendors

I need to use various data sources to cover all of my data, and I am concerned by the discrepancies in total returns. Data vendors were helpful, but their simple documentation did not help resolve why ...
5
votes
1answer
474 views

Bloomberg & R: Accessing multiple securities with getBars() in R

I am attempting to access 1 minute trade data for 50 securities using Bloomberg API (rblpapi). Following is the code I got from the CRAN: ...
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 ...
5
votes
1answer
262 views

Equivalency of FX forwards and FX fixed for fixed swaps? Are they still the same under multiple curves environment?

I am encountering two approaches for valuation of FX swaps (fixed for fixed, e.g. fixed USD payments for fixed EUR payments) which seem to result into different values although in theory they should ...
5
votes
1answer
801 views

Is there a Bloomberg field for the first trading date after an event?

For example, if a company reports earnings today after the close (6/24), the earnings date would be 6/24 but the field I'm looking for would be 6/25. If they reported tomorrow before the open, both ...
4
votes
2answers
19k views

How can I export intraday frequency data from Bloomberg and (how) is this procedure different than for lower frequencies?

For a research project, I would like to work with some intraday asset prices. I have already successfully exported the corresponding data at daily frequency, using the Excel API, but somehow this ...
4
votes
3answers
5k views

How do I calculate approximate equity liquidity?

I am a developer rather than a quant. I need to decide whether a given equity passes some basic liquidity threshold. It doesn't have to be precise, just good enough. I have a Bloomberg terminal data ...
4
votes
1answer
557 views

Why does Bloomberg's HRH test the simple returns for normality?

On a Bloomberg terminal, it is possible to use the HRH (Historical Return Histogram) function on individual assets. It basically generates a histogram of the (simple) returns and overlays them with a ...
4
votes
1answer
145 views

Vendor data aggregation for Options on Futures

Have anyone managed to automate data consolidation between Reuters and Bloomberg for Options on Futures? Are there any common attributes that these vendors share in this particular asset class that ...
4
votes
1answer
765 views

Obtaining logical lists of Bloomberg security codes in Excel

I am using Bloomberg's BDP and BDH functions in excel to retrieve data for a set of options. The problem is that (as underlying prices move and expiration dates come and go) option strikes are ...
4
votes
1answer
1k views

Incoherence in Bloomberg Data in Swap Curve Builder (ICSV)

When working on calibration for LMM model, we need to have Initial Libor quotes and Swaptions Black vol quotes on the market data. We have data provided by Bloomberg. However, before performing the ...
4
votes
3answers
6k views

Bloomberg interest rate interpolation

I have question about the linear interpolation of interest rates. I am unable to reconcile the Bloomberg methodology for calculating risk-free rate between maturities. In theory it is a straight-line ...
3
votes
1answer
2k views

Bloomberg data redistribution policy

I've looked through the Bloomberg website, but haven't found any information about available license plans. I'm curious whether it provides any license that allows you to re-distribute data requested ...
3
votes
3answers
163 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 ...
3
votes
3answers
2k views

Deposit vs. LIBOR rates? (Bloomberg/SuperDerivatives)

I noticed that Bloomberg and SuperDerivatives both use "Deposit Rates" for the calculation of forward points for currencies. I couldn't find anything online that describes precisely where these rates ...
3
votes
2answers
1k views

How to calculate conversion parity for convertible bond?

Can someone explain how can I calculate the parity of this convertible bond? I know the formula is Current price of common stock x Conversion Ratio, but it doesn't seem to be right in this picture.
3
votes
1answer
675 views

Export security description data from bloomberg into excel

I have the cusip of about 300 bonds. I want to retrieve the security description from bloomberg and then export it into excel. Does anyone have any tips as to how to accomplish this?
3
votes
1answer
581 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 ...
3
votes
1answer
112 views

What approaches are there for keeping local and remote order books in sync?

Scenario: developing a custom application which defines a structured workflow for manual order submission to Bloomberg EMSX; it should minimize own persisted state and rely on the remote order book as ...
3
votes
1answer
269 views

What is the benefit of having proximity to the Bloomberg datacenter?

I own and operate a datacenter adjacent to Bloombergs Datacenter in Orangeburg NY. We have had a couple of trading firms come to us due to our proximity to Bloomberg to receive "data" from them ...
3
votes
3answers
3k views

Batch-downloading Bloomberg data into Excel

My company has Bloomberg terminal, but I've heard I shouldn't import any batch of data into Excel using BLP plugin, because it is pricey. They told me that some time ago somebody did this and they ...
3
votes
1answer
1k views

Bloomberg scripting language (BLAN)

Did anyone work with Bloomberg scripting language (BLAN is the name I guess). If so is it really flexible and is it competitive with other valuation services (say Super Derivatives). Does it enable ...
3
votes
0answers
4k 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....
3
votes
0answers
897 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 ...
2
votes
4answers
13k views

Are PX_BID and PX_ASK on Bloomberg closing bid/ask? or are they daily averaged?

Bloomberg provides PX_BID and PX_ASK on a daily basis, but it's not clear exactly where these numbers come from. Are they closing bid and ask prices, or are they averaged over the entire day? For ...
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 ...
2
votes
3answers
2k views

RQuantLib, Hoadley and Bloomberg YAS: fixed rate bond pricing differences?

I'm trying to price a fixed rate bond one year from now on. The bond is the PEUGOT 7 ⅜ 03/06/18, whose ISIN code is FR0011439975. I'm using such a specific example because in this way everyone can ...
2
votes
2answers
519 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 ...
2
votes
2answers
3k views

Bloomberg tick data timezone offset

I am using python to access the Bloomberg Desktop API and am running into issues with the timezone conversion for their tick data. The data they deliver is supposed to be UTC but there is something ...
2
votes
1answer
1k views

Moody's Sovereign Ratings: Clarification on Definitions and Symbols

I'm working with sovereign ratings at present. With regard to Moody's there are a few things unclear to me in their definitions. Both questions refer to the sovereign rating history in Bloomberg CSDR (...
2
votes
3answers
2k views

Bloomberg-alternatives for intraday stock price data?

Given the limitation Bloomberg imposes in terms of the number of days you can go into the past when retrieving historical intraday data, what are similarly reliable alternative solutions? I require ...
2
votes
2answers
8k views

Bloomberg Libor Rates

I load swap rates data from Bloomberg in excel using the command =BDH(Ticker,"Px Last",Start_Date,End_Date,"Dts",FALSE) The tickers I use are "USSW1 Curncy", "...
2
votes
1answer
149 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?
2
votes
4answers
3k views

IR Swaps - Curve sensitivity at maturity node

I was recently trying to price some IR swaps in BBG. I noticed that when I shock the yield curve up by 1bps at a single specific node, the DV01 is close to zero except at the node nearest the maturity....
2
votes
2answers
135 views

Creating index from bloomberg data in matlab

I'v got 6 different equity index time series from which I want to create an index based on a particular percentage. This would be simple although due to different holidays the date don't always match. ...
2
votes
1answer
204 views

Subscribe to iNav changes via ETF_INAV_VALUE key

I'm using the Bloomberg API to subscribe to market data changes. While I manage to retrieve fields such as OPT_GAMMA_MID_RT or ...
2
votes
1answer
305 views

Historical index components (FIGIs) from bloomberg?

In order to run strategy simulations, I am trying to build a database of historical equity data using Bloomberg. I can pull the ticker symbols corresponding to the components of an index at any point ...
2
votes
1answer
506 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 ...
2
votes
1answer
30 views

Source of market or security attribute information?

There are many securities and exchanges on platforms like Bloomberg and Quandl, but many securities are described with the relevant pit close times and pit open times, exchanges, related futures, and ...
2
votes
1answer
2k views

Discount Curve built-up

For a particular currency, let's say for USD, I'd like to know how to construct a discount curve? I've an impression that one professor told me that for USD, less than 3 months, it's using Libor ...
2
votes
0answers
104 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 ...