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
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.
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.
Source: Stackoverflow.com