Last Trade Size

Returns the number of shares in the most recent trade.

Syntax

=LastTradeSize(Symbol)
Excel Desktop (Windows)

Returns

number

Size of the last trade

Examples

=LastTradeSize("AAPL")

When to Use

  • Trade analysis
  • Market depth understanding
  • Block trade detection

When NOT to Use

Scenario Use Instead
Daily volume Volume()

Common Issues & FAQ

What units?

Number of shares.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Last Trade Size and Other Financial Formulas
▶
How does MarketXLS work?