Forum Discussion
willsportfolios
Aug 17, 2024Copper Contributor
#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
- J_WoolleyCopper ContributorExcel's STOCKHISTORY function was not working correctly for about one week. It seems to be fixed as of Aug 23, 2024.
- ShootersGottaShootCopper Contributor
J_Woolley still having issues with the correct data coming in, it just repeats itself before it completes the data. For example, MSFT will give me the proper OHLC data starting at 3/13/1986 to 7/22/2010 then it goes back to 3/13/1986. Then the second time around it makes it to 4/15/1994 before resetting to 3/13/1986 again. This keeps repeating over and over again until it can get a full set of data from 3/13/1986 to today. Without these repeating sets, the data should only be around 9,700 rows, but the way it repeating incomplete sets of data, it now has 50,650 rows before it finally reaches the correct end date.
I’ve tried checking for updates, logging out, restarting, logging in a bunch of times. Even tried upgrading and downgrading from Preview, to Beta, to nothing and the results remain the same. Don’t think it’s anything on our end. Has to be a problem from Microsoft itself. Hopefully this resolved by Monday before markets open.
- J_WoolleyCopper ContributorAre you using Excel version 2408?
- rifhickmanCopper ContributorAlmost a week from the first occurence of the issue, and today I got 100% data returned (63 stocks out of 63, with 5 diffrent date ranges and data selections)
- adpathania1Copper Contributor
rifhickman How did you manage to get it fixed? My excel is still not pulling data for more than 50% of the stocks i'm using stockhistory on.
- rifhickmanCopper ContributorJust opened excel, and it was fine
- lalitchattarCopper Contributor
willsportfolios facing same issue Getting #connect error for random stock. I used to load 20 days low for 500 stocks but since last week it started giving #connect error
- rifhickmanCopper Contributor#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.
- dab662430Copper Contributor
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….
- J_WoolleyCopper ContributorI 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.
- siasinaCopper Contributor
Anyone else getting this error message? Microsoft is going to force me to get another data feed. This is ridiculous.
- J_WoolleyCopper Contributor
Stockhistory is definitely not working. I update every Saturday. It was fine Aug 10, 2024, but not Aug 17, Hope they fix it soon.
- rifhickmanCopper Contributorabout 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.
- JohnS1120Copper Contributor
rifhickman I have the same issue (on the 20th). Changing the date range fixes the issue some of the time, but only temporarily.
- rifhickmanCopper ContributorI 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
- willsportfoliosCopper ContributorUpdate 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