Share via

Cannot use stockhistory

Anonymous
2021-02-01T21:09:31+00:00

Hi, I am using excel to access stock data. It works well with Microsoft 365 subscription. I can get stock price, etc. However, the STOCKHISTORY function did not work. Nothing shows up. The stockhistory function did not even pop up as a known function as I type. I looked at this page, https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338, it seems STOCKHISTORY is fully available to all 365 subscribers. I contacted supported twice and re-installed Microsoft office. Still not working. Can anybody help me with this? Greatly appreciated!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2021-02-02T00:44:16+00:00

    Hi XiaojunLiang!

    Try performing an Online Repair and see if it fixes the issue.

    Follow these steps: Right-click the Windows Start button.

    Select "Apps and Features" on the pop-up menu.

    Find and click your Microsoft Office 365 application in the list.

    Select Modify, then "Online Repair" and follow the onscreen instructions.

    Once the fix is applied, restart your computer and re-try opening excel to check if the function shows up.

    Let me know if this works. If you have any questions, please let me know and I'd be glad to assist you further.

    Thank you and Best Regards!

    Jen :)

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-04-06T16:35:48+00:00

    Same problem here, running subscription based office 365 ProPlus. Stockhistory does not show up. Can get help on the function when I enter the name "stockhistory", but when I search in help for a list of all functions, alphabetically, it is not part of the list.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-03-05T21:07:54+00:00

    This did not work on office 365 pro+ En running windows 10. Stockhistory is not showing up as an option when inserting a formula.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-02-03T00:46:25+00:00

    That's great to hear. Glad to know your problem has been resolved. Stay safe and healthy!

    Thank you and Best Regards!

    Jen :)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-02-02T19:31:42+00:00

    Jen,

    This works! Thank you so much for the help!

    Best,

    Xiaojun

    Hi XiaojunLiang!

    Try performing an Online Repair and see if it fixes the issue.

    Follow these steps: Right-click the Windows Start button.

    Select "Apps and Features" on the pop-up menu.

    Find and click your Microsoft Office 365 application in the list.

    Select Modify, then "Online Repair" and follow the onscreen instructions.

    Once the fix is applied, restart your computer and re-try opening excel to check if the function shows up.

    Let me know if this works. If you have any questions, please let me know and I'd be glad to assist you further.

    Thank you and Best Regards!

    Jen :)

    Was this answer helpful?

    0 comments