In order to backtest a few strategies I'm searching for a (free) csv/excel file of tickers included in the s&p 500 during specified years (say, 1970).

Do you happen to know where I can find something like this? I tried searching but couldn't find what I'm looking for.


  • 3
    $\begingroup$ You have to pay for the official data. Some amateurs have constructed an approximate history from public data, going back to the early 2000's at best (I don't know any free one that goes back to 1970). Two examples are robotwealth.com/… and analyzingalpha.com/sp500-historical-components-and-changes TBH I don't know the quality of these attempts $\endgroup$
    – nbbo2
    Dec 10, 2020 at 15:37
  • $\begingroup$ What @noob2 said. You can confirm those against the wikipedia data (current constituents and deltas back 20 years). $\endgroup$ Dec 10, 2020 at 17:53
  • $\begingroup$ @noob2 Thank you for the info. Should it be easier to get total market tickers from 1970 instead of just tickers included in the S&P 500? $\endgroup$
    – Nathan
    Dec 11, 2020 at 3:20

1 Answer 1


Market data is rarely free, but if you're willing to pay for it, S&P 500 historical constituents data is available from Sharadar in QuantRocket's Data Library, with history back to 1957.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.