Forum Discussion

willsportfolios's avatar
willsportfolios
Copper Contributor
Aug 17, 2024

#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...
Excel
Formulas and Functions
J_Woolley's avatar
J_Woolley
Copper Contributor
Aug 19, 2024
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.
  • srv97229's avatar
    srv97229
    Copper Contributor
    Aug 19, 2024

    J_Woolley 

     

    The CONNECT errors seem to be dependent on the date used. I experimented with date changes and found that some Connect errors go away and new ones show up. Almost looks like a sparse matrix of data for a given stock. It should not be date dependent of course.

Resources