Home > Forum Home > Excel Portfolio Optimization Template > Download Data spreadsheet does not download the S&P 500 index data (^GSPC) Share

Download Data spreadsheet does not download the S&P 500 index data (^GSPC)

Excel Help for Download Data Spreadsheet Does Not Download The S&p 500 Index Data (^gspc) in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Download Data Spreadsheet Does Not Download The S&p 500 Index Data (^gspc)

Rate this:
(2/5 from 2 votes)
Confused I can't get the Download Data spreadsheet to download the S&P 500 index data (^GSPC).  What am I missing?

Al B.
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(4/5 from 2 votes)
It may depend on the periodicity whether the data is available via Yahoo.

One workaround is to use the ETF: SPY for index level data.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
The lastest download version indeed offers solution to get data from yahoo or google and supposedly can get ^GSPC data. However, I find the updated version still cannot download ^GSPC data from Yahoo. Is this a limitation with Yahoo, or am I missing the latest download version? Thanks.
 Posted by on
Confused
Rate this:
(3/5 from 3 votes)
Yahoo Finance have permanently disabled their market data API.

We have updated the solution to use Google Finance instead which can be downloaded with the portfolio optimization template.

Some ticker symbols are different with Google Finance and so you'll need to go to that site to ascertain symbols.  'SPY' is an ETF of the S&P 500 which will give the same daily returns.
 Excel Business Forums Administrator
 Posted by on
Happy
Rate this:
(1.7/5 from 3 votes)
An updated version from the download link now supports Yahoo Finance again with ability to get indices such as ^GSPC and lower frequency data.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Download Data spreadsheet does not download the S&P 500 index data (^GSPC):

Solutions: Download Stock Quotes Web Services Add-in
Categories: Market Data Access