How to get the correct CUSIP

aryer

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!

chavalit-jintamalit

Hi @aryer

You can try to get TR.CUSIPExtended field.

Here is field description from Data Item Browser

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.