This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is anyone having problems with refreshing stock data in excel 360?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Thanks for your work on this problem Kaycee.
My system is refreshing as of 9:40am today.
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 answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Hi-
My price data is also updating properly now - NYC, Excel 365 on a Mac. Not sure if this is a related issue, but the same time the price data issue started, the [market cap] data seems to have been removed? I have a couple of spreadsheets I have used for months that had both price and market cap (i.e =D8.[Market cap] ).
The market cap cells in the sheet now don't populate and 'market cap' is no longer even an option. Was this intentional or somehow related to price data problem that is now solved? I know there is workaround by using shares outstanding x price.
Thanks again!
Ontario, Canada. Data is being updated but not all of the prices are correct (I suspect they are old prices).