For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Hello,
I look for the full list of all the companies that have ever entered the S&P 500 Index for the last 25 years. I tried many modifications of this line, but none of them worked by far. Sometimes I get the 505 companies that are the in the Index now, but that is not what I need. Any suggestions? Thank you!
rics, err = ek.get_data(instruments=".SPX", fields=["TR.IndexConstituentRIC"],
parameters={'SDate':'1993-01-01', 'EDate': '2018-06-13'})
See the following previous thread on this forum, which explains how to retrieve the list of stocks that left an index in a given time period. Combine the list of leavers in the last 25 years with the current constituents of the index and you should have what you're looking for.
https://community.developers.refinitiv.com/questions/28201/how-to-get-list-of-leaver-companies-of-the-asx-100.html
How to create a list of S&P 500 Companies with all updated data like weight, market cap etc. similar to this - https://finasko.com/sp-500-companies/
