Stock History not working since 09/04/2026

Question

Stock History not working since 09/04/2026

Gustafson, Dennis 35

Formula that works:

=STOCKHISTORY("MSFT",DATE(2026,9,4),DATE(2026,9,4),0,0,1)

Formula that fails:

=STOCKHISTORY("MSFT",DATE(2026,9,8),DATE(2026,9,8),0,0,1)

Error:

"The days between start_date and end_date are non trading days"

Additional observations:

Issue occurs with all tested tickers.
Historical dates prior to 9/4/2026 return correctly.
Dates 9/8/2026 and 9/9/2026 return the error.

Rex Withers 10 Reputation points

2026-09-15T12:53:48.39+00:00

Per advice in this thread I contacted Microsoft tech support. Spent 1/2 hour going thru testing with level 1 guy (based on theory that something is wrong in my computer) even though I showed him this thread. Then level 2 guy wanted to take over my computer to troubleshoot. When I said it's a known supply-side issue, he said "Microsoft has no known complaints and this isn't a known issue". I told him I might re-contact tomorrow (now Monday). But overnight there was an update to my Win 11 (I had been at latest Sept 8 version before) and now the problem has gone away. Strange.......
Rex Withers 10 Reputation points

2026-09-15T13:49:04.3166667+00:00

I looked closer; it is showing same Sept 8 update as current, so it would appear that there wasn't a Win 11 version update overnight; but something made my computer shut down and then reboot (I just put to sleep at night normally). So I have a theory -- maybe the Sept 8th update did have a fix, but it didn't take effect until a complete shutdown and reboot of the Win11 occurred. That isn't one of the diagnostic tests that we ran with the tech support team. Maybe that's important to get the fix activated.

Answer accepted by question author

Thomas4-N 21,930 Microsoft External Staff Moderator

Hello Gustafson, Dennis,

A few other threads this week describe the exact same cutoff at 9/4/2026:

stockhistory function not pulling data later than 9/4/2026
STOCKHISTORY DATA for 9/8/2026
The EXCEL function: STOCKHISTORY is only returning data up to Sep 4, 2026
Also flagged on the Tech Community, with the same date and no fix from reinstalling/repairing Office

Given how many independent reports line up on the same date, this looks like a service/data-provider side issue rather than anything in your workbook or formula.

Best step for now is go to Help > Send Feedback in Excel and report it (mentioning the exact dates missing) so it reaches the product team directly.

Gustafson, Dennis 35 Reputation points

2026-09-17T12:50:34.3066667+00:00

It looks like this was restored by microsoft on 9/16.

5 additional answers

Your answer

Rex Withers 10 Reputation points

2026-09-15T12:53:48.39+00:00

Per advice in this thread I contacted Microsoft tech support. Spent 1/2 hour going thru testing with level 1 guy (based on theory that something is wrong in my computer) even though I showed him this thread. Then level 2 guy wanted to take over my computer to troubleshoot. When I said it's a known supply-side issue, he said "Microsoft has no known complaints and this isn't a known issue". I told him I might re-contact tomorrow (now Monday). But overnight there was an update to my Win 11 (I had been at latest Sept 8 version before) and now the problem has gone away. Strange.......
Rex Withers 10 Reputation points

2026-09-15T13:49:04.3166667+00:00

I looked closer; it is showing same Sept 8 update as current, so it would appear that there wasn't a Win 11 version update overnight; but something made my computer shut down and then reboot (I just put to sleep at night normally). So I have a theory -- maybe the Sept 8th update did have a fix, but it didn't take effect until a complete shutdown and reboot of the Win11 occurred. That isn't one of the diagnostic tests that we ran with the tech support team. Maybe that's important to get the fix activated.
Gustafson, Dennis 35 Reputation points

2026-09-17T12:50:34.3066667+00:00

It looks like this was restored by microsoft on 9/16.

Answer 1

This matches a known service-side issue pattern with Excel stock data functions rather than a problem with the formula syntax.

The formula structure shown is valid:

=STOCKHISTORY("MSFT",DATE(2026,9,8),DATE(2026,9,8),0,0,1)

Relevant supported facts:

STOCKHISTORY accepts DATE(...) for start_date and end_date, so the date argument format being used is correct.
The function returns historical price data from an external provider.
There are documented cases where Excel stock data functions stop working due to temporary server-side problems, and the recommended action is to report the issue through Excel > Help > Send feedback.

Given that:

all tested tickers fail,
earlier historical dates still work,
the failure is limited to specific recent trading dates,

this points to missing or delayed market data availability for those dates in the stock data service, not a workbook issue.

Action to take:

In Excel, open Help.
Select Send feedback.
Report that STOCKHISTORY returns "The days between start_date and end_date are non trading days" for valid trading dates 2026-09-08 and 2026-09-09 across multiple tickers.
Keep using the DATE(...) form in formulas, since that is the recommended locale-safe format.

If the service recovers, the same formula should begin returning data without workbook changes.

References:

Answer 2

lawrence fish 10

Anyone know when this might be fixed? I have reported it at least once a day.

0 comments

Answer 3

Conrad de Villiers 0

Question still remains, when will Microsoft get this fixed? Have not seen a single acknowledgement or ETA from them and its been over a week now!

0 comments

Answer 4

Francesco Ortaggi 0

I have also been having this issue since early last week. Can't believe that it has been going on for so long without being fixed by Microsoft. I have just sent out feedback.

Rex Withers 10 Reputation points

2026-09-16T18:37:36.22+00:00

Since I had some problem for over a week, then it mysteriously fixed itself -- and only thing that happened is my laptop appears to have rebooted overnight. So, curious if you tried total shut down and reboot. Is it possible it's service-side generated, but still somehow a reboot can clear it up ?
Francesco Ortaggi 0 Reputation points

2026-09-16T18:42:50.9666667+00:00

No, I just rebooted this afternoon but unfortunately it seems it didn't fix the problem. Thanks for your suggestion anyway.
Francesco Ortaggi 0 Reputation points

2026-09-16T19:56:22.81+00:00

Actually I have just checked again and now it works. It's possible that in the end the reboot solved the issue.