Forum Discussion
Stockhistory function is suddenly blocked
- Jul 10, 2023No 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.