CUSIP extended code

mahdiehvg

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.

m.bunkowski

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

mahdiehvg

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.

m.bunkowski

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