12.1.17 Problems throughout on getting prior day's closing data correct on summary pages
You say the close for Alcoa (AA) was $41.64, up $0.13. But Yahoo's summary page says the prior day's close was $41.24. That would imply a change of $0.40. Your interactive chart says the close was $41.51. There wasn't an ex-dividend either. If I'm correct, you have a system problem that's not moving the correct prior day's close over. I already noted the same problem with all the components in the Dow Jones Transports. What is going on here?
-
Charles Blaine commented
Google has the same Monday close for the Russell as well. Hate to be a pain, but something is off.
-
Charles Blaine commented
You have incorrect Monday closes for these tickers as well: ^DJITR and ^DWCF. See here http://quotes.wsj.com/index/XX/NULL/DJITR and http://quotes.wsj.com/index/DWCF
-
Charles Blaine commented
There are problems today. (12.5). The summary page for the Russell 2000 says the prior day's close was 1,537.02 and that the index is down some eight points. But the historical data page https://finance.yahoo.com/quote/%5ERUT/history?p=%5ERUT says the Monday close was 1,532.41. So the change, based on a 1:56 p.m. quote of 1528.65, is actually 3.76 points. The WSJ confirms the Monday close was 1532.41. http://quotes.wsj.com/index/RUT
-
Charles Blaine commented
If you want the screenshots, let me know.
-
Charles Blaine commented
To give you an idea how how bad the data was on Friday, here's a spreadsheet of the Dow close, the change, % change and listed prior close. I have screen shots of the Excel spreadsheet and the Display of the 30 Dow stocks.
A specific example. 3M closed at $241.15 on Friday, down 1.99. Your summary page says the prior day close was $238.01. The interactive chart says the Thursday close was $243.14. $238.01 was the WEDNESDAY CLOSE.
close Chg. Indicated close column c minus column d listed Prev Close Difference
3M Company 241.15 -1.99 243.14 238.01 5.13
American Express Company 97.86 0.15 97.71 96.6 1.11
Apple Inc. 171.05 -0.8 171.85 171.85 0
The Boeing Company 271.38 -5.42 276.8 269.3 7.5
Caterpillar Inc. 141.52 0.37 141.15 138.06 3.09
Chevron Corporation 119.51 0.52 118.99 117.18 1.81
Cisco Systems, Inc. 37.6 0.3 37.3 37.48 -0.18
The Coca-Cola Company 45.97 0.2 45.77 45.13 0.64
DowDuPont Inc. 71.01 -0.95 71.96 71.78 0.18
Exxon Mobil Corporation 83.46 0.17 83.29 82.27 1.02
General Electric Company 17.88 -0.41 18.29 18.48 -0.19
The Goldman Sachs Group, Inc. 248.95 1.31 247.64 241.36 6.28
The Home Depot, Inc. 180.42 0.6 179.82 177.25 2.57
International Business Machines Corporation 154.76 0.79 153.97 153.55 0.42
Intel Corporation 44.68 -0.16 44.84 44.84 0
Johnson & Johnson 139.98 0.65 139.33 139.81 -0.48
JPMorgan Chase & Co. 104.79 0.27 104.52 103.73 0.79
McDonald's Corporation 172.87 0.9 171.97 169.42 2.55
Merck & Co., Inc. 55.87 0.6 55.27 55.36 -0.09
Microsoft Corporation 84.26 0.09 84.17 83.34 0.83
NIKE, Inc. 59.88 -0.14 60.02 60.02 0
Pfizer Inc. 36.35 0.09 36.26 36.21 0.05
The Procter & Gamble Company 90.36 0.37 89.99 89.38 0.61
The Travelers Companies, Inc. 136.21 0.64 135.57 134.53 1.04
United Technologies Corporation 120.12 -1.33 121.45 118.16 3.29
UnitedHealth Group Incorporated 226.78 -1.39 228.17 222.13 6.04
Verizon Communications Inc. 51.25 0.36 50.89 49.9 0.99
Visa Inc. 110.73 -1.86 112.59 109.86 2.73
Wal-Mart Stores, Inc. 97.35 0.12 97.23 97.56 -0.33
The Walt Disney Company 105.25 0.43 104.82 105.24 -0.42 -
Charles Blaine commented
On your summary page for Amazon.com as of 12.2.17, you say Amazon closed on 12.1 at 1162.35, down 14.30. The prior close on the summary page is listed at 1161.17, which would suggest Amazon closed up 1.18 from Thursday. But your interactive chart says the actual close was 1176.75. Morningstar says the Thursday close was 1176.75. In fact, when I updated my numbers in spreadsheets I maintain over the weekend, I had to discard ALL of your prior day's closing data because it was from Nov. 29. Maybe the issue is we went from November to December. But you should allow for that.