Retrieving company identifiers from bond information

Fernando E.
Fernando E.
in Eikon Data APIs

Hi,

I have a list of bonds with ISIN/CUSIP information, and I'd like to retrieve the ISIN/CUSIP/PermID or alternative identifier of the issuer? Can this be done from the Eikon API in R?

Thanks!

Tagged:

Best Answer

  • Gurpreet
    Gurpreet
    Answer ✓

    Not sure which user's name you are referring to here, but you can use get_data API call to retrieve some data for the bonds

    >>> ek.get_data('US099109017=', fields=['TR.FiIssuerName', 'TR.IssuerRating'])
        Instrument                           Issuer Name Issuer Rating
    0  US099109017=  INTERNATIONAL BUSINESS MACHINES CORP          BBB+

    In Eikon, you can use Data Item Browser to see a list of fields, that can be used in the get_data call.

Answers

  • Gurpreet
    Gurpreet

    Hi @Fernando E.,

    Eikon API provides a get_symbology API call in Python which should also be available in R. You can pass in the list of ISIN's etc and get corresponding RICs.

    E.g.:

    >>> ek.get_symbology(["US099109017="], from_symbol_type="RIC", to_symbol_type="ISIN")
                          ISIN
    US099109017=  XS0991090175

    >>> ek.get_symbology(["XS0991090175"], from_symbol_type="ISIN", to_symbol_type="CUSIP")
                      CUSIP
    XS0991090175  459200HQ7

    The conversion might work if there is a 1:1 mapping between symbols, and if you have permission to retrieve converted instrument.

  • Fernando E.
    Fernando E.

    Thanks Gurpreet. I did not mean to translate between symbologies for a security, but instead getting information on the name of the user.


    Thanks,

    Fernando

  • Fernando E.
    Fernando E.

    That is what I was after, thanks a lot! (I meant "issuer" not "user", sorry!)


Categories