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 too have the same problem since 10th July 2023. STOCKHISTORY() shows #Blocked error message. I am a subscriber of MS Office 365 and I am always logged in while using Excel. Is there any alternate way to bring NSE Stock Historical Data into Excel in an automated way?
This function have had a few problems lately. At one time for 4 days there no updates to the stock data as well as exchange rates from 11 Feb 23 to 15 Feb 23. There will be blank or NIL data.
- MikuSippy I remember the four days of February...miserable.
- OH YES! Horrible, the immense pressure to deliver the work and the hand-wringing times to find an alternative solution(s).