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 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.
- Hi All, I'm trying the same thing - do we know why sometimes its really fast and sometimes it takes ages to refresh? also do you find always that in the daily price data there is a N/A in row 32 - id the 32nd day after today() ?
