QM_Stream_PreMarketPercentChange: Real-Time Pre-Market Percentage Change in Excel

The QM_Stream_PreMarketPercentChange function is designed to fetch the latest pre-market percent change for a given stock symbol directly in Excel using MarketXLS. This real-time streaming function helps you quickly stay informed about after-hours market movements, so you can plan your trades and strategies as soon as possible.

Why Use This Function?

• Enables real-time tracking of pre-market movements for rapid decision-making.
• Perfect for monitoring high-volatility stocks that often move significantly when the market is closed.
• Easily integrated into your existing Excel sheets and dashboards.
• Provides a direct link to stock data—no need for manual refreshing.
• Supports active trading strategies that rely on pre-market swings.

How to Use in Excel

=QM_Stream_PreMarketPercentChange("SYMBOL")

1. Enter the formula into a cell in Excel.
2. Replace "SYMBOL" with the stock ticker you want to track (e.g., "AAPL", "MSFT").
3. Press Enter. If your subscription is active and the symbol is valid, the real-time pre-market percent change will appear.

Note: This function leverages real-time data (RTD). MarketXLS licensing and data subscription settings must be properly configured in your MarketXLS add-in for success.

Parameters Explained

Example Usage

Basic Examples

• =QM_Stream_PreMarketPercentChange("AAPL")
Retrieves Apple’s real-time pre-market percentage change data.

• =QM_Stream_PreMarketPercentChange("MSFT")
Retrieves Microsoft’s real-time pre-market percentage change data.

• =QM_Stream_PreMarketPercentChange(A2)
If cell A2 contains "TSLA", returns Tesla’s pre-market percent change.

In all cases, the value updates in real time as long as your MarketXLS subscription and RTD service are active.

Advanced Scenarios

• Integrating with Portfolio Tracking:
Combine multiple calls in a watchlist. For instance, if you have a column of ticker symbols, you can reference them with this function to build a live pre-market percent change table.

• Immediate Reaction to Earnings Announcements:
Use this function to see how the market reacts overnight to earnings reports. If a company reports after the market closes, track the immediate stock movement before the next opening bell.

• Conditional Formatting:
Highlight cells red or green based on percentage thresholds (e.g., highlight if the function returns a value ? +5%). This helps you spot significant pre-market moves at a glance.

Common Questions and Troubleshooting

• What if I get “NA” or “ERR”?

• “NA” often appears if the symbol is invalid or empty. Double-check your ticker.
• “ERR” can surface if there’s an unexpected problem (e.g., license or streaming issue). Review your MarketXLS settings or licensing status.

• Why doesn’t the value change?

• Ensure your MarketXLS license and real-time data subscription are active.
• Confirm that RTD is enabled and symbols are queued.

• How frequently does the data update?

• Updates occur based on the MarketXLS real-time data feed. You don’t need to manually refresh the cell.

Remember:

• Always confirm you have a valid data subscription and license.
• Test out multiple symbols to ensure proper functioning.
• Integrate with other Excel formulas or references to build robust real-time dashboards.
• Pre-market data is subject to fluctuating liquidity and may differ from regular trading hours data.