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!
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
22.5k
●59 ●14 ●21
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.
22.5k
●59 ●14 ●21
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.
3
●1 ●2 ●1
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
3
●1 ●2 ●1
That is what I was after, thanks a lot! (I meant "issuer" not "user", sorry!)
