Stream Last Trade Size

Streams the real-time number of shares involved in the most recent trade. This updates with each new trade.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Notes

  • Data streams automatically update in Excel
  • Updates with each new trade
  • Useful for monitoring block trades and institutional activity

Examples

=QM_Stream_LastTradeSize("AAPL")
Stream last trade size for Apple
=QM_Stream_LastTradeSize("MSFT")
Stream last trade size for Microsoft
=QM_Stream_LastTradeSize("SPY")
Stream last trade size for SPY ETF
=QM_Stream_LastTradeSize(A1)
Symbol from cell reference
=QM_Stream_LastTradeSize("AAPL")*QM_Stream_Last("AAPL")
Dollar value of last trade

When to Use

  • Monitoring block trades
  • Detecting large institutional activity
  • Trade-by-trade analysis
  • Volume profile analysis

When NOT to Use

Scenario Use Instead
Need total volume QM_Stream_Volume()
Need trade count QM_Stream_TradeCount()
Need accumulated volume QM_Stream_AccumulatedVolume()
Need average daily volume AverageDailyVolume()

Common Issues & FAQ

Q: What is a typical last trade size? A: Trade sizes vary widely - retail trades are often 100 shares, while block trades can be 10,000+ shares.

Q: How do I calculate average trade size? A: Use =QM_Stream_Volume("AAPL")/QM_Stream_TradeCount("AAPL").

Q: Why am I getting #N/A? A: Check that symbol format is correct.

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

Related Functions