'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Microsoft 365 Version Requirements for Excel STOCKHISTORY Function
Question details
The user needs to know the specific Microsoft 365 subscription requirements to use the STOCKHISTORY function and calculate stock percentage changes.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve historical stock prices and calculate a five-day percentage change in Excel for the web.
- Observed behavior
- The STOCKHISTORY function is blocked or unavailable because the user is operating on a free or unsupported Microsoft 365 plan.
Verify your current Microsoft account status by logging into your account portal to check if you have an active, paid Microsoft 365 subscription.
Upgrade to a Qualifying Microsoft 365 Subscription
The STOCKHISTORY function is a premium data type feature that requires an eligible paid Microsoft 365 subscription to work.
Microsoft restricts certain advanced financial and data type functions to premium subscribers. If you are using a free tier or a basic version of Excel for the web without an attached subscription, STOCKHISTORY will return a #BLOCKED! error.
Go to the official Microsoft 365 website and log in with the account you use for Excel.
Choose an eligible paid plan, such as Microsoft 365 Personal, Family, or a Business/Enterprise tier, and complete the upgrade process.
Close your current Excel session and reopen it. Make sure you are signed in with the newly upgraded account to activate premium data types like STOCKHISTORY.
Calculate the Five-Day Percentage Change Using STOCKHISTORY
Once you have access to the STOCKHISTORY function, you can extract the necessary prices to calculate your desired stock variance.
Manage Complex Spreadsheets with WPS Office
If you are frustrated by premium paywalls for essential spreadsheet features, consider trying WPS Office. It is a powerful, lightweight alternative to Microsoft Office that provides comprehensive formula support and seamless format compatibility without the confusing subscription tiers.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks to seamlessly continue your financial data analysis.
Frequently Asked Questions
Why does the STOCKHISTORY function show a #BLOCKED! error?
This error typically occurs when your Microsoft account does not have an active, eligible Microsoft 365 paid subscription. It can also happen if connected experiences are disabled in your Excel Trust Center settings.
Is the STOCKHISTORY function available in Excel 2019 or Excel 2021?
No, STOCKHISTORY is a dynamic array function and a premium data type exclusively available to Microsoft 365 subscribers. It is not included in perpetual license versions like Office 2019 or Office 2021.
Do I need the desktop app to use the STOCKHISTORY function?
No, the STOCKHISTORY function works in Excel for the web as well, provided that you are signed in with an account that has a paid Microsoft 365 subscription attached to it.
