Forum Discussion

amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023
Solved

Stockhistory function is suddenly blocked

I have been a subscriber of office 365 and regular user of stockhistory function in excel for past 3 years. Today , all of sudden, my excel shows me error that I need to  sign in with an account asso...
Formulas and Functions
  • amit1601's avatar
    amit1601
    Jul 11, 2023
    No update on how and when it will be resolved. But I've a work around that you can do - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.
TheSimArchitect's avatar
TheSimArchitect
Brass Contributor
Jul 11, 2023
They are working on it, I think because I don't get the licensing error anymore, upon opening the spreadsheet.

Your method did not work here, though. Sadly.
MikuSippy's avatar
MikuSippy
Brass Contributor
Jul 11, 2023

TheSimArchitect 

 

Look like MS fixed the problem. The function now works across all the workbooks. Stocks and exchange rates. The figures are also correct as of 10 Jul 2023 because I am in Asia. So I should wait a few more hours for the 11 Jul 23 data to work. For now I shall assume it is OK.

  • TheSimArchitect's avatar
    TheSimArchitect
    Brass Contributor
    Jul 11, 2023
    It is already 12/7 in The Netherlands but the problem persists, sadly.

    StockHistory function still broken on both web and regular versions of Excel, sadly.
    • MikuSippy's avatar
      MikuSippy
      Brass Contributor
      Jul 11, 2023
      I pray this is an isolated case for a few people. I just need the data as at 10 Jul 2023 to prepare the calculations. I also hope the whole thing can be fixed by this week. I am in Asia, and it is also 12 Jul. Of course the data is not yet updated for 12 Jul at MS servers (as I usually understand). The latest data for 11 Jul should by 12pm here. (Usually 24 hours behind as I have observed).

      Keeping fingers crossed.
      • TheSimArchitect's avatar
        TheSimArchitect
        Brass Contributor
        Jul 11, 2023

        MikuSippy 

         

        Are you able to use yours?

         

        It seems that now StockHistory works!

         

        But I have it wrapped with SumProduct and that function is causing the error now, when it worked just fine before. 

         

        Oh yes, I used SumProduct because Excel returned it as an array, not as a number, therefore SumProduct was necessary to make the quote usable.

         

        They didn't change the description of the command on their knowledge base. Is excel behavior going to change and we're supposed to edit our spreadsheets to account for it?

        I will need to check why I was using SumProduct to wrap it, I likely fixed another issue following advice from someone on line a very long time ago. 😬

         

        But that's good, nonetheless.

Resources