I have to download historical end of day data for a huge list of stocks. I found on the bloomberg excel add-in the function BDH that is very useful. That is what I need but there is an issue: my stocks are identified by ISINs and i have tried in many way to put the ISINs in the first field of the function but it doesn't work. The function isn't able to identify the security by the ISIN despite the fact that is reported as security identifier in the bloomberg formula syntax: look at slide 24 here http://lgdata.s3-website-us-east-1.amazonaws.com/docs/205/56376/bloomberg%20excel%20desktop%20guide.pdf
In Bloomberg: in Excel paste your identifiers then use the following formula: =BDP(A1&"isin","PX_Last") for instance where A1 is your first pasted ISIN number, and PX_Last is the item you are requesting.
Open Microsoft Excel on the Bloomberg terminal. Click the "Bloomberg" tab on the toolbar at the top of the page. Click the "Data Navigation" button to bring up the data wizard. The data wizard allows you to search for and download securities data within Excel.
The problem is that an isin does not identify the exchange, only an issuer.
Let's say your isin is US4592001014
(IBM), one way to do it would be:
get the ticker (in A1):
=BDP("US4592001014 ISIN", "TICKER") => IBM
get a proper symbol (in A2)
=BDP("US4592001014 ISIN", "PARSEKYABLE_DES") => IBM XX Equity
where XX
depends on your terminal settings, which you can check on CNDF <Go>
.
get the main exchange composite ticker, or whatever suits your need (in A3):
=BDP(A2,"EQY_PRIM_SECURITY_COMP_EXCH") => US
and finally:
=BDP(A1&" "&A3&" Equity", "LAST_PRICE") => the last price of IBM US Equity
I had the same problem. Here's what I figured out:
=BDP(A1&"@BGN Corp", "Issuer_parent_eqy_ticker")
A1 being the ISINs. This will return the ticker number. Then just use the ticker number to get the price.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With