Excel Now Lets You Get Real-Time Stock Data From Nasdaq

Microsoft is super-powering the Stocks data type in Excel with new partnerships. The company is teaming up with Nasdaq and Refinitiv to allow users to get access to an increased collection of financial information in real-time.

Microsoft says the partnerships will allow users to get access data of the full range of U.S. exchange-listed equities. With today’s partnership, the Stocks in Excel can now also provide you with more financial data, including bitcoin, bonds, international currencies, extended-hours pricing information and information about the company, like industry and company description.

Windows Intelligence In Your Inbox

Sign up for our new free newsletter to get three time-saving tips each Friday — and get free copies of Paul Thurrott's Windows 11 and Windows 10 Field Guides (normally $9.99) as a special welcome gift!

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

“Expanding the reach of real-time market data is essential to making markets more accessible,” said Oliver Albers, Senior Vice President and Head of Strategic Partnerships for Nasdaq’s Global Information Services. “Our collaboration with Microsoft is a significant step towards bringing important market information to individual investors. Microsoft’s focus on empowering individuals aligns perfectly with our mission to make financial markets more inclusive,” he added.

Microsoft first introduced the Stocks data type back in March 2018, and more than a year later, the feature is getting much more useful with today’s Nasdaq partnership. Microsoft says the company will continue to expand on today’s update and introduce things like the ability to automatically update stock prices every few minutes, as well as the ability to view historical data.

Tagged with

Share post

Please check our Community Guidelines before commenting

Conversation 8 comments

  • hrlngrv

    Premium Member
    05 June, 2019 - 2:27 pm

    <p>I could have sworn there was a DDE-based means for doing this decades ago.</p>

    • MikeGalos

      05 June, 2019 - 3:35 pm

      <blockquote><em><a href="#433471">In reply to hrlngrv:</a></em></blockquote><p>There was but it was a lot more fragile. In fact there were both DDE to a local app that got the data and NetDDE that did the comms as well. Then there were OLE methods. More recently there's been the Stocks data type in Excel mentioned in this article. This isn't a new capability but an improvement.</p>

      • hrlngrv

        Premium Member
        05 June, 2019 - 5:55 pm

        <p><a href="https://www.thurrott.com/cloud/office-365/208043/excel-now-lets-you-get-real-time-stock-data-from-nasdaq#433499&quot; target="_blank"><em>In reply to MikeGalos:</em></a></p><p>I'm familiar with the fragility of DDE, as well as the inflexibility of DDE calls in cell formulas.</p><p>I don't track stocks for a living, so I haven't kept track of this feature. However, general web queries have been around for quite a while. Excel 2003 IIRC, or Excel 2002, the one version I never used.</p>

        • MikeGalos

          06 June, 2019 - 4:25 am

          <blockquote><em><a href="#433521">In reply to hrlngrv:</a></em></blockquote><p>The DDE and NetDDE solutions I saw predated most use of the Internet and all of the Web and dialed in to proprietary online sources.</p>

      • locust infested orchard inc

        06 June, 2019 - 1:38 pm

        <blockquote><em><a href="#433499">In reply to MikeGalos:</a></em></blockquote><p><br></p><p>Both DDE and OLE almost never worked as intended (i.e., something was always 'lost in translation' during the DDE/OLE process, be it formatting, or horizontal separator lines, etc) but it was often the only way to have data, text, charts, images, synchronised on-the-fly, rather than importing the file in question.</p><p><br></p><p>Interoperability between Windows software in the 1990s and noughties was poor, but I guess that was due to the vast number of file formats, which mostly are considered as legacy.</p><p><br></p><p>I resented that most graphic files DDE linked/OLEed into Office insisted on transposing the file into either WMF or EMF, with the latter utterly betraying the full glory of the original graph/chart. And EMF was supposed to be an enhanced version of WMF – more like a disaster.</p><p><br></p>

  • misterstuart

    Premium Member
    05 June, 2019 - 3:15 pm

    <p>Does anyone know of a template that can be downloaded for this? I'd love to play around with some of my stock tickers. :-)</p>

    • fishnet37222

      Premium Member
      05 June, 2019 - 4:02 pm

      <blockquote><em><a href="#433491">In reply to misterstuart:</a></em></blockquote><p>Enter the stock ticker symbol into a cell, select the cell, then click "Stocks" in the Data tab on the ribbon. Excel also provides a tutorial for working with stocks.</p>

  • locust infested orchard inc

    06 June, 2019 - 1:23 pm

    <p>As queried by <em style="font-size: 0.875em;">misterstuart</em> in the premium comments, an investment tracker template can be downloaded from:</p><p><br></p><p><a href="https://templates.office.com/EN-US/investment-tracker-TM00414392&quot; target="_blank">https://templates.office.com/EN-US/investment-tracker-TM00414392</a></p&gt;

Windows Intelligence In Your Inbox

Sign up for our new free newsletter to get three time-saving tips each Friday

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Thurrott © 2024 Thurrott LLC