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

John 0 Reputation points

2026-09-16T23:26:24.93+00:00
Here's what worked for me (not clear why a reboot would work for others):
1. Make sure the stock ticker is in a cell rather than embedded in the formula.
2. Highlight the cell containing the stock ticker symbol.
3. Go to the data menu, and select Stocks. This looks up the ticker, and resolves which exchange the quotes come from. If there's a conflict select one.
There's a nice little data type card associated with the resolved ticker that's available with a right click.

Using the "MSFT" example: Be careful to select from NASDAQ, SIX (Swiss), or Santiago. Other tickers may resolve directly/automatically.

Alternatively, replace your hardcoded references like "MSFT" with "XNAS:MSFT"
Was this answer helpful?

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Stock History not working since 09/04/2026

5 additional answers

Your answer