Real Time Stock Quotes In Excel


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.

Real-time stock quotes in excel
Click image to enlarge

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.

real-time stock quotes in excel
Click image to enlarge

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.

live stock prices in excel
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 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.


Our Clients
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA
Associate Professor of Finance - Penn State University
I’m pretty happy with MarketXLS. I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying/pasting data from websites.

Samir Khan
InvestExcel.net
MarketXLS greatly expanded my ability to analyze investments. MSN Stock Quotes was limited in the number of stock quotes it would handle in one spreadsheet and in the number of variables available. Many of them were worthless.

Jim Grant
Uses MarketXLS for personal money management
1/2
Ready to get started with MarketXLS?
MarketXLS makes it easier for you to turn your Excel skills and market knowledge into profit

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!