Bloomberg BDH function with ISIN

Question

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

User · Answer

To download ISIN code data the only place I see this is on the ISIN organizations website  www isin org  try http   isin org  they should have a function where you can easily download

User · Answer

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     gt  IBM  get a proper symbol  in A2    BDP  US4592001014 ISIN    PARSEKYABLE DES     gt  IBM XX Equity   where XX depends on your terminal settings  which you can check on CNDF  lt Go gt   get the main exchange composite ticker  or whatever suits your need  in A3     BDP A2  EQY PRIM SECURITY COMP EXCH     gt  US  and finally    BDP A1 amp     amp A3 amp   Equity    LAST PRICE     gt  the last price of IBM US Equity

User · Answer

I had the same problem  Here s what I figured out    BDP A1 amp   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

[excel] Bloomberg BDH function with ISIN

Examples related to excel

Examples related to finance

Examples related to bloomberg