Forum Discussion

DismalDave's avatar
DismalDave
Copper Contributor
Feb 14, 2023

Stockhistory function appears to no longer be updating past Feb 10 2023

From what I can see, the Stockhistory function has stopped pulling data.  Last date of data is Feb 10 2023. It does not give data past that date. It is not giving an error. It will pull older data b...
excel
Formulas and Functions
FSBassett's avatar
FSBassett
Copper Contributor
Mar 09, 2023

DismalDave  

I am having the same problem.  It is delayed in giving me the true last day's closing price.  I'm getting the price of the stock two days ago when I use TODAY() as my end date input.  And it's inconsistently updating several stocks I have in the same worksheet.  Some stocks will show a last close date of two days ago and some will be a different date.  This is very frustrating.  WHY CAN'T MICROSOFT JUST FIX THIS ALREADY!?  

 

I should note that the tickers I'm looking at are all for mutual funds, not individual stocks.

Yen_Limau's avatar
Yen_Limau
Copper Contributor
Mar 09, 2023
Is there a Microsoft channel that we can collectively provide feedback to?
  • DismalDave2ndtime's avatar
    DismalDave2ndtime
    Copper Contributor
    Mar 09, 2023
    This is all I have found. I have an account through the college I teach for. When I go to leave 'feedback' in Excel it says to talk to the site admin. So, I can't even do that.

    By making the heading of this something that the google would pick up on and that hopefully would get enough views to become obnoxious I was hopeful that MSFT would look at it. I excel in obnoxious.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 09, 2023

      DismalDave2ndtime 

      yes, if you are on business/educational account providing feedback from the app could be disabled by the company organizational policy.  However, Excel · Community (microsoft.com) always works. Add your feedback here and ask other people to upvote providing the link. How many people viewed doesn't matter.

      • DismalDave2ndtime's avatar
        DismalDave2ndtime
        Copper Contributor
        Mar 09, 2023
        Does the number of upvotes help get the issue looked at?
        I know this has had a large number of views and comments.
        Looks like you know how this system is managed. Is there one of those that gives a bigger flag to folks watching?

        I made the initial post and then had problems logging back in, so made another account. So I can't modify the main post. I can mess with the one right under it. I have been updating that one as system goes up and down.
        To me, this looks like the only place we can find info on status when we let each other know what our one data point looks like. MSFT has no way for us to see status on Stockhistory so we don't know if it's us or them. Until it's all of us, and then it's them. 😉

Resources