Download historical sp 500 data

If you know the symbol, you can actually get the CSV file right away without having to interact with Yahoo Finance website — just by typing the right URL into your browser. The URL is in this format:. This file will contain the entire history of daily prices available on Yahoo Finance for that symbol. Just a few things to note:. The data as provided by Yahoo Finance is sorted from newest to oldest.

You will often want it sorted the other way, which is easy to do in Excel. Select all the cells with data and then in Excel main menu choose Data and in the lower menu click Sort. The Sort dialog window will appear, where you can choose to sort the data by Date, Oldest to Newest.

If you primarily do your data analysis in Excel, it is useful to save the file as a standard Excel workbook xlsx rather than CSV, because there is not so much you can do and save with a CSV in Excel. Have a question or feedback? Send a message. Nov 16, Nov 15, Nov 12, Nov 11, Nov 10, Nov 09, Nov 08, Nov 05, Nov 04, Nov 03, Nov 02, Nov 01, Oct 29, Oct 28, Oct 27, Oct 26, Oct 25, Oct 22, Oct 21, Oct 20, Oct 19, Oct 18, Oct 15, Oct 14, Oct 13, Oct 12, Oct 11, Oct 08, Oct 07, Oct 06, Oct 05, Oct 04, Oct 01, Sep 30, Sep 29, Sep 28, Sep 27, Fundamental company data and analyst estimates provided by FactSet.

All rights reserved. Source: FactSet. Indexes: Index quotes may be real-time or delayed as per exchange requirements; refer to time stamps for information on any delays. Markets Diary: Data on U. Overview page represent trading in all U. See Closing Diaries table for 4 p.

Sources: FactSet, Dow Jones. Change value during the period between open outcry settle and the commencement of the next day's trading is calculated as the difference between the last trade and the prior day's settle. Change value during other periods is calculated as the difference between the last trade and the most recent settle.

Data are provided 'as is' for informational purposes only and are not intended for trading purposes. FactSet a does not make any express or implied warranties of any kind regarding the data, including, without limitation, any warranty of merchantability or fitness for a particular purpose or use; and b shall not be liable for any errors, incompleteness, interruption or delay, action taken in reliance on any data, or for any damages resulting therefrom.