Real-Time Post-Market Price Changes for Stocks

The QM_Stream_PostMarketChange function helps you stay on top of valuable after-hours stock movements right within Excel. By leveraging MarketXLS RTD/streaming capabilities, this function updates automatically with the latest post-market change data for your chosen symbol. With this information at your fingertips, you can make informed trading and analysis decisions outside of regular market hours.

Why Use This Function?

• Stay Updated After Hours: Get immediate insight into how a stock is moving once the closing bell has rung.
• Real-Time Streaming: Automatically updates as new post-market data rolls in.
• Integrated with Excel: Seamlessly incorporate after-hours data into your Excel worksheets, calculations, and dashboards.
• Enhanced Decision-Making: Use real-time updates to adjust trading strategies or assess the impact of late-breaking news.
• Simple Formula Usage: Works just like any other Excel formula, making it easy to integrate into your existing workflow.

How to Use in Excel

=QM_Stream_PostMarketChange("AAPL")

1. Enter the formula in a cell, referencing the ticker symbol as a text string.
2. Once entered, MarketXLS automatically streams post-market change data.
3. The returned value updates in real time through MarketXLS’s RTD engine.

Parameters Explained

• If you provide an invalid or empty symbol, the function will return "NA".
• You need an active and valid MarketXLS license, as an invalid license will display an error.

Example Usage

Basic Examples

1. Single Symbol Lookup
   » In cell A1: =QM_Stream_PostMarketChange("AAPL")
   Explanation: This cell will dynamically reflect Apple’s post-market price change.

2. Using Cell References
   » Suppose cell B1 contains the symbol TSLA.
   » In cell A2: =QM_Stream_PostMarketChange(B1)
   Explanation: This setup allows you to quickly change the symbol in B1 without editing the formula.

Advanced Scenarios

1. Watchlist Integration

   • Build an Excel table of multiple symbols (e.g., in column A).
   • In adjacent columns, use QM_Stream_PostMarketChange for each symbol.
   • Your watchlist updates automatically, showing each stock’s post-market change.

2. Combining with Other Excel Functions

   • Create alerts by comparing after-hours changes to thresholds. For instance:
     =IF(QM_Stream_PostMarketChange("GOOG")>5,"Significant Move","Normal Fluctuation")
   • This helps highlight substantial after-hours movements in your spreadsheet.

3. Extended Analysis

   • Pair post-market data with additional MarketXLS functions (e.g., post-market volume) to get a comprehensive after-hours perspective.
   • Incorporate these insights into your broader trading strategy or research.

Common Questions and Troubleshooting

• "Why am I getting 'NA' in my cell?"
  » Ensure the symbol is valid and spelled correctly. Empty strings will also return "NA".

• "I see an error related to license or configuration."
  » Confirm that your MarketXLS license is active and that you have properly configured your data subscription settings.

• "Does this work with ETFs or non-US symbols?"
  » Post-market trading is most common in US markets for actively traded stocks. Ensure your data subscription supports those symbols.

• "My data doesn’t update in real time."
  » Check your RTD settings in Excel. Confirm you have a stable internet connection and that Excel is set to automatic update, not manual.

By using QM_Stream_PostMarketChange, you harness real-time after-hours changes, giving you a competitive edge when news breaks after the closing bell. Whether building watchlists or integrating advanced conditional logic, MarketXLS makes post-market data accessible and actionable in Excel.