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 has to do with the Microsoft partner who is providing the data. they don't want it to work. and not for professional use or you be paying a lot more for data. it's suppose to be for fun right? not for 'professional use' so who cares if you are not getting quotes right? if you are using the stock data quotes for professional use and it doesn't work for a week, you are losing money and the stress could affect your work. A professional would not use these data provider that microsoft is paying peanuts for. Either microsoft is unwilling to pay for the data quotes or the problems are deliberate, and don't want it to work. there is a disclosure saying the quotes are not for professional use so who cares if the stock quotes flaky software. if your only reason for subscribing to excel is for the stock quotes etc. getting another quote provider. they pay charge like $40/month using the web interface or javascript to pull quotes into browser. instead of using excel. excel is just like a web browser if it can retrieve data from the internet.
Current Currency Exchange Rates were working normally. Only StockHistory was broken. Historical data is likely scraped by Microsoft and kept on their servers. It would make no sense for them to keep "annoying" a third party service with repeated requests instead of using their own servers.
It's weird their software presented a licensing error message instead of something else related to the data obtained.
- Might be a matter of time that the function ceases to work. All the hard work and prior files saved for each month become useless. Time to backup the data with the actual historical data manually.
Unless there are lower cost paid 3rd-party services that replaces the stockhistory().
Anyone know about this?- Well, if it's in our spreadsheets already and not broken we can copy then paste over "values" (special). That locks in whatever is there already.
Excel should keep that information, though, and only update it if there's newer on the server, so we should have previously historic data stored in our local files. I guess they don't do it to break things if we stop paying them? Or perhaps it's just bad implementation?
I don't use Google or Open Source applications to open my excel files, but I wonder what happens if you use those with the same formulas. Shouldn't our files be compatible? Or will it be broken if you open an excel spreadsheet on google sheets (or whatever they call it) or open office?- That is something we all may need to evaluate. I will certainly save the files again as "values". I am very sure one day this function may cease to work. Or maybe Ms provide a paid service in the future, and if it is priced low/fairly, might consider taking this up. Bad implementation...no idea. Though lately Windows updates haven't been managed effectively. It just bring anxiety.
But it adds to a worry of wasted effort when it fails.
