Refreshing stock prices in excel spreadsheet: prices are 24 hours stale.

%3CLINGO-SUB%20id%3D%22lingo-sub-1675937%22%20slang%3D%22en-US%22%3ERefreshing%20stock%20prices%20in%20excel%20spreadsheet%3A%20prices%20are%2024%20hours%20stale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1675937%22%20slang%3D%22en-US%22%3E%3CP%3EBeginning%20yesterday%2C%20I%20had%20trouble%20getting%20up-to-date%20stock%20prices%20in%20an%20excel%20spreadsheet.%20Late%20yesterday%2C%20after%20multiple%20refreshes%2C%20the%20prices%20were%20updated.%20Today%2C%20however%2C%20the%20prices%20never%20did%3A%20%5BPrevious%20Close%5D%20is%20giving%20the%20September%2014%20price%20and%20%5BPrice%5D%20is%20giving%20the%20September%2015%20prices.%20Today%20is%20September%2016%2C%20so%20those%20prices%20should%20be%2C%20respectively%2C%20September%2015%20and%20September%2016.%26nbsp%3B%20Is%20there%20a%20problem%20with%20a%20server%20that%20is%20supposed%20to%20be%20supplying%20current%20prices%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1675937%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676317%22%20slang%3D%22en-US%22%3ERE%3A%20Refreshing%20stock%20prices%20in%20excel%20spreadsheet%3A%20prices%20are%2024%20hours%20stale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676317%22%20slang%3D%22en-US%22%3EI%20got%20exactly%20the%20same%20problem%20.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676823%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshing%20stock%20prices%20in%20excel%20spreadsheet%3A%20prices%20are%2024%20hours%20stale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676823%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F796507%22%20target%3D%22_blank%22%3E%40Jonathan_Leight%3C%2FA%3E%26nbsp%3BSame%20problem%20here.%20Even%20when%20looking%20at%20the%20%22Details%22%20it%20cites%20the%20last%20trade%20time%20as%20being16%2F09%2F2020%2000%3A00%2C%20which%20would%20be%20yesterday%20at%20midnight.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Beginning yesterday, I had trouble getting up-to-date stock prices in an excel spreadsheet. Late yesterday, after multiple refreshes, the prices were updated. Today, however, the prices never did: [Previous Close] is giving the September 14 price and [Price] is giving the September 15 prices. Today is September 16, so those prices should be, respectively, September 15 and September 16.  Is there a problem with a server that is supposed to be supplying current prices?

7 Replies
I got exactly the same problem .

@Jonathan_Leight Same problem here. Even when looking at the "Details" it cites the last trade time as being16/09/2020 00:00, which would be yesterday at midnight.

Same here.  The stock feature is the only reason I need to continue subscription to Microsoft Office.  Possibly time to look for an alternative....again.    @Jonathan_Leight 

Same problem for me....MS Finance is able to show correct slightly delayed prices.
@ms - please update the date frequently. Thanks

Me too; Chatted with MS Tech Support. They seemed not only unaware of the problem, but the rep didn't seem to understand where the data is coming from. He asked me if I knew who housed the data source ... so ... I politely exited the chat given that I'd spend more time helping them understand the problem than I could afford ...  

I had a similar problem and even joined MS 365 help forum.......they had no clue.
This is the only reason I subscribe to MS 365 so the problem needs to be fixed.

Does anyone know how to escalate to MS??