Last Price

Returns the most recent traded price for stocks, ETFs, indices, options, mutual funds, crypto, and forex.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX
Crypto SYMBOL-USD BTC-USD, ETH-USD
Forex SYMBOL=X EURUSD=X
Canadian SYMBOL:CA SHOP:CA
Options OCC Symbol AAPL240315C00170000

Notes

  • Prices are typically delayed 15 minutes
  • For real-time streaming prices, use QM_Stream_Last()
  • Returns "NA" if the symbol is invalid or data is unavailable

Examples

=Last("AAPL")
Apple stock price
=Last("^SPX")
S&P 500 index
=Last("BTC-USD")
Bitcoin price
=Last("EURUSD=X")
Euro/USD exchange rate
=Last(A1)
Symbol from cell reference

When to Use

  • Quick price lookup for any symbol
  • Portfolio valuation spreadsheets
  • Building watchlists and dashboards
  • Price input for calculations

When NOT to Use

Scenario Use Instead
Real-time streaming QM_Stream_Last()
Historical price on date Close_Historical()
Previous day's close PreviousClose()
Pre-market price QM_Stream_PreMarketLast()

Common Issues & FAQ

Q: Why am I getting "NA"? A: Check symbol format:

  • Canadian stocks need :CA suffix
  • Crypto needs -USD suffix
  • Indices need ^ prefix
  • Forex needs =X suffix

Q: How do I get real-time prices? A: Use QM_Stream_Last() for streaming updates.

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 Last Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions