Live Market Data in Excel • US & Canadian Markets • Stocks, ETFs, Options, Indices & Crypto

Get Live
Stock Prices in Excel
with Simple Formulas

Learn how to get stock data in Excel using MarketXLS. Our powerful Excel add-in brings live market data directly into your spreadsheets with easy-to-use functions. Access US and Canadian stocks, ETFs, options, indices, and cryptocurrencies - all with no complex APIs or programming required - just simple Excel formulas for real-time financial data.

1000+
Excel Functions
1500+
Stock Symbols
<1s
Refresh Speed
Microsoft Excel - Stock Analysis.xlsx
Symbol
Formula
Price
Change
AAPL
=Last("AAPL")
150.00
+1.50
^GSPC
=Last("^GSPC")
4,500.00
-10.00
SPY
=Last("SPY")
450.00
+2.00
BTC-USD
=Last("BTC-USD")
30,000.00
-500.00
AAPL 150 Call
=Last("AAPL 150 Call")
5.00
+0.25
Live updates every second

How to Get Stock Data in Excel: Simple Formulas, Powerful Results

Getting live stock prices in Excel has never been easier. With MarketXLS, you can access real-time stock data in Excel using simple formulas like =Last("AAPL") to get Apple's current stock price. Our Excel stock functions work seamlessly, making stock data in Excel accessible to everyone.

Live stock prices in Excel with real-time updates
1000+ Excel stock functions for comprehensive analysis
Complete coverage: US & Canadian stocks, ETFs, options, indices & crypto
Better alternative to complex VBA formulas - no programming required
Works on Excel for Windows, Mac, and Excel Online (Office 365)
Book a demo today
=Last("AAPL")
$175.84
=Ask("MSFT")
$378.92
=Bid("GOOGL")
$142.56
Live Excel formulas for stock data updating in real-time

Complete Stock Data in Excel Solution

Everything you need to analyze stock prices in Excel. From real-time data feeds to historical analysis, MarketXLS provides comprehensive stock market data directly in your spreadsheets.

Real-time Stock Data in Excel

Stream live stock prices directly into Excel with automatic updates. Get real-time market data for over 1500 US stocks with sub-second refresh rates.

Easy Excel Stock Functions

Simple formulas like =Last("AAPL") make getting stock data in Excel effortless. No programming knowledge required - just type and get instant results.

Reliable Data Source

99.9% uptime ensures your Excel stock data is always available. Multiple data sources and failover protection for mission-critical financial analysis.

Works Seamlessly Across Your Devices

Access comprehensive market data in Excel whether you're on a PC, Mac, or using Excel Online.

Excel for Windows

Full-featured access to all MarketXLS functions and real-time stock data on your Windows PC.

Excel for Mac

Enjoy the power of MarketXLS with seamless integration for Excel on your macOS device.

Excel Online (Office 365)

Access your live stock prices in Excel from anywhere with our support for Excel Online.

AAPL$175.84 ↗ +2.1%
MSFT$378.92 ↗ +1.8%
GOOGL$142.56 ↘ -0.9%
Live stock prices in Excel with automatic color-coded changes

Live Stock Prices in Excel Made Simple

Transform how you work with stock data in Excel. Our add-in automatically streams live prices for US and Canadian stocks, ETFs, options, indices, and cryptocurrencies into your spreadsheets with color-coded price changes, making it easy to track market movements in real-time. Whether you're managing a portfolio or conducting financial analysis, getting comprehensive market data in Excel has never been more straightforward.

  • Real-time data streaming for 1500+ US and Canadian securities
  • Automatic color coding for price movements in Excel
  • Customizable refresh intervals (1-5 minutes)

Beyond Basic Stock Data in Excel

While many solutions only provide basic stock prices in Excel, MarketXLS offers comprehensive financial data including fundamental analysis, technical indicators, earnings estimates, and key financial ratios for stocks, ETFs, indices, options, and cryptocurrencies across US and Canadian markets. Our Excel stock functions give you access to the same data used by professional analysts, all within your familiar Excel environment. For specialized options trading features, check out our dedicated options trading tool at OptionsXLS. Learn more about our complete solution at marketxls.com.

  • Fundamental analysis with P/E ratios, EPS, and financial metrics
  • Technical indicators like RSI, MACD, moving averages in Excel
  • Historical stock data and earnings estimates
P/E Ratio
24.5
EPS
$6.15
Market Cap
$2.8T
Dividend
$0.94
Comprehensive fundamental data

Trusted by thousands of financial professionals

See what our customers say about MarketXLS's comprehensive market data coverage

Best Stock Analysing Tool

"I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI..."

Kirubakaran K., Small Business Owner
Perfect Real-time Quotes

"The Real-time quotes were perfect for my strategy. Simple to start and stop and easy to use. Quote Media has been a great addition to MarketXLS."

Verified User, Small Business
Game-Changer for Excel Users

"I've been using MarketXLS for a while now, and I must say it's been a game-changer for my financial analysis and investment research..."

Anonymous User
Above and Beyond Excel Stock Data

"The MarketXLS Add-In gives so much more to help me see dividend data, indicators, historical data and more! This is what I've been hoping for in Excel."

Anonymous User
Amazing -- High Speed and Real-time Data

"I got this to update my portfolio and analyze a company or two. The free version was good for that. I upgraded, just love the streaming functions."

Robin Bisarya
Excellent for Stock Analysis

"MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors."

John D., Financial Analyst
Perfect for Portfolio Tracking

"I use MarketXLS daily to track my investments across stocks, ETFs, and even crypto. The real-time data and custom formulas are invaluable. It's become an essential part of my routine."

Sarah M., Individual Investor
Time-saving Excel Add-in

"MarketXLS saves me hours of manual data entry. The Excel integration is seamless and incredibly efficient. It's a huge productivity booster."

Michael T., Business Owner
Very Powerful Especially with Streaming

"I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel."

Anonymous User

Ready to supercharge your Excel analysis?

Join thousands of financial professionals who trust MarketXLS for comprehensive US and Canadian market data in Excel