Forum Discussion
Solved
Stockhistory function is suddenly blocked
I have been a subscriber of office 365 and regular user of stockhistory function in excel for past 3 years. Today , all of sudden, my excel shows me error that I need to sign in with an account asso...
- 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.
I don't know if that's the case, even though you make a good point.
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.
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?
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.