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 No 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 No 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 No comments

205 additional answers

Sort by: Newest
  1. Anonymous
    2022-02-19T20:30:48+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

    This seems to be an issue again (with me at least) and has been for the last few days.

    Thank you.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2021-12-29T18:52:41+00:00

    Is this the right place to report missing stock data? I still don't get if the whole process of adding missing data is done manually. Does have anyone any advice? Daimler Truck is still missing. Thanks!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2021-12-16T18:02:53+00:00

    Daimler Truck is still not available in the stocks function. I kindly ask to add the missing stock.

    Besides that I am really interested to know, why this is an issue at all. Is there really the need to add stocks manually to the system and solve problems with stocks that don't update? Why can't excel provide the data as any broker? This is no offence but my real interest to understand why those problems occur from time to time. Thanks.

    Was this answer helpful?

    0 comments No comments