QM_Stream_PostMarketPercentChange for Real-Time Post-Market Tracking

The QM_Stream_PostMarketPercentChange function lets you view the real-time after-hours percentage change for a given symbol directly in Excel. This function leverages MarketXLS’s RTD (Real-Time Data) service to provide live updates of post-market performance, empowering you to react quickly to after-hours developments.

Why Use This Function?

• Gain immediate insight into a stock’s post-market movement.
• Quickly compare various symbols after the regular market close.
• Enhance after-hours trading strategies with up-to-date price changes.
• Seamlessly integrate with MarketXLS’s other real-time analytics for a comprehensive view.
• Ideal for tracking extended hours volatility and making timely, data-driven decisions.

How to Use in Excel

=QM_Stream_PostMarketPercentChange("AAPL")

1. Select any cell in your Excel worksheet.
2. Enter the function name followed by a valid ticker symbol in quotes.
3. Press Enter, and the cell will display the real-time post-market percentage change for that symbol.

Note: Ensure you have a valid MarketXLS license and that your Data Subscription is configured correctly. If either is not set up, the function may return configuration or license error messages.

Parameters Explained

Example Usage

Basic Examples

1. Single Symbol:
   • In cell A1:
   =QM_Stream_PostMarketPercentChange("AAPL")
   • This instantly streams Apple’s post-market percent change.

2. Multiple Symbols:
   • In cell A2: =QM_Stream_PostMarketPercentChange("MSFT")
   • In cell A3: =QM_Stream_PostMarketPercentChange("TSLA")
   • Compare real-time after-hours changes for multiple companies side by side.

Advanced Scenarios

1. Post-Market Watchlist:

   • List various symbols in a column and apply QM_Stream_PostMarketPercentChange across each row to maintain a live watchlist.
   • Combine with Excel’s conditional formatting to highlight significant after-hours movers.

2. Strategy Integration:

   • Use the function’s output alongside other MarketXLS functions (e.g., daily change or volume) to make informed decisions about whether to enter or exit positions based on after-hours price swings.

3. Tracking Volatility:

   • Set up a spreadsheet that compares the post-market percent change with the previous close price. This can help identify highly volatile stocks reacting to late-breaking news.

Common Questions and Troubleshooting

• Why am I getting "NA"?

• The symbol might be invalid, or the cell contains a blank symbol. Double-check the ticker and ensure it’s recognized by your data provider.

• What if I see a licensing or configuration error?

• Your MarketXLS license may be expired or not properly activated. Make sure your Data Subscriptions are properly configured in the Settings menu.

• How often does the data update?

• Real-time streaming data is continuously updated as market information becomes available. Expect frequent refreshes, especially during active after-hours sessions.

• Does this function work for all stock exchanges?

• Generally, it supports major US exchanges for after-hours data, but availability may vary by your MarketXLS subscription.

By using QM_Stream_PostMarketPercentChange, you can stay on top of every market-moving development after the closing bell. Save time, reduce uncertainty, and empower your trading or investment processes with real-time post-market insights—right inside Excel!