Kumo swcp Get historical data for the S&P500 stocks in one file.
There are some alternatives out there -- namely this option to enable the PSQ function -- however, that solution doesn't seem to work in Windows 8.
Luckily, I have finally found a solution thanks to this blog and the little known WEBSERVICE function in Excel.
The company was founded in 1912 and is headquartered in Hackensack, NJ.
Stock Quotes for Excel is a powerfull add-in software for Microsoft® Excel® which allows you to automatically obtain up to date data on Stock Quotes, Market Indexes, historical data, option prices and Mutual Funds, directly into your Excel spreadsheets - via Internet. Moreover, Stock Quotes for Excel -Stock Quotes for Excel query for data from the above sources, so we are subject to the features provided by them, as detailed below -Stock Quotes for Excel will not show current intraday data Saturdays or Sundays, and may not even show any data at all those days.