MarketXLS is the best way to stream reliable real-time stock quotes in excel. In this article, I will show you how you can use hundreds of MarketXLS formulas and custom functions to stream real-time live prices of stocks in your Excel sheets.
How does it work?
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.
How many ticker symbols can you stream in real-time?
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.
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 are so confident about the streaming real-time stock quotes in excel functions that we provide a 30-day money-back guarantee with MarketXLS. The stock price quotes will always match the price that you see in your brokerage accounts, and you can rely on the numbers.
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.