Stream Pre-Market Volume Data Instantly with MarketXLS

The QM_Stream_PreMarketVolume function offers real-time, streaming data for a stock’s pre-market volume directly in Excel. With MarketXLS, you can monitor how many shares are traded before the market officially opens, providing valuable insights for trading decisions and market analysis. This function seamlessly integrates with Excel so you can track and react to changes in pre-market volume from the convenience of your spreadsheet.

Why Use This Function?

• Stay informed on overnight trading activity to gauge early market sentiment.
• Identify potential open price volatility by examining increased (or decreased) pre-market volume.
• Seamlessly integrate with other MarketXLS real-time data functions in your trading spreadsheets.
• Ideal for traders and investors seeking an edge during pre-market hours.
• Ensures you have an up-to-date view of pre-market activity without manual data lookups.

How to Use in Excel

=QM_Stream_PreMarketVolume("symbol")

1. Type “=QM_Stream_PreMarketVolume(” in a cell.
2. Provide a stock “symbol” in quotes (e.g., "AAPL").
3. Press Enter. The function will display real-time pre-market volume.
4. If the symbol is valid and your MarketXLS license is configured, you will see the streaming number of traded shares.

Parameters Explained

Example Usage

Basic Examples

1. =QM_Stream_PreMarketVolume("AAPL")
   • Streams the current pre-market traded volume for Apple (AAPL) directly in your Excel worksheet.
2. =QM_Stream_PreMarketVolume("MSFT")
   • Streams Microsoft’s pre-market volume seamlessly in Excel.

Advanced Scenarios

• Combine multiple streaming functions in a table:
  For instance, pair QM_Stream_PreMarketVolume with other MarketXLS RTD formulas (like pre-market price or bid-ask data) to build a real-time dashboard.
• Automate alerts:
  Use conditional formatting to highlight certain cells if pre-market volume hits or exceeds a threshold you choose.

Common Questions and Troubleshooting

• “NA” Returned:
  Ensure the symbol is valid. If the symbol is incorrect or blank, the function displays “NA”.
• License Error Messages:
  If MarketXLS license validation fails, you’ll see an error message instead of volume data. Check your subscription or license configuration.
• Configuration Issues:
  If data subscriptions are not configured properly, the function may return a message indicating it’s not set up. Verify your “Settings >> Data Subscriptions” in MarketXLS.
• Empty or Delayed Data:
  If the market is closed or no pre-market trades have occurred, volume could be zero or show minimal updates.

Remember:

• Double-check your symbol’s validity.
• Keep your MarketXLS license active to maintain streaming data.
• Stream data for US stocks or any other supported symbol based on your data plan.

With QM_Stream_PreMarketVolume, you can confidently track pre-market activity and integrate it into your Excel-based trading strategies. By leveraging real-time data, you’ll be better poised to act on market movements the moment the opening bell rings.