stockhistory

The important clue is that TODAY itself is stuck on 4 September. Start with calculation settings before assuming the market-data service stopped updating. In desktop Excel, open File, Options, Formulas and set Workbook Calculation to Automatic. Then enter =TODAY() in a blank cell formatted as a date and verify that it returns the current date. Check the computer's date as well. Once TODAY is correct, reopen the workbook and check whether your STOCKHISTORY end-date argument references TODAY or a cell containing it, rather than a fixed September date. Microsoft documents that STOCKHISTORY refreshes when the workbook opens if it uses an updating function such as TODAY and automatic calculation is enabled. Historical prices generally become available after the trading day completes, not continuously during trading. If the result still ends on 4 September, share the exact formula, ticker, interval, Excel version, and corrected TODAY result.