Forum Discussion

amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023
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...
Formulas and Functions
  • amit1601's avatar
    amit1601
    Jul 11, 2023
    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.
Kmp8160's avatar
Kmp8160
Copper Contributor
Jul 11, 2023

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?

amit1601's avatar
amit1601
Brass Contributor
Jul 11, 2023

Kmp8160  mentioed earlier in thread - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.

Resources