Missing S&P 500 index (.INX) quote for 07/28/2015

18 views
Skip to first unread message

bikef...@gmail.com

unread,
Oct 12, 2017, 11:16:06 PM10/12/17
to Google Finance
I am trying to build a spreadsheet to collect stock prices and index prices (S&P 500) to calculate the beta for a stock.

However, I have discovered that GoogleFinance is missing the quote for the S&P 500 index on 07/28/2015.
It reports quotes for stocks, but nothing for the index.  See the "Error" tab on the link below.

If you look at the "User Selected" tab and scroll down to line 725, you will see a quote for the stock, but nothing for the index.  The result is that the two series no longer align by date, making the beta calculation meaningless.


Any ideas on how to bring this to the attention of Google so that it can be fixed?


Yahoo Finance reports an index quote for that day, and identical quotes (to Google) for the day before and the day after 07/28/2015.

DateOpenHighLowClose*Adj Close**Volume
Jul 29, 20152,094.702,110.602,094.082,108.572,108.574,038,900,000
Jul 28, 20152,070.752,095.602,069.092,093.252,093.254,117,740,000
Jul 27, 20152,078.192,078.192,063.522,067.642,067.643,836,750,000


Thanks.
Reply all
Reply to author
Forward
0 new messages