I'd love any guidance on how to take those two CSVs and create a combined dataframe that is a time daily series with members of the S&P500...essentially two columns: "Date" and "Members of the Index".
Great video! Unfortunate that, out of my experience at least, its very hard to actually find matching pricedata for free or a decent priceof all the tickers from the history of the SP500, making backtesting realiably incredible difficult. Ofcourse unless you have a large capital at stake...
Are you aware of where to get this information for the Nasdaq 100? Wiki has paragraph style changes but only going back to 2008. Just wondering if you've seen anything better.