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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2025-02-04T01:38:09+00:00

    Hello

    It looks like the problem with =stockhistory is back. Anyone else getting errors?

    Regards

    Mario

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-02-04T01:52:28+00:00

    Breakdowns have been occurring sporadically for the past few weeks every other day or so. Then the problem goes away after time - varying from a few minutes to overnight. I've also found that closing and reopening the workbook sometimes, but not always, helps. I've also found that the problem may occur on one workbook but not on another at the same time.

    Errors are usually CONNECT! or SPILL! errors.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-02-04T16:43:21+00:00

    When I first heard of this I thought it was great and used it for a couple years.

    Now that it is so unreliable and flakey I stopped using it.

    I don't have time to fiddle with something that I cannot rely upon.

    I do lose some functionality by using just the stock | data function in MS Excel but it has proven reliable and gets me to 90% of what I want/need.

    If I were more used to Google Sheets I "suspect" it might provide a good substitute.

    Today, without it, I'm up $758.49 on two option trades (BROS call, CLS vertical spread) and SSYS (200 shares of stock).

    So, I've learned / created other tools that get me to where I want to go.

    Dave

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-02-04T21:40:49+00:00

    Thank you for your reply and comments

    Indeed, its a problem when you have a system that relies on this information to make trading decisions.

    Everything seems to be working today, so it is intermittent. The problem is that it fails when you least expect it and most need it, lol

    Congrats on your option wins, I trade several strategies myself and one day hope to create a bot for some systems strategies that I am backtesting

    Hope this stays fix for good

    Regards

    Mario

    Was this answer helpful?

    0 comments