Forum Discussion
Stockhistory function is suddenly blocked
- No update on how and when it will be resolved. But I've a work around that you can do - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.
it works after going to account and switching licensing and re-entering email and accounts. which indicates their is a problem with licensing authentication, security issues, there, server is receiving too many request. as stockhistory can receive dates up to 365 days. The server needs to put limits in how many quotes or symbols you can request like max 200 symbols etc or how many stockhistory. dates Each quote request puts load on the computer. Some financial websites even charge per quote. if you have tonnes of quotes that puts too much load on the server. or a denial of service attack. the problem seems to go away after I go to account. in excel. switch license to 365 office instead of the home and student version and getting any updates which is probably security updates. Either some people who are not 365 subscribers maybe sending too many request even though they are not subscribers and resulting in denial of service on the server. if people have like 1000 symbol quotes on their spreadsheet it too many for updating and crash the server, I doubt anyone can monitor 1000 symbols in their portfolio.
You may have multiple recurrencies for the same symbol on a large spreadsheet. I use it to convert currency across the time. I don't know how many occurences I have but if you consider 4 or 5 currency conversions per month and about 5 to 7 years, that makes about 300 ~ 400 recurrencies, even though only a few tickers are used, each quote for each time is a hit.
I had not only done what you said but I went steps further including the entire removal of Office 365 from my computer and a full reinstall. I also tried moving back and forth insider. And MS support were also aware of all steps involved as well, which didn't fix it.
But, yes, what you say is what occured to me because the error was related to licensing. This functionality broke before and was restored. I guess they might have changed something or they might have lost access to a data stream at some point.
Let's hope everything stays consistent from now on. Interesting to not have an official note from Microsoft on this. It would be useful.
Also, perhaps our files could store the information that's already downloaded and only change it if there's something valid from the server, otherwise keeping the existing calculations intact while just showing an error message to let us know the information being used might be innacurate. That way we would be able to continue to work even if that meant having a larger file in our systems.
I've posted another post on this issue and any future issues with stock data and stockhistory not working.
1. security updates for 365
2. check ALL connnected services on privacy settings in excel on
there is no need to send microsoft any diagnostic data and but they do need online content access for authentication on the experiences that analyze your content under connected 'experience' the wording is confusing. and people uncheck thinking they are sending personal information to microsoft.
you have to check all the CONNECTED EXPERIENCE section on the privacy setting to get online data like stocks, geography, currencies. those are ONLINE data and dynamic
FILE
OPTIONs
GENERAL
---scroll to privacy settings.. that is where most people get issues for no stock data. you need to give excel authorization to have access to online content or it won't work.
Reset licensing of 365 office again if you had home an office standalone. don't select that.
there is no way to uninstall home an office versions if you had them before on windows 10.
home office and student standalone don't have online connected services like stock data and stockhistory. you need a 'subscription' to receive those quotes.
The problems occured right after July 11 security updates for 365 and probably too many hacks trying to access the the data provider servers and not subscribers. or something.
As for currencies, the selection gives ETF etc. but who cares, anyone who does currencies can get that data for free anywhere for free from banks free of charge unlike stock exchanges who charge subcribers for stock quote and options quotes.
Again, there is no need to reinstall office 365 to get it to work, you'll just waste 1-3 hour of your time doing that.