Bond ISIN to company ISIN

Suppose you created a list with bonds and the accompanying ISIN codes. You can’t use these ISIN codes to download information from the issuer of this bond. But here is way to use the ISIN codes you collected so far to find the ISIN code of the issuer

An example: the ISIN code US44044KAA97 belongs to a bond. To find the ISIN from the company you can use Excel on the Bloomberg terminal.

b1

First you copy US44044KAA97 into B1. In B2 you enter this formula:

=BDP(B1 & ” corp”,”FUNDAMENTALS_TICKER”)

b2

In B3 you use the contents of B2 and use concatenate to put “Equity” behind it. Use this formula:

=B2& ” Equity”

b3

The last step is to use this function in cell B4:

=BDP(B3,”ID_ISIN”)

b4

to find the ISIN you are looking for.

Advertisements

One thought on “Bond ISIN to company ISIN

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s