MarketXLS

Stream Previous Close

Streams the previous trading day's closing price for stocks and ETFs. This is the reference price used to calculate daily change and percentage change.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX
Options OCC Symbol AAPL240315C00170000

Notes

  • Data streams automatically update in Excel
  • Used as baseline for calculating daily change
  • Important for gap analysis

Syntax

=QM_Stream_PreviousClose(Symbol)
Excel Desktop (Windows)

Returns

number

Previous trading day's closing price

Examples

=QM_Stream_PreviousClose("AAPL")
Previous close for Apple
=QM_Stream_PreviousClose("MSFT")
Previous close for Microsoft
=QM_Stream_PreviousClose("SPY")
Previous close for SPY ETF
=QM_Stream_PreviousClose(A1)
Symbol from cell reference
=QM_Stream_Last("AAPL")-QM_Stream_PreviousClose("AAPL")
Calculate change

When to Use

  • Calculating daily price change
  • Gap analysis (comparing open to previous close)
  • Percentage change calculations
  • Reference price for comparison

When NOT to Use

Scenario Use Instead
Need current/today's close QM_Stream_Close()
Need on-demand previous close QM_PreviousClose()
Need historical close on date Close_Historical()
Need current price QM_Stream_Last()

Common Issues & FAQ

What is "previous close"?

The official closing price from the most recent completed trading session (typically yesterday).

Why use previous close instead of close?

Previous close is the reference for calculating today's change; close is today's closing price.

Excel Templates Using Stream Previous Close

These ready-made MarketXLS templates call QM_Stream_PreviousClose() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:

See QM_Stream_PreviousClose used in a complete workbook: Real Time Futures Prices in Excel: Live Streaming Data with MarketXLS 2025

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Stream Previous Close and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions