1
$\begingroup$

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.

Thanks

$\endgroup$
3
  • 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$ – noob2 Dec 10 '20 at 15:37
  • $\begingroup$ What @noob2 said. You can confirm those against the wikipedia data (current constituents and deltas back 20 years). $\endgroup$ – steveo'america Dec 10 '20 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 '20 at 3:20
1
$\begingroup$

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.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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