Forum Discussion

Copper Contributor

Aug 11, 2022

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 ...

excel

Excel on Mac

Formulas and Functions

office 365

Acnitz

Copper Contributor

Jun 12, 2023

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.

djgabel

Copper Contributor

Jun 12, 2023

Acnitz

I believe it is a data problem from Microsoft's data supplier Refinitiv. Just try it later, that always works for me.