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

learn more… | top users | synonyms

20
votes
6answers
42k 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
536 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 ...
6
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
1answer
97 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
154 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
10k 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
3answers
3k 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 ...
4
votes
2answers
157 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
417 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
185 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
417 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
255 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
305 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
1answer
1k 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 ...
3
votes
2answers
280 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 ...
3
votes
1answer
88 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
105 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
30 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
1answer
49 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 ...
3
votes
1answer
86 views

Vendor data aggregation for Options on Futres

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 ...
3
votes
0answers
304 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
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
2answers
5k 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
3answers
1k 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
410 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
608 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
600 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
56 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
110 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
3answers
465 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
668 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
188 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
105 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
274 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
781 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 ...
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
461 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
120 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
785 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
2k 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
2answers
40 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. ...
1
vote
1answer
80 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
23 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 ...
1
vote
1answer
144 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 ...
1
vote
2answers
169 views

How do I find the entity identifier using BSYM?

I am new to BSYM and would like to do an entity-level search (as described here (towards bottom of document). For instance, a search for "APPLE INC" brings up 266 pages. Which one is for the entity? ...
1
vote
1answer
74 views

Bloomberg Historical Fundamental Data - Point in time

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
0answers
81 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 ...