Mapping from Bond to Equity ticker

HITMAN_G
HITMAN_G LSEG
in Datastream

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!

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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

Categories