NexusFi: Find Your Edge


Home Menu

 





S&P 500 from 1789 until today: free data


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one Shaban with 8 posts (11 thanks)
    2. looks_two unison31 with 2 posts (0 thanks)
    3. looks_3 Revelator with 1 posts (0 thanks)
    4. looks_4 Fi with 1 posts (0 thanks)
    1. trending_up 30,588 views
    2. thumb_up 11 thanks given
    3. group 8 followers
    1. forum 11 posts
    2. attach_file 2 attachments




 
Search this Thread
  #1 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

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


https://stooq.com/q/d/?s=%255Espx&c=0


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

[img]https://i.postimg.cc/hPNyKdSD/S-P-storico.jpg[/img]


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Kharg Island at 6%, Regime Fall at 1.5% -- The Black Swa …
Prediction Markets & Event Contracts
Iran Peace Expired NO: Ceasefire on Life Support, OPEC a …
Prediction Markets & Event Contracts
April 2026 Jobs Report: +115k vs +65k Expected
Traders Hideout
Topstep Acquires The Futures Desk -- Prop Firm Consolida …
Funded Trading Evaluation Firms
TradingView Deploys AI to Monitor SEC Filings in Real Ti …
TradingView
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Trying to learn Volume and price action correlation
7 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Lady Vols Primer: Trading Volatility Journal
6 thanks
  #2 (permalink)
 Revelator 
Raleigh, North Carolina
 
Experience: Intermediate
Platform: NT8, Sierra Chart
Trading: ES
Posts: 2 since Jan 2021
Thanks Given: 0
Thanks Received: 0

Thanks for sharing this resource!


Reply With Quote
  #3 (permalink)
unison31
San Diego, California/United States of America
 
Posts: 5 since Feb 2021
Thanks Given: 1
Thanks Received: 1


Thank you. I thought most stock market indices were not created until the late 1800s. What do they use for pre-1800 data?


Reply With Quote
  #4 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

The tulip bubble occurred in 1637, where a few varieties of tulips were worth as much as a house:

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

I believe the quotes were taken from the official data of the time.


Reply With Quote
  #5 (permalink)
unison31
San Diego, California/United States of America
 
Posts: 5 since Feb 2021
Thanks Given: 1
Thanks Received: 1

Do you know what the website means by "official data"? I could not find an explanation on the website.

The website's “S&P 500” data begins in 1789. However, I checked and the S&P 500 index was created in 1957 and the Dow Jones index was created in 1885. The New York Stock Exchange was established in 1792, so the website must obtain their early data from somewhere else. Thank you!


Reply With Quote
  #6 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

Unfortunately I don't know where the Site has found the data of the S&P 500 since 1789.

If it may be useful to anyone, here you can download data in Down Jones' Metastock format from 1900 to 2002:


Reply With Quote
  #7 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

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;
probably at that time this was the reference Index, and only later became the S & P 500.


Reply With Quote
  #8 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

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:

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

[img]https://i.postimg.cc/rm1JPYQ4/S-P-500-Secular-Cyclical-Bull-Bear.png[/img]


Reply With Quote
Thanked by:
  #9 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137

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)

FTSE MIB (Italy)

Nikkei (Japan)

Nifty (India)

etc...

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

“Every day I get up and look through the Forbes list of the richest people in America. If I’m not there, I go to work. ”

(Robert Orben)


Reply With Quote
  #10 (permalink)
Shaban
Turin + Italy
 
Posts: 201 since Feb 2020
Thanks Given: 26
Thanks Received: 137


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.

https://postimg.cc/Fkh6cXJq


Reply With Quote
Thanked by:




Last Updated on January 30, 2026


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts