Forum Discussion

Eric9919's avatar
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's avatar
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's avatar
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's avatar
    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

Resources