Excel STOCKHISTORY() function repeatedly encounters #CONNECT! error.

Anonymous
2024-08-19T21:41:33+00:00

Hi Team,

I spent over 2 hours troubleshooting this issue with an advocate in Office support (7*********0). He worked very hard to understand and resolve the issue.

We tried numerous resets: the network, uninstalling and reinstalling office, updating office, powering down, and restarting the computer. Nothing helped.

The issue occurs in approximately 20% of the values for a list of stocks and one date. It occurs in a similar percentage of dates for a single stock.

Ultimately we discovered that creating a new spreadsheet and typing or pasting the formula into an empty cell will not result in the #CONNECT! error. But this does not work in previously created spreadsheets.

Please check on this as soon as possible. This is a critical function for applying Excel to stock research.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

54 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-29T16:41:09+00:00

    Spoke too fast. I am getting data for all stocks, but the dates are all wrong.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-29T16:32:06+00:00

    Well, as of 11:31 am US Central Time, it's working again... Fingers crossed.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-29T16:21:16+00:00

    I am currently requestin 10 years of monthly closes, so it's not a very large amount of data, and am still getting 90% errors...

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-29T16:02:36+00:00

    Thankful it's not just me. I usually like 15 to 20 years worth of history, but with this current issue once I changed the period to under 100 it gives me data for all stocks. Although not useful in my spreadsheets it may benefit someone else on this thread.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-08-29T13:37:06+00:00

    Hi Thomas,

    I appreciate your trying to help as, I am sure, others do, but as of 8/29/2024 the issue persisits. Is something else being done? Asking people to be patient for such a long period of time is really not right, given how much users rely on these updates when they use the function.

    I would really appreciate an update on the issue, along with an ETA for a fix.

    Thank you.

    Was this answer helpful?

    0 comments