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

learn more… | top users | synonyms

21
votes
6answers
46k 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 ...
12
votes
1answer
549 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 ...
7
votes
5answers
3k 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 ...
5
votes
3answers
4k 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 (...
5
votes
1answer
124 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
2answers
5k 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 ...
5
votes
1answer
63 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
170 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
11k 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?
4
votes
2answers
166 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. ...
4
votes
3answers
558 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
2k 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 ...
4
votes
1answer
206 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
47 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 ...
4
votes
1answer
447 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 ...
4
votes
1answer
106 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
277 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 ...
3
votes
4answers
1k 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 ...
3
votes
1answer
356 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
2answers
383 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
98 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
171 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
1answer
166 views

Bloomberg, downloading data in Excel

My company has Bloomberg terminal, but ive heard I shouldnt 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 paid $...
3
votes
1answer
39 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 ...
3
votes
3answers
2k 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
0answers
339 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 ...
2
votes
2answers
6k 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 ...
2
votes
4answers
3k 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
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
1answer
443 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
657 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
695 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
2answers
49 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
70 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
138 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
24 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
3answers
519 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 ...
2
votes
1answer
702 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 ...
2
votes
1answer
249 views

How to download efficiently intraday data with Bloomberg API?

I'm downloading intraday bar data using Bloomberg API and C#. I have adapted the official Bloomberg c# "IntradayBarExample” to suit my needs. However downloads are really slow, I found this post ...
2
votes
0answers
114 views

Can you tell me what this RBloomberg formula means?

I've been asked to re-create a spreadsheet that used RBloomberg using a different data source. But I'm having trouble figuring out exactly what one of the spreadsheet's formulas does. Can anyone tell ...
2
votes
0answers
305 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
0answers
852 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
2answers
192 views

How to get historical fundamental data in Bloomberg suitable for backtesting?

I'm trying to retrieve historical stocks fundamental data from Bloomberg to backtest some quant ideas. I'm having trouble to find the correct point in time the data was available. For instance, the ...
1
vote
1answer
2k views

Integrating R with Bloomberg

In the past, I have used the package RBloomberg to directly pull bloomberg data into R. I've also seen it go by the names Rbbg or R[Name Redacted]. It seems to me, however, that this package no longer ...
1
vote
2answers
472 views

Bloomberg Alternative for Quant Fund

Is there an alternative to Bloomberg for someone who only needs historical data (stocks, futures, indices) as well as what Bloomberg calls 'reference data' - i.e. what is the multiplier of ESU4, what ...
1
vote
1answer
189 views

Rblpapi / bdh - how to download prices for all weekdays - regardless if it is a bank holiday

Using bdh(), I am trying to download historic weekday prices regardless if the weekday is a holiday or not. The default does not return weekday bank holidays. The ...
1
vote
1answer
989 views

Bloomberg equity option volatility data

Using the Bloomberg open API, I am trying to program a C++ script that is able to download option volatility data from Bloomberg. I currently do not have access to Bloomberg, but in the coming week I ...
1
vote
2answers
3k 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", "...
1
vote
1answer
90 views

Template for Bloomberg terminal [closed]

I'm working on my master's thesis and I need to extract data from the Bloomberg Terminal. I'm rather inexperienced when it comes to using the Terminals many features. The data I need is for the ...
1
vote
1answer
175 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 ...