Share via

Excel 2019 - Stocks Feature

Anonymous
2020-02-19T05:06:36+00:00

I've just downloaded Excel 2019 so that I can track my stock portfolio, but seem to be missing features available in Office 365 online.

I can add companies and excel seems to recognize them as stocks (as shown below), but the stocks icon is missing and the 'Insert Data' function is not available.

In contrast, when I am using Office 365 in my OneDrive, all the features are enabled, as seen below:

Is there some feature missing in my Excel 2019 or do I need to enable something? The entire reason that I upgraded from Office 2016 to 2019 was for the live stock data feature, so it would be incredibly unfortunate if this wasn't fully available.

Thanks for your time.

Dan

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-19T06:29:05+00:00

    Sorry to tell you this, but "Stock" data type is one of the features limited to Office 365. It is NOT part of Office 2019.

    When MS created the Office 365 "subscription" type of license, MS decided to "encourage" people to switch to this new cash cow by limiting "new features" to the 365 offering and not adding them to the one-time payment licenses like Office 2019.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-04-10T18:47:37+00:00

    Go to this website and try to upvote this complaint and maybe they might add it to the desktop version.  It was previously states though they are tryknf to encourage their 365 program. 

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/37198375-implement-the-stock-data-feature-from-excel-365-in

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  3. Anonymous
    2020-02-20T03:43:38+00:00

    Wow - ok. That is really unfortunate. Had I known I would have not paid for 2019 and just installed Office 365. Thanks for the info.

    Cheers

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2020-02-20T03:40:57+00:00

    Hi V. Arya

    The version I have is Excel 2019 (Microsoft Office Home and Student 2019.

    Thanks

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2020-02-19T06:13:52+00:00

    Hello Daniel

    I am V. Arya, Independent Advisor, to work with you on this issue. Can you open Excel - File - Account and let me know whether this is Excel 2019 or Excel 365?

    Was this answer helpful?

    0 comments