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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

aryer avatar image
21 3 3 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-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonsymbologyconstituents
error1.png (28.4 KiB)
error2.png (23.3 KiB)
1 comment
10 |1500

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

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

chavalit-jintamalit avatar image
18.1k 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)
10 |1500

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