Feedback by UserVoice

Anonymous

My feedback

  1. 44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    If lack of the Stock Data feature is sand in your shoes, there IS another way around the problem.

    You can jump onto eBay and get yourself a permanent license for OFF365. It should cost in the neighborhood of $5.00 one-time. Select your purchase carefully. You never want to pick anything that requires you to make make more than one payment. These are user licenses that have been released by the original owner. The seller will provide you with a portal and a userid and password that will give you access to the install code. For ongoing access you set yourself up for automatic connection as if it were a work or school account. When you get this set up you won't need OFF2019 any more.
    I am told that this usage was found to be legal in an international court. eBay must believe that too or they wouldn't allow these licenses to be sold.

    I set myself up like this a couple of years ago and have been using OFF365 on a Win10 laptop with no problems. The license provides for updates a couple of times a year, but I've seen others come down as well.

    If you decide to try this make sure you back up your system first. You always want to be sure you are able to get back out of any situation you might get into.

    Anonymous shared this idea  · 
  2. 1,112 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

    An error occurred while saving the comment
    Anonymous commented  · 

    @nyc-hdl Sorry, it's just something I wrote for personal use. I used Excel's Power Query feature to pull a few stock prices from www.nasdaq.com. I then used Excel's VBA to add bells and whistles.. Power Query ("Data/Get Data") is where the beef is.You can get your data into a spreadsheet without using VBA.. I was able to get current price, last price and % change for 5 stocks. It wasn't hard at all. If you have questions about how to do anything the Internet has all kinds of sites with the answers.

    An error occurred while saving the comment
    Anonymous commented  · 

    @Ed Hansberry It will be interesting to see how the large corporate customers customers feel about this strategy. Microsoft has been known to change its policies when enough big customers complain.

    I'm willing to bet that a lot of individual OFF2019 customers with a need for the Stock feature rightly or wrongly feel snakebit. They bought OFF2019 just like they bought the versions before it. They won't want to hear is that they have to buy Office again or buy some third party solution. That's the bad customer experience I was referring to.

    Personally, I developed my own solution so I'm OK for now. But not every Office customer has the skills or time to do that.

    Have a Happy Fourth!

    An error occurred while saving the comment
    Anonymous commented  · 

    @Ed Hansberry I hear you, but IMO when a product is not consistent across platforms it can lead to confusion at the user level, difficulties in deploying applications and bad customer experiences. This is especially true for such an important feature as stock price retrieval. Plus, in the absence of a supported feature there will be a lot of time and effort spent on home grown solutions of varying quality. I'd rather see a feature update,such as is done with Windows and other products all the time.

    An error occurred while saving the comment
    Anonymous commented  · 

    I'm guessing that this feature isn't in OFF2019 Desktop because Microsoft would prefer that you buy OFF365 so that they can get that revenue stream. I hope I'm wrong - that's not a nice way to treat a loyal customer base.

    An error occurred while saving the comment
    Anonymous commented  · 

    I got tired of waiting for something to be done for desktop Office users, so I glued together something that at least gets me the results for the 5 stocks I own. I used the Power Query feature of Excel 2019 from a little VBA program I wrote. My Query pulls the results (Latest Price, Last Close, Change) from the Nasdaq.com web site. Other sites might work as well, but this is the first one I found that had what I wanted.

    An error occurred while saving the comment
    Anonymous commented  · 

    It seems like Excel 2019 not having the stock price feature is a marketing decision, not a technical one. Many of us have spent our money for Office 2019 for the desktop as we did for earlier versions. Is it right that Microsoft marginalize Office 2019 for the desktop and it's users this way? Is the perpetual Off365 revenue stream the only thing that matters now to Microsoft?

    An error occurred while saving the comment
    Anonymous commented  · 

    Please add the Stock data feature to Excel 2019 for Windows as soon as possible!

    Thanks.

    Anonymous supported this idea  · 

Feedback and Knowledge Base