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!
16
●1 ●1 ●2
Mapping from Bond to Equity ticker
Hi @HITMAN_G ,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
78.9k
●250 ●52 ●74
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.
