In Excel, I have a list of ISINs for bonds. Now I want to find the ratings for them and use BDP. The problem is how do I get the security name (Bloomberg can work with) from the ISIN? I can do it manually with the spreadsheet builder, but there I have to do this for each individual security. Is it possible to automate this?
1 Answers
You don't need the Security Name to do your job. Simply place in an excel cell (example B1) this formula (assuming that in cell A1 you have a valid ISIN):
= A1 & " Corp"
and then use B1 to obtain your desired data from Bloomberg.
Related