Previous Close
Returns the closing price from the previous trading day. This is the reference point for calculating daily changes.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
| Forex | SYMBOL=X | EURUSD=X |
Notes
- The previous close is typically the adjusted closing price
- Used as the basis for calculating daily change and percent change
- Returns "NA" if data is unavailable
Syntax
=PreviousClose(Symbol)Examples
=PreviousClose("AAPL")=PreviousClose("SPY")=PreviousClose("^SPX")=PreviousClose(A1)=Last("AAPL")-PreviousClose("AAPL")When to Use
- Reference point for daily calculations
- Calculating custom change metrics
- Building OHLC displays
- Comparing opening price to prior close
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current price | Last() |
| Historical close on specific date | Close_Historical() |
| Real-time streaming | QM_Stream_PreviousClose() |
| Pre-calculated change | Change() |
Common Issues & FAQ
How do I calculate the daily change?
Use =Last("AAPL")-PreviousClose("AAPL") for dollar change.
How do I calculate percent change?
Use =(Last("AAPL")-PreviousClose("AAPL"))/PreviousClose("AAPL") or simply Change_PercentChange().
Is this adjusted for splits and dividends?
Yes, the previous close typically reflects adjusted prices.
Excel Templates Using Previous Close
These ready-made MarketXLS templates call PreviousClose() in their worksheet formulas. Open one to see the function working inside a complete model.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?