Forum Discussion
365 STOCK DATA not updating all stocks
"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.com
Hi ..... 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.
