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
35
votes
11answers
99k 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 ...
17
votes
1answer
23k 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
695 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
6k 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
13k 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
6answers
3k 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 ...
7
votes
5answers
7k 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
2answers
32k 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?
6
votes
2answers
2k 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
2answers
21k 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 ...
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
573 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
12k 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
324 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
974 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
195 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 -...
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
659 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
2answers
2k 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.
4
votes
1answer
156 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
858 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
2k 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 ...
4
votes
1answer
515 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 ...
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
196 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 ...
3
votes
3answers
220 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
1answer
869 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
834 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
126 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
275 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
2k 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
6k 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
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 ...
2
votes
4answers
3k 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 ...
2
votes
4answers
16k 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
6k 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
771 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
4k 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
4answers
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
3answers
109 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
125 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 ...
2
votes
1answer
812 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, ...
2
votes
4answers
4k 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
9k 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
494 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?