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

Syntax

=Last(Symbol)

Excel Desktop (Windows)

Returns

number

Last traded price

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

Why am I getting "NA"?

Check symbol format:

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

How do I get real-time prices?

Use QM_Stream_Last() for streaming updates.

Excel Templates Using Last Price

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

Related Formulas

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

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?