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!

Find more posts tagged with

python

eikon

symbology

constituents

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

You can try to get TR.CUSIPExtended field.

Here is field description from Data Item Browser

All comments

chavalit-jintamalit

You can try to get TR.CUSIPExtended field.

Here is field description from Data Item Browser

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.

Quick Links