Retrieving company identifiers from bond information
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!
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.
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.
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
That is what I was after, thanks a lot! (I meant "issuer" not "user", sorry!)