Excel Stock Price: Real-Time Quotes, the Price Function and Prices on Any Date

Excel stock price formulas, step by step: insert a live quote, learn the stock functions, pull a price for today or any past date, and stream real-time quotes into your workbook with MarketXLS.

Start here: stock price in Excel.

1. 1
   Stock Price in Excel: How to Insert Live, Auto-Updating Quotes with One Formula

   Learn how to insert real-time stock prices in Excel using built-in features, external data sources, and MarketXLS. Complete guide with step-by-step instructions for tracking multiple stocks, setting alerts, and automatin

2. 2
   Real Time Stock Prices in Excel: Live Streaming Data for Financial Professionals

   How to get real-time stock prices in Excel: the Stocks data type, Power Query, broker RTD links, and MarketXLS =QM_Stream_Last streaming formulas compared.

3. 3
   Stay Up to Date with Live Stock Quotes

   Live stock quotes in Excel: use =QM_Last for on-demand quotes or =QM_Stream_Last for streaming. Real-time needs the Advanced or Business plan; Standard is 15-min delayed.

4. 4
   Excel Stock Functions: How to Get Real-Time Quotes, Historical Data, and Fundamentals in Excel (2026)

   Excel stock functions - learn every method to get real-time stock quotes, historical prices, and fundamental data in Excel in 2026. Covers built-in STOCK data type, STOCKHISTORY, Power Query, and MarketXLS add-in formula

5. 5
   Excel Stock Price Formula: Today or Any Specific Date

   Get a stock price on a specific date in Excel with STOCKHISTORY or MarketXLS Close_Historical, including weekend and holiday dates.

6. 6
   Stock Quotes in Excel: How to Get Real-Time and Historical Data with Formulas

   Five ways to get stock quotes in Excel in 2026, from STOCKHISTORY and the Stocks data type to MarketXLS formulas like =Last("AAPL") and streaming =QM_Stream_Last.

7. 7
   Stock Market Data in Excel: Live Quotes, Screener, and Watchlist for May 2026

   Get stock market data in Excel with MarketXLS formulas for price, daily change, moving averages, 52-week range, P/E, beta, and yield, plus a 30-ticker watchlist template.