How do I convert bond CUSIP to ISIN?

ulelectronic1

Hi, I have a list of bond 8-digit CUSIP that I would like to acquire a historical rating for. But using CODECR, it seems that I need 12-digit ISIN. Is there a clever way to convert CUSIP to a list of ISIN? Thank you in advance.

raksina.samasiri

Hi @ulelectronic1 ,

There's a convert symbology function provided, for example,

1. Eikon Data API: Quick Start guides, Tutorials, Documentation

   import refinitiv.data.eikon as ek
   
   ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')
   
   ek.get_symbology(
       ['594918104', '02079K107', '459200101'], 
       from_symbol_type='CUSIP', 
       to_symbol_type='ISIN')

   
2. Refinitiv Data Library for Python: Quick Start guides, Tutorials, Documentation

   import refinitiv.data as rd
   from refinitiv.data.content import symbol_conversion
   
   rd.open_session()
   
   response = symbol_conversion.Definition(
       symbols=['594918104', '02079K107', '459200101'],
       from_symbol_type=symbol_conversion.SymbolTypes.CUSIP,
       to_symbol_types=[
           symbol_conversion.SymbolTypes.ISIN
       ],
   ).get_data()
   
   response.data.df

   

Hope this helps and please let me know in case you have any further question.