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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aryer avatar image
21 ●2 ●1 ●5

How to get the correct CUSIP

Hello,

I am trying to get S&P 500 constituents at a historical date(like 01/31/2000). I used the get_data function, but some of the CUSIP are missing(see line 19 and 27 for example). So I tried to convert RIC to CUSIP for these missing ones, some of them work, but others like "AON.N", I couldn't get correct CUSIP out from the RIC (Error 2)

Could you let me know how to fix the problem?

Thank you!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonsymbologyconstituents
error1.png (28.4 KiB)
error2.png (23.3 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.

nick.zincone avatar image nick.zincone

Hi @aryer,

I'm following up to see if the suggestion below helped. If not, can you provide some additional details as to what problems you are running into?

thanks.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @aryer

You can try to get TR.CUSIPExtended field.

Here is field description from Data Item Browser


cusip.png (25.0 KiB)
dib.png (111.0 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.

Click below to post an Idea Post Idea