S&P 500 from 1789 until today: free data

Almarok

Active member
Messages
106
Likes
18
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.

 
Top