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
0
votes
0answers
56 views

BSE India best data source for foreigners (Bloomberg terminal?)

I'm looking for a best possible data source for BSE India realtime L2 data (at least 5 levels of book) equities only (F&O welcome, but not needed). I have an access to bloomberg terminal, have ...
0
votes
1answer
13k views

Price at Specific Time from Bloomberg

I have a file where I easily export real-time prices to excel using the Bloomberg Add-In, using the formula BDP. Is there a way to get these prices of a specific time? For example, =BDP("EURGBP ...
1
vote
1answer
558 views

Instantaneous Forward Rate from Bloomberg

I am calibrating the Hull-White model which involves finding the level of mean-reversion from the market instantaneous forward rate? Is the market instantaneous forward rate directly available from ...
2
votes
0answers
61 views

Which financial database has the most extensive coverage of person-level data and uses person-level identifiers

For some empirical research, I need to retrieve data relating to the board members of companies corresponding to all securities in a major index. The data points I am looking for include gender, ...
1
vote
0answers
531 views

Extracting continuous futures prices on different dates with the ratio adjustment

I extract continuous prices for a set of futures contracts using Bloomberg. I select the Ratio as adjustment with the Bloomberg default settings. For instance, to extract the first/forward generic ...
0
votes
0answers
67 views

How to retrieve list of names of board members for a given ticker from Bloomberg Professional

I would like to investigate some data on individual board members in a systematic way. I have a Bloomberg Terminal at my disposal, which I would like to use for this. In a first step, I need to ...
0
votes
2answers
4k views

EUR Implied Forward Rate from Bloomberg

does anyone know about the EUR Forward Implied 3 Month Rate published by Bloomberg on the Bloomberg Page EURI3M ? First question: this is the rate from a forward curved, forward curve being ...
1
vote
1answer
3k views

What are Generic government treasury bonds? (Bloomberg terminal)

I have a project at school were we are supposed to find the generic series for US treasury bonds, and then download daily data for 3 years. I have found the bb ticker, but i don't understand the ...
0
votes
3answers
721 views

Alternative to Bloomberg Excel Add-In for EOD Stock Prices

Is there a more cost-effective alternative to Bloomberg Excel Add-In? 90% of the time I only use Bloomberg to download security (hundreds of U.S. and international stocks) historical price data. The ...
1
vote
0answers
503 views

Commodity index member weights (historical) for S&P GSCI and BCOM

Does anyone know a datasource for retrieving the historical index member weights for the two major commodity indices S&P GSCI and Bloomberg Commodity Index? My institution provides access to ...
0
votes
1answer
411 views

Does Bloomberg Terminal have access to CRSP “permno”s, Compustat GVKEYs?

CRSP has a nice, permanent identifier system for securities known as "permno"s. I don't have access to a Bloomberg terminal, but am considering the investment. Does the Bloomberg terminal know these ...
1
vote
1answer
920 views

How does Bloomberg arrive at stub rate for swaps/floaters?

I'm trying to interpolate initial stub rate ( 'Index to' in the image ) for the following FRN pricing example. Fixes on 2016/11/30 1m : 0.623670 2m : 0.742500 3m : 0.93417 Please be as specific as ...
1
vote
1answer
627 views

Which models do Bloomberg/Reuters use to derive implied volatility for interest rate derivatives with negative forward rates?

can anybody tell me which models Bloomberg and Reuters ares using to derive implied volatility for interest derivatives with negative forward rates? I know that Black-76 is the standard model, and ...
0
votes
1answer
603 views

Bond characteristics using Bloomberg in Excel

I would like to retrieve bond characteristics (bond type, coupon type etc.) for corporate bond ISINs using the Bloomberg Excel Addin. I tried ...
0
votes
1answer
266 views

How to Pull Dump of Old News Articles

My goal is to run a keyword search for phrases like "soybean acreage" or "corn yields" (keywords limited to ag. commodities), and construct a timeline of which dates articles with these key words are ...
-1
votes
2answers
363 views

Extract Corporate Bond volume

Is it possible to extract the volume of Corporate bonds in Bloomberg with BDP, BDH or BDS function ? Example : 958254AC8 Corp; 98389BAM2 Corp; 94974BFP0 Corp. Doesn't seem like it's possible, even if ...
0
votes
1answer
302 views

Where can I find historical daily term repo data?

DTCC appears to provide historical o/n repo data for US Treasuries but does not do so for term repo data. If I want to analyze the term repo curve, where would I be able to find historical term repo ...
-1
votes
1answer
2k views

Forward 12m EPS Growth and its Earning Revision using Bloomberg

I'm currently trying to figure out how to use data from Bloomberg to create some analysis on a company's performance using Excel/R. How can I find the Forward 12m EPS Growth, its 1m Earning Revision ...
1
vote
0answers
340 views

question about the market quote from bloomberg

I am a little bit new in finance. Perhaps it is not suitable to ask here, but still, I would like someone can help me. What I have now in hand are normal volatilities taken from Bloomberg for a ...
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....
0
votes
1answer
1k views

Constructing yield curve directly from yield-to-maturity data

I'm trying to use Bloomberg yield-to-maturity data for sets of sovereign bonds of different maturities to fit to a yield curve. I looked into using the QuantLib library (the FittedBondCurve ...
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 ...
1
vote
0answers
402 views

Does OpenFIGI have precanned files?

From what I understand, Bloomberg Open Symbology is now transitioning to OpenFigi: http://bsym.bloomberg.com/sym/ "BSYM.bloomberg.com will be SHUT-OFF on June 1st. It is being replaced by OpenFIGI....
3
votes
1answer
114 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 ...
2
votes
2answers
141 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
3answers
2k 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 ...
5
votes
1answer
497 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 ...
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 ...
1
vote
1answer
317 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 ...
2
votes
1answer
216 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 ...
5
votes
1answer
272 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
0answers
5k 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....
2
votes
1answer
430 views

Rblpapi millisecond resolution

I'm using Rblapi to get tick data, using the nice getTicks function. Much to my dismay the index is rounded to the second, while milliseconds time stamp could be provided. Tried returnsAs xts, fts(?) ...
2
votes
1answer
2k 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 ...
1
vote
1answer
2k 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 ...
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 ...
2
votes
1answer
316 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 ...
1
vote
0answers
180 views

Returning historical yield rates for Mortgage Backed Securities in a Bloomberg Terminal?

Forgive me if this isn't the right place, and direct me to the correct place to post. I've been trying to figure out how to get the yield rates for Mortgage Backed Securities (MBS's) in the United ...
2
votes
1answer
517 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 ...
0
votes
2answers
388 views

Handling upcoming corporate actions for equity portfolio

I have an equity statarb strategy developed using CRSP daily data. The strategy is always invested (long or short) in around 400 stocks. The ...
3
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
148 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 ...
2
votes
1answer
31 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 ...
6
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. ...
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
570 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 ...
2
votes
0answers
363 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 ...
5
votes
1answer
843 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 ...
3
votes
1answer
722 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?