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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
mahdiehvg avatar image
4 ●0 ●0 ●1

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonsymbology
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
marcin.bunkowski avatar image
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 5.0 MiB each and 10.0 MiB total.

mahdiehvg avatar image mahdiehvg

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)
marcin.bunkowski avatar image marcin.bunkowski mahdiehvg

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)
Click below to post an Idea Post Idea