Forum Discussion
#CONNECT! Error - Stockhistory down?
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn't. I can change the time period, shorter or longer, and it just seems random when it decides to retrieve the data or not
I am getting the same error. It started this morning. Stockhistory loads for some stock (e.g., TSLA, CRWD) but not for others (e.g., AAPL, NVDA). I think this has happened before and was fixed after a couple of days.
- about a third of a list of 60+ stocks are affected. Close the workbook and reopen it, a different batch from the same list is affected. Has been like that since saturday morning, and continues today, Sunday.
rifhickman I have the same issue (on the 20th). Changing the date range fixes the issue some of the time, but only temporarily.
- I use my stock list to generate 5 year monthly prices, and the same list for 13 weeks last close and 5 days last close. The #connect occurs arbitrarily across all 3 lists. Any single stock has the #connect in any, and sometimes all the columns. It is almost certainly not in the excel arena
Stockhistory is definitely not working. I update every Saturday. It was fine Aug 10, 2024, but not Aug 17, Hope they fix it soon.
- Likely related to bulky requests? Though this has never been an issue before
- Update on my side - looks to be excel deliberately throttling the data, only workaround is to stagger the formulas and/or to delete the cell with the formula in and re-paste it in.
So now will have to make some vba to check if the #CONNECT! error is in the cell, and if true, will have to delete the formula in the cell and repaste it in until it finally provides the data. Unless of course this is a temporary issue Anyone else getting this error message? Microsoft is going to force me to get another data feed. This is ridiculous.
- I discovered if I open the workbook and wait 5 or 10 minutes, eventually formulas with STOCKHISTORY(...) will randomly update. It takes a lot of patience.
Same issue. Started Friday night. Every time I reopen the file a different set of fund/date combinations have the error. Contacted Microsoft today and they claimed it was a server issue on their side and that they are aware of it and are working it. No expected date of completion though….
- #connect is returned arbitrarily in a list of 60 stocks. Sometimes more than a third of the stocks fail with #connect. After closing and reopening the workbook a different selectiopn of stocks fail. This has been occuring on every attempt since 16th August. It was also experienced during the previous two weeks but to a much lesser extent.
