Mapping from Bond to Equity ticker

Is there a way to map from a given corporate bond identifier to its issuer parent equity ticker? Really struggling to find any thing that works here. If I have a Bond ISIN how can I from that get to its Issuer/Parent as I then I want to screen on its company financials. Thank You!

Find more posts tagged with

datastream

isin

bonds

Accepted answers

Jirapongse

@HITMAN_G

Sorry for the issue you are facing, let me see if I can help you in resolving this.

I tested with US037833BU32 which represents APPLE INCORPORATED 2016 2.85% 23/02/23 S. There is the BUPCECD data type in Bonds & Convertibles which represents Bond Ultimate Parent Company Datastream Equity Code.

Therefore, the code looks like this:

df = ds.get_data(tickers='US037833BU32', 
                 fields= ['NAME','BUPCECD'],kind=0)
df

The output is:

Then, I used 992816 to get a ticker (WC05601).

df = ds.get_data(tickers='992816', 
                 fields= ['NAME','RIC','WC05601'],kind=0)
df

The output is:

You can access the Datastream Navigator to search for items and data types.

I am not sure that this method is valid for all Bond ISINs. Please contact the Datastream support team directly via MyRefinitiv to verify and confirm this method.

I hope this will help.

All comments

Jirapongse

@HITMAN_G

Sorry for the issue you are facing, let me see if I can help you in resolving this.

Therefore, the code looks like this:

df = ds.get_data(tickers='US037833BU32', 
                 fields= ['NAME','BUPCECD'],kind=0)
df

The output is:

Then, I used 992816 to get a ticker (WC05601).

df = ds.get_data(tickers='992816', 
                 fields= ['NAME','RIC','WC05601'],kind=0)
df

The output is:

You can access the Datastream Navigator to search for items and data types.

I am not sure that this method is valid for all Bond ISINs. Please contact the Datastream support team directly via MyRefinitiv to verify and confirm this method.

I hope this will help.

EXPLORE OUR SITES