For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
4 1 1 4

CUSIP extended code

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.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apisymbology
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
3.8k 4 4 6

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


ahs.jpg (61.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

data.png (46.3 KiB)

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

ahs.jpg (46.3 KiB)