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.

16 Replies

  • Infio's avatar
    Infio
    Copper Contributor

    Eric9919Functionality seems to have returned this morning Feb 16, 23 8:30 CST.   Thanks everyone! Nice to have the data back,

  • Phil_Viney's avatar
    Phil_Viney
    Copper Contributor

    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

       

      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

        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

  • Infio's avatar
    Infio
    Copper Contributor

    Eric9919  Still having the same issue as of Feb 15, 2023 9:24 CST.  Sent a few notices via the data type card and giving feedback on the form to Refinitiv . 


    This error is really messing my files up.  Been two days of missing data now.   Please Microsoft get Refinitiv to resolve this.....this is one of the main reasons I use Excel.

  • Vega2677's avatar
    Vega2677
    Copper Contributor
    Spoke with tech support midnight last night. He told me they know about the problem and the engineers are working to resolve the problem. He said wait 24 hrs and retest. Let's hope they are able to resolve the problem soon.
    • mandero's avatar
      mandero
      Copper Contributor
      24 hours has been and gone...no fix yet it seems.
      • Vega2677's avatar
        Vega2677
        Copper Contributor

        mandero Yeah, I tested it again this morning and  N A D A!

        So disappointed! 

      • Hnorajr's avatar
        Hnorajr
        Copper Contributor

        Eric9919 

         

        facing the same problem in Brazil. Updates here stoped also on February 10th.

         

        help is need from Microsoft side !!

  • DismalDave's avatar
    DismalDave
    Copper Contributor

    Eric9919 

     

    I have same thing happening.

    Other than your post I see no other mention of it. 

    Except that over here we would say it happened on 2/10/23. 😉

Resources