Forum Discussion
StockHistory Issue #Connect! Error
I built a workbook around the StockHistory function to track the stocks in the S&P 500. I did this a few months ago and I update it once a day. Each stock is presented according to which SPDR Sector ...
I have an issue where I get #connect errors for stock symbols on some days but not others. I have ensured all days are days markets are open and tried retyping the equation in the column/new column and copying/pasting from a cell where equation is working.
Any suggestions on why I am getting this error for only certain dates would be appreciated, thank you.
Any suggestions on why I am getting this error for only certain dates would be appreciated, thank you.
I believe it is a data problem from Microsoft's data supplier Refinitiv. Just try it later, that always works for me.
Thanks, any other tips? I have been getting this error for the past few weeks every time I open the excel workbook.
- You do have Microsoft 365 right? That I think is the only version that these dynamic arrays work on. One question, do some of your items connect while others don't? If so, try saving what you have and re-opening the workbook and see if the rest load.
