question

Upvote
Accepted
16 1 1 2

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!

bondsdatastreamisin
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
81.3k 267 53 76

@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:

1666152591279.png

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:

1666152655656.png

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.


1666152591279.png (34.2 KiB)
1666152655656.png (34.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.