Forum Discussion

hedgolfer's avatar
hedgolfer
Copper Contributor
Jan 23, 2025

STOCKHISTORY function returns random #CONNECT error

I have multiple spreadsheets using STOCKHISTORY for multiple stocks. I have been recently getting random #CONNECT returns for some stocks and not others for the same date. Opening the same sheet on a separate computer may show all valid results. It can be very frustrating to open a spread sheet and not get values for all stocks in a column. What is going on with there server

1 Reply

  • JudeHill's avatar
    JudeHill
    Iron Contributor

    STOCKHISTORY retrieves data from financial data sources. Sometimes, these sources may experience outages or delays, affecting the ability to fetch data.

Resources