Share via

Microsoft365 Intraday Data

Anonymous
2023-06-26T16:43:33+00:00

I am based in the UK. I have a 365 subscription and utilise Stockhistory. However, this is not updating intraday?

For example, I use the following for SPY Ticker:

=STOCKHISTORY(H3,H4,H5,0,0,0,2,3,4,1)

Where H3 = SPY

Where H4 = 01/01/2022

Where H5 = 26/06/2023

(With this question being posted on 26th June during the time when the US Market is open. However, data is only coming through to the last close of Friday 23rd June)

Microsoft 365 and Office | Excel | For education | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-27T05:42:33+00:00

    It could be sync issue at source side. Hope it will be fixed soon.

    About the Stocks financial data sources - Microsoft Support

    If issue still remain, could you share a test file with some dummy data in it to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Was this answer helpful?

    0 comments