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

learn more… | top users | synonyms

4
votes
1answer
43 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 ...
1
vote
0answers
8 views

How can I conditionally reorder EPS data in an Excel table using visual basic for applications based on the frequency of the earnings announcements? [migrated]

I have downloaded earnings per share data from Bloomberg for a large number of assets for one year. The resulting table measures 4 rows and around 3000 columns. Some columns contain four values, some ...
2
votes
1answer
58 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 ...
1
vote
2answers
249 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 ...
0
votes
1answer
48 views

finding the strike / maturity of warrants given their ISINs

I have a list of French traded warrants identified by their ISINs. I do not know, however, to which stock they refer and what is their strike/maturity. Which datasets allow me to retrieve this ...
2
votes
3answers
724 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 ...
1
vote
0answers
76 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 ...
0
votes
0answers
433 views

Bloomberg Pricing Sources: TRAC vs. BGN vs. BVAL etc

Sorry, I'm very new to using Bloomberg as a tool, so please forgive the naïve question. I couldn't find much information after some cursory online searches, so I figured I'd ask here. Particularly ...
0
votes
0answers
140 views

Exporting Time Series Data For Securities Prices From Bloomberg to Excel

I have a list of securities over a thousand entries long that I want to construct a time series of prices for over a specified historical period (e.g. 2/01/10-2/20/10). Doing this manually would take ...
2
votes
1answer
91 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 ...
0
votes
1answer
253 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 ...
14
votes
5answers
22k 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: RSF.ANY.AAPL.OQ Bloomberg: AAPL US Equity ...
1
vote
0answers
144 views

where to find historical option prices?

I have a dataset of options (traded in European exchanges such as NYSE Euronext) and I would like to find their price history. Where to find it? I see that ...
-1
votes
2answers
856 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 ...
0
votes
1answer
269 views

Bloomberg Zero Coupon Rates

As some of your may know from my other posts, I am working on a Dynamic Nelson Siegel (DNS) based relative value trading model. On simulated data (which satisfies all the assumptions) of the DNS it ...
3
votes
4answers
486 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 ...
0
votes
1answer
76 views

Best performing stocks in given year

Is there a function in Bloomberg that allows the user to search the best performing stocks for a given year, say 2011, in any given stock exchange? For example, I want to see the best performing ...
0
votes
2answers
386 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 ...
1
vote
2answers
301 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 ...
0
votes
1answer
400 views

S&P's Sovereign Ratings: Clarification on Definitions and Symbols

Similar to a question I asked earlier on, but I am now looking at S&P's sovereign ratings. Here, as in the case of Moody's, a few things are unclear to me in terms of the definitions used by ...
2
votes
1answer
226 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 ...
1
vote
0answers
59 views

Clarifying the way in counting number of weeks for calculating historical weekly volatility in Bloomberg

I would like to confirm the way to counting number of weeks for calculating historical weekly volatility in Bloomberg. Given an option with issue date from 14/1/2014 to 13/1/2019, is the proper way to ...
0
votes
1answer
468 views

converting US tickers into Reuters RIC [duplicate]

I have a large list of US equity tickers such as: "GIRO", "ITUB", "BITA" etc and I would like to convert them into their corresponding RIC codes. Do you know how can I do it? I have access to ...
0
votes
1answer
109 views

Calculating company-level market capitalisations from share quantities and values

I want to calculate company-level market cap values for stock exchanges listed by Bloomberg. I gather this can be calculated as the product of share price and the total of shares in circulation. But ...
2
votes
0answers
206 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 ...
3
votes
2answers
3k views

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

Simple question for the group: Regarding PX_LAST, PX_VOLUME etc... What does the "PX" prefix stand for?
-3
votes
1answer
125 views

Control Bloomberg logins in a library [closed]

In a campus library or other public place, typically many people share the same PC with the Bloomberg terminal software. Is there a way to prevent users from creating new logins? Is there a way to ...
5
votes
5answers
2k 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 ...
3
votes
3answers
2k 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 ...
12
votes
1answer
471 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 ...