Real-time watchlists
Track prices, percent changes, bid/ask fields, and volume for the symbols you already follow in Excel.
MarketXLS for Excel
Stock Quotes in Excel
Get stock quotes in Excel with MarketXLS formulas like =Last("AAPL"). Standard quotes are 15-min delayed; Advanced and Business stream real-time.
- 15-minute delayed quotes on Standard, real-time streaming on Advanced and Business
- Quote formulas: =Last, =Bid, =Ask, =Volume, =ChangeinPercent
- Excel for Windows, Mac, and the web
The short version
How to get a stock quote in Excel
To get a stock quote in Excel, install the MarketXLS add-in and type a formula such as =Last("AAPL") in a cell. The cell returns the latest price for that ticker, and =Bid, =Ask, =Volume, and =ChangeinPercent return the rest of the quote. On the Standard plan, US stock quotes are 15-minute delayed. The Advanced and Business plans stream real-time quotes through QuoteMedia with =QM_Stream_Last("AAPL").
MarketXLS works in Excel for Windows (desktop add-in) and in Excel for Mac and Excel for the web (Microsoft 365 add-in, where formulas use the mxls. prefix, such as =mxls.Last("AAPL")). Excel built-in stock data types can be enough for a few delayed prices. MarketXLS fits when you need bid/ask, volume, real-time streaming, or a watchlist you can copy down hundreds of rows.
What you can build
Keep the data connected to the decision
MarketXLS is most useful when the market data is part of the workbook, not a separate export you have to clean up before every decision.
Portfolio dashboards
Keep position values, daily moves, and exposure calculations connected to live or refreshable price fields.
Trading sheets
Build quote-driven worksheets for entries, exits, stop levels, and daily review without copying data from a website.
How it works
From blank sheet to live model
Install MarketXLS
Install the Windows desktop add-in (license key) or the Microsoft 365 add-in from Microsoft AppSource (sign in with your MarketXLS account), then open your workbook.
Enter your tickers
Put symbols such as AAPL, MSFT, SPY, or TSLA in one column so the same formulas can be copied across the whole watchlist.
Add quote formulas
Type =Last(A2), =Bid(A2), =Ask(A2), and =Volume(A2) beside each ticker and copy them down the list.
Refresh the model
On-demand formulas update when you refresh or Excel recalculates. QM_Stream_ formulas update on their own while streaming is on. Build P&L, allocation, and alerts on top with normal Excel formulas.
Excel-native
Start with a formula, not another export
Put quotes, history, fundamentals, options, and screening fields directly where your model already lives.
=Last("AAPL")Returns the latest available last price for a ticker.
=Bid("MSFT")Pulls the current bid price when bid/ask data is available.
=Ask("SPY")Pulls the current ask price for a ticker or ETF.
=ChangeinPercent("TSLA")Returns the percent change from the previous close.
=QM_Last("AAPL")Returns an on-demand QuoteMedia quote snapshot that updates when Excel recalculates. Real-time on Advanced and Business.
MarketXLS Advanced=Volume("NVDA")Adds volume to quote tables, watchlists, and intraday monitoring sheets.
Which MarketXLS plan you need for stock quotes
Pick the plan by how fresh the quote must be. Standard ($70/month billed annually) gives 15-minute delayed US stock quotes. Advanced ($125/month billed annually) and Business ($200/month billed annually) stream real-time US stock and ETF quotes.
- Choose Standard for delayed quotes in everyday portfolio tracking.
- Choose Advanced when you need real-time streaming quotes and real-time options data.
- Choose Business for real-time forex and indices as well, or for broader professional workflows.
Before you choose
How MarketXLS compares to the usual workarounds
| Need | Excel stock data | Manual websites | MarketXLS |
|---|---|---|---|
| Real-time price workflow | Useful for simple lookups, but refresh and field depth are limited. | Slow and easy to break. | Formulas for last price, bid, ask, change, and volume; real-time streaming on Advanced and Business. |
| Large watchlists | Can become awkward when you need many fields across many symbols. | Requires copy and paste work. | Copy the same formulas down a column of tickers; streaming covers up to 300 symbols, on-demand refresh covers more. |
| Model building | Good for basic price fields. | Not a model-friendly workflow. | Quote formulas can sit beside portfolio, risk, and valuation logic. |
| Upgrade path | No options chain, scanner, or broad formula library. | No true upgrade path. | Move from quotes to history, fundamentals, options, and screeners in the same workbook. |
Common objections
When the built-in tools stop being enough
How do I get stock quotes in Excel?
Install the MarketXLS add-in and type =Last("AAPL") in a cell to get the latest price. Add =Bid("MSFT"), =Ask, =Volume, or =ChangeinPercent("TSLA") for the rest of the quote, then copy the formulas down your list of tickers.
Can Excel show real-time stock prices?
Yes, with an add-in. MarketXLS streams real-time US stock quotes into Excel on the Advanced and Business plans using =QM_Stream_Last("AAPL"). The Standard plan shows 15-minute delayed quotes.
Is Excel stock data real time or delayed?
Excel built-in stock data types are delayed. With MarketXLS, quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans.
Explore more
Related Excel market data pages
Useful guides
Go deeper on the workflow
Frequently asked questions
How do I get stock quotes in Excel?
Install the MarketXLS add-in and type =Last("AAPL") in a cell to get the latest price. Add =Bid("MSFT"), =Ask, =Volume, or =ChangeinPercent("TSLA") for the rest of the quote, then copy the formulas down your list of tickers.
Can Excel show real-time stock prices?
Yes, with an add-in. MarketXLS streams real-time US stock quotes into Excel on the Advanced and Business plans using =QM_Stream_Last("AAPL"). The Standard plan shows 15-minute delayed quotes.
Is Excel stock data real time or delayed?
Excel built-in stock data types are delayed. With MarketXLS, quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans.
What is the best formula for stock price in Excel?
=Last("AAPL") is the simplest MarketXLS formula for the latest stock price in Excel. For a real-time price that updates on its own, use =QM_Stream_Last("AAPL") on the Advanced or Business plan. In Excel for Mac or the web, write =mxls.Last("AAPL").
How do I automatically refresh stock prices in Excel?
Use streaming formulas such as =QM_Stream_Last, which update automatically while streaming is on (Advanced and Business plans). On-demand formulas such as =Last and =QM_Last update when you click refresh on the MarketXLS ribbon or Excel recalculates.
Can I track 100+ stocks in Excel?
Yes. Put tickers in one column and copy quote formulas across. Real-time streaming covers up to 300 symbols at once; on-demand formulas can refresh a longer list.
Which MarketXLS plan do I need for stock quotes in Excel?
Standard covers 15-minute delayed stock quotes. Advanced adds real-time streaming stock, ETF, and options data. Business adds real-time forex and indices. Professional users have different entitlements and exchange fees.
Can I use MarketXLS for bid and ask prices in Excel?
Yes. =Bid("AAPL") and =Ask("AAPL") return the bid and ask. =QM_Stream_Bid and =QM_Stream_Ask stream them in real time on the Advanced and Business plans.
Can I build a stock watchlist in Excel with MarketXLS?
Yes. A common workflow is to place tickers in rows and copy MarketXLS quote formulas across columns for price, change, bid, ask, volume, and other fields.
Can I combine stock quotes with my own Excel calculations?
Yes. MarketXLS formulas return values into cells, so you can use them with your own Excel formulas for returns, allocation, alerts, position sizing, and portfolio dashboards.