Forum Discussion

Eric9919

Copper Contributor

Feb 14, 2023

STOCKHISTORY function

is your stockhistory function retrieving the latest stock? it seems mine stuck on 10/2/2023.

Formulas and Functions

Phil_Viney

Copper Contributor

Feb 16, 2023

Eric9919

Yes, same issue here. Any date post 10 Feb 2023 shows the #VALUE error for a non-trading day. I have spoken with MSFT support who say this issue has been reported and the developers are looking into it. ... with the usual apology for any inconvenience caused.

jnick13
Copper Contributor
Feb 16, 2023

This was the main reason I paid for a 365 license. And now for two days it's not working?

Please keep us posted,

Thank you
- Hnorajr
  Copper Contributor
  Feb 16, 2023
  jnick13
  I have two other excel licences that I decided to retired them and move to 365 version just because this function..... i thinking about to move back to excel 2013 and download data fom yahoo .... maybe more reliable.
  
  MSFT help is need !!!
  
  Thank you