S&P 500 from 1789 until today: free data

Discussion in 'Strategy Building' started by Shax, Jan 16, 2021.

  1. Shax

    Shax

    In the book: The Right Stock at the Right Time Prospering in the Coming Good Years by Larry Williams, are published some statistics from 1871
    of the Index: S & P Composite Stock Price Index, whose data he took from this site:

    http://aida.econ.yale.edu/shiller/data.htm

    this page is no longer there, but the home page is of the Nobel Prize: Robert J. Shiller (Co-Winner of the 2013 Nobel Prize in Economics):

    http://www.econ.yale.edu/~shiller/

    so I believe that the data published in the book of Larry Williams are reliable.

    Probably at that time this was the reference Index, and only later became the S & P 500.

    Also on this page by legendary trader Dan Zanger, there is this chart showing that as early as 1870 there was a Stock Market Index that later became
    the S & P 500:

    https://www.traderslog.com/the-10-key-differences-between-bull-and-bear-rallies/

    [​IMG]
     
    #21     May 29, 2021
    Ivano and murray t turtle like this.
  2. Shax

    Shax

    You can get the Indexes of the whole World, by writing in the box: Symbol np

    DJI (Down Jones Industrial)

    Nasdaq

    FTSE (United Kingdom)

    DAX (Germany)

    Nikkei (Japan)

    Nifty (India)

    etc...
     
    #22     Mar 29, 2022
  3. Shax

    Shax

    With reference to post: #1:

    before you click on the button: Download data in csv file,
    you should click on: semicolon (at the bottom, where it says: Downloaded data separator: comma | semicolon) so you get the file: csv
    with the columns already separated: Date, Open, High, etc...;

    then, to quickly transform the csv file to Excel file (xls or xlsx), you can use this free service:

    https://convertio.co/it/csv-xls/

    https://convertio.co/it/csv-xlsx/

    ----------------------------------------------------------------------------------------

    At the bottom of this table (see image), it says:

    "Performance back to 1950 incorporates the performance of predecessor index, the S&P 90"

    so before the S&P 500 Index there was the S&P 90 Index (it probably only had 90 Stocks) and before that the Index
    will have had a different composition and name.

    [​IMG]
     
    #23     Nov 11, 2022
    murray t turtle likes this.
  4. %5
    Good line chart , even if it skipped1987 red .
    Panic of 1907 must have been real scary for some , first time that happened .
    Thanks, nothing like a big picture trend.:cool::cool:
     
    #24     Dec 2, 2022
  5. piezoe

    piezoe

    What!? would you care to explain? There was no S&P 500 until sometime in the 1950s I think.
     
    #25     Dec 19, 2022
  6. schizo

    schizo

    So S&P was around in 1789, eh? I swear I get dumber by the day being around here. :rolleyes:
     
    #26     Dec 19, 2022
  7. Overnight

    Overnight

    Haven't you heard? Dan Zanger is a legendary trader, so knows this to be true. And has proven it to be true, with a chart.
     
    #27     Dec 23, 2022
  8. Shax

    Shax

    The History of the American Stock Exchange is described here:

    https://www.history.com/topics/us-states/wall-street-timeline

    https://www.nyse.com/history-of-nyse

    https://en.wikipedia.org/wiki/New_York_Stock_Exchange

    https://www.nyse.com/publicdocs/American_Stock_Exchange_Historical_Timeline.pdf

    In summary:

    In 1792 the Buttonwood Agreement was drawn up, formalizing the association between merchants, traders, and speculators in the late 18th century who gathered in the shade of a large American sycamore tree (see image). This was the beginning of the Exchange, which for the first few years was held in the Tontine Coffee House, located near the famous plane tree at the intersection of Wall Street and Water Street.

    [​IMG]

    March 8, 1817: The members of the Buttonwood Accord adopted a charter creating the New York Stock & Exchange Board, the precursor to today's NYSE.

    1867: The stock ticker is first launched on Wall Street. The number and variety of securities traded at the NYSE steadily increased as America grew.

    When telephones were installed at the NYSE in 1878, the market became even more efficient.

    New York Stock Exchange in 1882:

    [​IMG]

    On December 15, 1886, trading volume exceeded 1 million shares for the first time.

    The Dow Jones Industrial Average (DJIA) was introduced on May 26, 1896, and although the DJIA is the best known, it was not the first of the Dow indices.

    1903: The modern New York Stock Exchange building is opened on Broad Street and Wall Street (the later periods you can read about in the links I have indicated to you above).

    I think the Site: https://stooq.com/ just wanted to merge the historical data from 1792 with the current S & P 500 (which was introduced in 1957, but the origin of the S&P 500 goes back to 1923, when Standard & Poor's introduced a series of indices that included 233 companies) and since it had to name the data file with only one name, he chose precisely: S & P 500.

    I think it is to be appreciated a Site that offers free long-term historical data of: World Indices, Stocks, Commodities,...etc....

    [​IMG]
     
    #28     Dec 24, 2022
    artak likes this.