Real Time Stock Quotes In Excel

Once you install MarketXLS, a new menu will show up in Your Excel with many new functions that are added to Excel. You can use the function like =qm_stream_last (“MSFT“) or =qm-stream_last(B2) where cell B2 is the one that contains the stock symbol. As soon as you do that, the stock prices will start showing in your Excel cell. Not only the last price, but you can also get the full quote of the stock using the functions like =qm_stream_ask, =qm_stream_bid, and so on.

These functions not only work with stocks but also can work with stock options, currencies, and any other ticker symbol you have access to.

Click image to enlarge

The streaming data support up to 300 ticker symbols for simultaneous streaming. MarketXLS has other functions, which are the “refresh on-demand” functions. Refresh on-demand functions call the real-time stock prices in your Excel and require a click on the refresh button on the MarketXLS menu.

Unlike the streaming function, you can refresh more than 300 stocks or options at one time. If, for some reason, you would like to stop streaming and see a snapshot of quotes at a point in time, simply uncheck the streaming checkbox, as shown below.

Click image to enlarge

The data will still be a live snapshot of the prices from the market. If you are looking for a way to quickly get the live stock quotes in Excel with a very reliable source, then look no further.

We have performed many optimizations to make sure that the flow of the stock quotes is seamless. And also that the plugin does not hinder your ability to perform other tasks Excel.

Check out MarketXLS today The #1 Excel-based Investment Research Solution for Serious Investors

MarketXLS works with any version of Excel like Excel 2007, 2010, 2013, 2016, 2019, and Office 365. MarketXLS, at this time, only works with Windows-based machines.