stock data in excel 365 not refreshing

Anonymous
2020-09-16T16:38:55+00:00

Is anyone having problems with refreshing stock data in excel 360?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2020-09-18T13:41:50+00:00

Thanks for your work on this problem Kaycee.

My system is refreshing as of 9:40am today.

Was this answer helpful?

10+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2020-09-18T17:55:18+00:00

Hello All, 

We believe we have corrected this issue and Stocks are refreshing again. Go to the Data tab in the Ribbon and select "Refresh All". You can verify an update occurred by observing the Last Trade Time field. Please note that depending on our agreement with the Exchange, some instruments will only provide new data after End of Day. See more about our data sources here: https://support.microsoft.com/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6 

If you're still experiencing stale data after refreshing, please reply to me with your location, platform, and the ticker symbol/name of the financial instrument that you observe not refreshing. 

We also hear your reports around the field "Market Cap" now being missing from the Stocks data. We are investigating this change and hope to have the field re-enabled soon. 

Lastly, we apologize for the frustration you feel toward the Stocks data type. We are going to reflect on this outage and digest your feedback, and hope to come up with a system to train customer support how to escalate outages and a surface to alert Status toward resolution. 

Thank you, 

Kaycee

Was this answer helpful?

9 people found this answer helpful.
0 comments

205 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2020-10-30T18:06:31+00:00

    I am currently having the refresh problem described above.  My system is a MacBook Pro 16" running macOS 10.15.7 and using Microsoft Excel for Mac Version 16.42.  I have an active Microsoft 365 Business Standard account.

    It was working great for a couple of weeks and then just stopped.  I used the "Last Trade Time" field as suggested and the last successful refresh was at 10/28/2020 at 19:52 Pacific Time.  I am located in the US.

    A sample failing update is MICROSOFT CORPORATION (XNAS:MSFT).

    Thanks for any help you can provide,

    Dave Martin

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-12-18T21:24:45+00:00

    I've been using the Stock Price function for a while now in Excel and it works well. Today, I entered a new stock - CLOUDMD SOFTWARE & SERVICES INC. (XTSX:DOC) and it returns a price from February 21, 2020. Today is December 18, 2020. I can determine that by clicking on the small building icon on the left of the name and it shows the current information. 

    How do I get it to update to today's price information? I have already hit 'Refresh All'.

    Thanks,

    Andrew

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-12-30T08:51:13+00:00

    Dear Kaycee, 

    I am experiencing the same issue in the last few days. I am looking up the stock price for JPM as well as the exchange rates GBP/EUR, USD/EUR, GBP/USD

    The last Trade time shows as 16 Dec 20 at 00:59

    Using Excel for Mac Version 16.43 in the UK.

    Grateful for any help.

    Thank you

    D

    Was this answer helpful?

    0 comments