Stockhistory function

Hi Birian,

thanks for your update.

here are some additional troubleshooting steps you can try:

1. Update Excel: Ensure you are using the latest version of Excel. Outdated versions may not support the latest functions. Check for updates and install any available updates for Excel.

2. Verify Add-ins: Sometimes, third-party add-ins can cause conflicts with Excel functions. Disable any third-party Excel add-ins temporarily and see if STOCKHISTORY starts working.

3. MacOS Permissions: Check if Excel has the necessary permissions to access the internet. Sometimes, MacOS may block certain applications from accessing the web. Go to your Mac's System Preferences, select Security & Privacy, and ensure Excel has the necessary permissions.

4. Check Your Region and Language Settings: The STOCKHISTORY function might have regional restrictions. Make sure your system settings, such as your region and language, are correctly configured.

5. Test on a Different Device: If possible, try using STOCKHISTORY on a different Mac or device to see if the issue persists. This will help determine if the problem is specific to your installation.

6. Try on a New Workbook: Create a new, blank workbook and try using the STOCKHISTORY function there. Sometimes, issues are specific to a particular workbook.