Forum Discussion
stockhistory
my stockhistory function returns value up to 4sept only. today() is stuck at 4sep
3 Replies
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.
Jamony,
Thank you for the reply and sugestions.
I verified the Workbook was set on Automatic Calculations. I entered the date function in a blank cell and it returned the correct date (9-14-26). My computer is also displaying the correct date (9-14-26). I understand stockhistory generally is not updated until after midnight after the market closes. I am getting NO stock data after September 4th. A full week of data is missing.
here is the formula I am using:
T5 is ARCX, S5 is SPY AJ1 is 607
The first data returned
The last data returned:
same issue on this forum...FYI
https://techcommunity.microsoft.com/discussions/excelgeneral/stockhistory-function-not-updating-since-7th-september/4554918
