S&P 500 from 1789 until today: free data

Almarok

Active member
Messages
118
Likes
23
Here you can download free data of the S&P 500 from 1789 until today (for Excel, in format: Daily, Weekly, Monthly, etc.):




write at the top left (in the box: Symbol np): ^SPX and then click on: Kwotuj

and then click at the bottom left on: Historical data

choose Interval: Daily, Weekly, Monthly, etc...

click at the bottom on: Download data in csv file

 
It looks like it started with a downtrend.:)
1610844442816.png
 
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):


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/

 
Last edited:
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...
 
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:



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

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.

 
The History of the American Stock Exchange is described here:




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.



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:



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....
 
Awesome find thanks. I've built my own backtesting bot so I'll add that data in. That will really confuse it!

Incidentally does anyone know if the long term FTSE 100 data is available? Yahoo Finance doesn't have the historical data. Strangely I could download the FTSE 250. That's kind of a better index for backtesting anyway.
 
Incidentally does anyone know if the long term FTSE 100 data is available? Yahoo Finance doesn't have the historical data.
 
Awesome find thanks. I've built my own backtesting bot so I'll add that data in. That will really confuse it!

Incidentally does anyone know if the long term FTSE 100 data is available? Yahoo Finance doesn't have the historical data. Strangely I could download the FTSE 250. That's kind of a better index for backtesting anyway.

You can download here in csv format, the FTSE 100 data from 1984 to the present:


and here the FTSE 250 from 1985 to the present:


in addition to the FTSE there are also other Indices (see post: #5)
 
Top