2
$\begingroup$

While attempting to model the SPX index over time, I found a source here that purportedly has historical daily SPX data going back to 1789 which very likely seems to be backcasted since the ~500 stock version only came into being around 1957.

What I am more uncertain about is if the daily data from this source dating back to 1927 (when SPX was a ~200(?) stock index) is simply a linearly interpolated version of the monthly data at this time? since I have not seen many data sources claim to have daily data for SPX starting in 1927.

Additionally, when doing some exploratory data analysis, I found that there was notable, but still small autocorrelation (~0.1) at the first lag which I know could be from the market being less efficient during this period, but still seemed like it could be an artifact of interpolation.

$\endgroup$
6
  • $\begingroup$ Yahoo Finance now also has daily data going to 1927 publicly available. I don't think it's interpolated though there can of course be concerns about accuracy. $\endgroup$
    – fes
    Aug 12, 2023 at 5:25
  • $\begingroup$ @fes oh yes, I think I saw that, thanks! I only avoided yahoo finance because, for some reason, there is a large string of days in around 1960 where the open price is 0 for all of them on their SPX data, as an aside, would you happen to know anything anout the date when they started recording OHLC prices for SPX versus just a single price and also if this single price that's displayed is the open, high, low, or close? Because on both yahoo finance and stooq, the Open, High, Low, and Close are all the same until ai think somewhere in the 1970s? $\endgroup$
    – QMath
    Aug 12, 2023 at 6:30
  • 1
    $\begingroup$ Does this answer your question? What data sources are available online? $\endgroup$
    – Alper
    Aug 12, 2023 at 6:56
  • 1
    $\begingroup$ @Alper Thank you for the reference! While that post is a wealth of information, I don't know if (and I very well could be wrong) it includes the level of specificity I need with regards to how SPX historical ohlc prices were recorded. $\endgroup$
    – QMath
    Aug 12, 2023 at 9:12
  • 1
    $\begingroup$ Open is not dependable for SPX data, and is not tradeable. Only after the introduction of S&P futures (1980's) is it possible to actually see the value of the S&P 500 at the time the market opens. $\endgroup$
    – nbbo2
    Aug 12, 2023 at 11:07

0

Your Answer

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