Forum Discussion
365 STOCK DATA not updating all stocks
Feedback from Microsoft:
Ziwei (Microsoft)
Thursday, September 17, 2020 4:06 AM GMT
Hello ---------,
Thank you for the time on call and remote session. Sorry for not able to provide enough help on this issue as Excel function is out of our support scope. As I checked again with your issue, there was a similar issue in Microsoft community at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_officeinsider-mso_win10-msoinsider_excel/excel-stock-data-not-updating/9f38914e-0a0b-47d0-a821-b4bded75c4ce?page=1. According to the reply, this should be a service incident between the data provider and Microsoft server, which should be fixed in several days. If you would know more about it, kindly contact https://www.refinitiv.com/en/contact-us.
Same issue shows on my Excel so I believe there is no setting error on your side. Unfortunately as we do not support Excel I don't have resource to confirm it is an incident and its expected service restoring time. As you can see at https://support.microsoft.com/en-us/office/support-options-for-microsoft-office-application-issues-for-office-365-subscribers-0a02cd18-19be-4cfa-b430-3b53ea26920f?ui=en-us&rs=en-us&ad=us, office application usage issue is covered by non-cost technical support https://social.technet.microsoft.com/forums/office/en-us/home, and cost technical support https://support.microsoft.com/en-us/premier. Apologize again for we do not have the needed resource for you as Microsoft 365 technical support team.
Thank you for choosing Microsoft Online services. If you have any concerns just feel free to let us know.
Best Regards,
Violet
Microsoft O365 Ambassador
Working Hours: 9:00AM – 6:00PM (UTC+8) | Monday - Friday
If you have any feedback about my work, please do not hesitate to contact
My Manager Ronald Tjoanda at Email: v-ronat@microsoft.com
"Apologize again for we do not have the needed resource for you as Microsoft 365 technical support team."
This is not acceptable! I am paying for a subscription of Office 365 specifically for stock data updates. There must be somewhere in Microsoft that you can send this problem to. If Refinitv is supplying the data for Microsoft then Microsoft must be paying for it. You would think that they would want to know when they are paying for something that they are not getting.
This is the msg. from support team. They just want to close my ticket & saying they are done.
Response:
Good day and I hope you are well.
This is Richard from xxx team. I’m the Senior Engineer of Violet. I am contacting you regarding your service request: xxxxxxxx- In excel Stocks function is not working.
I would like to follow-up if everything is now going fine. I can see that as issue is now addressed and clarified. I’d to inform you as well that this issue is out of our scope of support. With your permission, we will proceed to archive the case as resolved.
If you still need any help, or if you have questions, clarification or concerns regarding Office 365, please do not hesitate to let me know by replying to this email. At the same time, feel free to contact or loop our Team Leader and Team Manager to make sure that we are not going to miss any of your follow up. Please refer to the contact information below:
Allen Talidro
Team Leader
Email address: v-alltal@microsoft.com
Ronald Tjoanda
Team Manager
Email address: v-ronat@microsoft.comHi ..... there is no change to my 365 spreadsheet !!!! The dat is still not updating and I cleared my cache and did a reboot. NOT WORKING
Hi there! I have also tried switching accounts, going with online excel but no luck! Also nothing in Account privacy settings. I also tried shutting off my antivirus & firewall etc but no luck. I had put extensive amount of work to develop my spreadsheet using VB programming now without STOCK data currently everything is dead. (Almost 6 months of work)
Now I don't think Microsoft would be any help. if they can not fix I will try google spreadsheet.
Use the GOOGLEFINANCE function
- In https://sheets.google.com/, open a spreadsheet.
- In an empty cell, type =GOOGLEFINANCE.
- In parenthesis, add any of the following, separated by a comma:
- A ticker symbol in quotation marks.
- (Optional) The https://support.google.com/docs/answer/3093281 you want to show, such as price, in quotation marks.
- (Optional) A start and an end date preceded by DATE and followed with the numerical date in parenthesis.
- (Optional) Daily or weekly frequency in quotation marks.
- Press Enter.
Issue does not seem to be resolved for me - stock values are still stuck on 9/15/20 and will not update - not sure if it is working yet for others.
