Feedback by UserVoice

Anonymous

My feedback

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

    We’ll send you updates on this idea

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

    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.

    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!

    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.

    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.

    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.

    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?

    Anonymous commented  · 

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

    Thanks.

    Anonymous supported this idea  · 
  2. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 

Feedback and Knowledge Base