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

Posted on June 5, 2019 by Mehedi Hassan in Office 365 with 8 Comments

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.

“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 , ,

Join the discussion!

BECOME A THURROTT MEMBER:

Don't have a login but want to join the conversation? Become a Thurrott Premium or Basic User to participate

Register
Comments (8)

8 responses to “Excel Now Lets You Get Real-Time Stock Data From Nasdaq”

  1. hrlngrv

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

    • MikeGalos

      In reply to hrlngrv:

      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.

      • hrlngrv

        In reply to MikeGalos:

        I'm familiar with the fragility of DDE, as well as the inflexibility of DDE calls in cell formulas.

        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.

      • locust infested orchard inc

        In reply to MikeGalos:


        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.


        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.


        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.


  2. misterstuart

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

  3. locust infested orchard inc

    As queried by misterstuart in the premium comments, an investment tracker template can be downloaded from:


    https://templates.office.com/EN-US/investment-tracker-TM00414392

Leave a Reply