Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Pull Current Stock Prices and Historical Data Into Excel

Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

833 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Chris Newman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    Progress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*

    We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs

    Again, we genuinely appreciate your involvement as we take our first steps in a much greater journey to make Excel better understand your data, and can’t wait to hear about your experiences and suggestions for the future!

    James Spotanski (Microsoft Excel)

    More reading…
    Excel’s new Data Types: https://aka.ms/Pgyscw
    Become an Office Insider: http://aka.ms/officeinsider

    *Unfortunately there is no way to override the controls to give yourself access – your patience is appreciated :)

    289 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        We can now pull stock data into Excel Docs. Long awaited and it is great! Most of the data is accurate and it updates beautifully. However, after spending hours re doing the old Excel sheets and updating them with this enhancement, I was told by a microsoft windows tech that my profile was corrupt because I could not save my excel documents. So we created a new profile. And he moved all my beautiful new Excel sheets to the new user profile. The stock data link is not there. My data is dead. After 3 chats with an Office tech and 3 chats with a Microsoft Windows tech and even a reinstall of Windows 10, my docs in the new user profile do not have the stock data option. No one can resolve. All that work to get my spreadsheets in Excel (after converting them from Google Sheets) was for naught - wasted time. Very very frustrating. If someone has a resolution it would be wonderful. Otherwise - back to Google Sheets.

      • Roy commented  ·   ·  Flag as inappropriate

        "First iteration" is hopefully right. One cannot specify the data source, according to insider accounts, but must rely upon whatever good ol' Bing wants to present.

        Clearly unacceptable for even average stock needs.

        (But gosh, Bing will sure look like humans now want to use it for searches, won't it?)

        Second iteration? Let US decide the data source the Data Type functionality looks to.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Don't care anymore. Just one more reason Microsoft is giving me to leave it's products behind. Linux (Ubuntu and CentOS) and Google's Office products are becoming more reliable, stable and easier to use!

        Google FInance has an entire section of stock info to import, for free! Just google "=GoogleFinance()". Good luck.

        Thanks but No Thanks Microsoft!

      • Anonymous commented  ·   ·  Flag as inappropriate

        I am an office insider with a 365 subscription. I finally got the stock data type and am looking forward to using it. I am having difficulty ith a couple of symbols. First is the NASDAQ index, symbol "COMP" in morningstar. The symbol returns some other stock. Also, the Gabelli Equity Trust Preferred H "GABPH" in morningstar. It returns no data. There seems to be no way to find a stock symbol that Excel likes. Neither Morningstar not MSN Money works.

      • Anonymous commented  ·   ·  Flag as inappropriate

        What happens if you are not an Office 365 user, I had purchased the software bundle MS Office 2016. Will there be an update for MS Office 2016 home pc edition?

      • Ronaldo Smith Jr commented  ·   ·  Flag as inappropriate

        I am using STOCK data type in Excel 365 and it's working fine for me. I get the properties from this data type like Industry, Price, etc... directly from my Excel spreadsheet for financial management.

      • Anonymous commented  ·   ·  Flag as inappropriate

        please arrange to give me access. I have been waiting for this a long time.
        thank you for your help.

      • Evan Olsen commented  ·   ·  Flag as inappropriate

        Please add me to your list of Excel users requesting access to live stock quote data. Thanks!

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is excellent news! Please keep us informed when your upgrade(s) have been completed. We will need clearly written instructions as to how to use the new functions.

      • Anonymous commented  ·   ·  Flag as inappropriate

        That's great news, Thank you. Now I need a simple way to import the data to Excel. Could you do that next please?

      • Anonymous commented  ·   ·  Flag as inappropriate

        This works for pulling current prices into Excel (in this case referencing a Col "D"). You can swap out the other name tags to pull EPS, etc., etc. The prices are updated frequently but have not attempted to look how fast, but enough for me (and you can force new data Cntl-Alt-f9)

        =VALUE(WEBSERVICE("https://api.iextrading.com/1.0/stock/" & D4 & "/quote/delayedPrice"))

      • Barbara Ann Hill commented  ·   ·  Flag as inappropriate

        How could I become an "insider" to try using the "Pull Current Stock Prices and Historical Data Into Excel"? I have been using Google sheets and am beginning to like them. So, please hurry to add this functionality to Excel! You might lose users if you take too long.!!

      • Elliot Amiel commented  ·   ·  Flag as inappropriate

        What's the status on this? 5 months have elapsed since Eric Patterson, Program Manager at MSFT, announced this but we have nothing yet. WTF?

      • Rosilyn Overton commented  ·   ·  Flag as inappropriate

        This is functionality that I sorely need and I guess I am not an Office insider. How do you become one of these? I am happy to give feedback on Office products.

      • Dave commented  ·   ·  Flag as inappropriate

        please add Moving Averages. Simple Moving Averages for 5, 10, 25, 50, 200 days......

      ← Previous 1 3 4 5 14 15

      Feedback and Knowledge Base