Stream Post Market Percent Change

Streams the real-time percentage change during post-market (after hours) trading. The change is calculated from the regular session closing price.

Supported Symbol Formats

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

Notes

  • Data streams automatically update in Excel
  • Post-market hours: 4:00 PM - 8:00 PM ET
  • Formula: (PostMarketLast - Close) / Close * 100

Examples

=QM_Stream_PostMarketPercentChange("AAPL")
Stream post-market % change for Apple
=QM_Stream_PostMarketPercentChange("MSFT")
Stream post-market % change for Microsoft
=QM_Stream_PostMarketPercentChange("TSLA")
Stream post-market % change for Tesla
=QM_Stream_PostMarketPercentChange(A1)
Symbol from cell reference

When to Use

  • After-hours performance monitoring
  • Earnings reaction analysis
  • Extended hours trading decisions
  • Pre-open market assessment

When NOT to Use

Scenario Use Instead
Need regular session percent change QM_Stream_PercentageChange()
Need post-market dollar change QM_Stream_PostMarketChange()
Need pre-market percent change QM_Stream_PreMarketPercentChange()
Need post-market price QM_Stream_PostMarketLast()

Common Issues & FAQ

Q: Why is the percentage showing 0? A: Post-market data is only available during extended hours (4:00 PM - 8:00 PM ET).

Q: What is the change calculated from? A: Post-market percent change is calculated from the regular session closing price.

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 Post Market Percent Change and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions