NexusFi: Find Your Edge


Home Menu

 





S&P 500 from 1789 until today: free data


Discussion in Emini and Emicro Index

Updated
    1. trending_up 6,116 views
    2. thumb_up 8 thanks given
    3. group 7 followers
    1. forum 9 posts
    2. attach_file 0 attachments




 
Search this Thread

S&P 500 from 1789 until today: free data

  #1 (permalink)
Shaban
Turin + Italy
 
Posts: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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=%2525255Espx&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?
MC PL editor upgrade
MultiCharts
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
About a successful futures trader who didnt know anythin …
Psychology and Money Management
Cheap historycal L1 data for stocks
Stocks and ETFs
What broker to use for trading palladium futures
Commodities
 
  #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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129

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: 194 since Feb 2020
Thanks Given: 24
Thanks Received: 129


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 November 11, 2022


© 2024 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 - Privacy Policy - Downloads - Top
no new posts