CUSIP extended code

mahdiehvg Newcomer

March 2020 in Eikon Data APIs

Hi,

I'm trying to get CUSIP extended codes for a list of firms.

I tried 'TR.CUSIP' but it gave me the not extended CUSIP codes.

I was wondering what is the field for getting the CUSIP extended codes?

Thanks in advance.

Tagged:

• python
• eikon
• symbology
• workspace
• eikon-data-api
• refinitiv-dataplatform-eikon
• workspace-data-api

0

Best Answer

• 

  m.bunkowski LSEG

  March 2020 Answer ✓

  Hi @mahdiehvg

  Please use a DIB app in Eikon where you can browse available fields. In your case it looks that the fields are: TR.CUSIPExtended or TR.CinCUSIPCode

  

  0

Answers

• 

  mahdiehvg Newcomer

  March 2020

  https://community.developers.refinitiv.com/discussion/comment/56507#Comment_56507

  Thanks for the reply.

  I tried both fields you suggested. None of them works. When I run the code the outcome is all "nan", it turned no CUSIP code (as you can see below).

  Do you know how to solve this problem?

  *Instrument is PermID.

  

  0
• 

  m.bunkowski LSEG

  March 2020

  https://community.developers.refinitiv.com/discussion/comment/56498#Comment_56498

  HI @mahdiehvg

  Try:

  df,err = ek.get_data(['4295903295','5000072036'],'TR.RIC')
  items = df['RIC'].tolist()
  df2, err = ek.get_data(items,['TR.OrganizationID','TR.CUSIPExtended'])
  df2

  

  0

Welcome!

It looks like you're new here. Sign in or register to get started.

Sign In

Register