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
Pull stock quotes into Excel with MarketXLS formulas for prices, bid/ask, change percent, watchlists, and refreshable portfolio dashboards.
- Real-time and delayed quote functions
- Excel formulas for repeatable models
- Works for watchlists, dashboards, and portfolio sheets
The short version
Stock quotes belong inside the workbook
MarketXLS is an Excel add-in for stock market data. It lets investors pull stock quotes, historical prices, fundamentals, options chains, Greeks, and screening results directly into Excel using formulas.
If you only need delayed basic prices, Excel built-in stock data can work. If you need reliable refresh, real-time quotes, larger watchlists, or formulas you can build models around, MarketXLS is the better fit.
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
Add MarketXLS to Excel, sign in, and open the workbook where you want quotes, watchlists, or portfolio values to update.
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
Use formulas for last price, bid, ask, change percent, volume, and other quote fields beside each ticker.
Refresh the model
Keep the sheet connected as prices move, then use normal Excel formulas for allocation, P&L, alerts, and dashboards.
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.
=ChangePercent("TSLA")Returns the percentage move so dashboards can update without manual math.
=QM_Last("AAPL")QuoteMedia-powered real-time quote function for users who need live market data.
MarketXLS Advanced=Volume("NVDA")Adds volume to quote tables, watchlists, and intraday monitoring sheets.
Choose the plan by how fresh the quote needs to be
If you just need basic delayed quotes, start with MarketXLS Standard. If your worksheet depends on real-time quotes, bid/ask fields, or active trading workflows, choose MarketXLS Advanced.
- Choose MarketXLS Standard for basic stock quote formulas and everyday portfolio tracking.
- Choose MarketXLS Advanced when real-time market data changes the decision you are making.
- Choose MarketXLS Business if the data is for professional, commercial, or client-facing use.
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. | Use formulas for last price, bid, ask, change, volume, and refreshable dashboards. |
| Large watchlists | Can become awkward when you need many fields across many symbols. | Requires copy and paste work. | Designed for watchlists, tables, and repeatable Excel models. |
| 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 MarketXLS, sign in, and use quote formulas such as =Last("AAPL"), =Bid("MSFT"), or =ChangePercent("TSLA") in your workbook. You can then copy formulas across a watchlist and refresh the sheet.
Can Excel show real-time stock prices?
Excel can show market data through add-ins. MarketXLS supports real-time quote workflows on eligible plans and data feeds, while Excel built-in stock data is better suited for basic delayed lookups.
Is Excel stock data real time or delayed?
Excel built-in stock data is generally not a professional real-time market data feed. If refresh speed and quote reliability matter, use a dedicated market data add-in such as MarketXLS.
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 MarketXLS, sign in, and use quote formulas such as =Last("AAPL"), =Bid("MSFT"), or =ChangePercent("TSLA") in your workbook. You can then copy formulas across a watchlist and refresh the sheet.
Can Excel show real-time stock prices?
Excel can show market data through add-ins. MarketXLS supports real-time quote workflows on eligible plans and data feeds, while Excel built-in stock data is better suited for basic delayed lookups.
Is Excel stock data real time or delayed?
Excel built-in stock data is generally not a professional real-time market data feed. If refresh speed and quote reliability matter, use a dedicated market data add-in such as MarketXLS.
What is the best formula for stock price in Excel?
=Last("AAPL") is the simplest MarketXLS formula for pulling a latest stock price into Excel. Active traders can use additional quote functions for bid, ask, change, volume, and real-time fields.
How do I automatically refresh stock prices in Excel?
MarketXLS lets you build formulas into a workbook and refresh the data from the add-in. This is more repeatable than copying stock prices from websites into Excel.
Can I track 100+ stocks in Excel?
Yes. MarketXLS is designed for quote tables and watchlists where you need many symbols and many fields in the same worksheet.
Which MarketXLS plan do I need for stock quotes in Excel?
MarketXLS Standard is the starting point for basic stock quotes. MarketXLS Advanced is the better choice when you need real-time market data, active trading fields, or options data. Professional users should choose MarketXLS Business.
Can I use MarketXLS for bid and ask prices in Excel?
Yes. MarketXLS includes quote functions for fields such as bid and ask when those fields are available through the selected data feed and plan.
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.