Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Real-Time Trade Count with QM_Stream_TradeCount

The QM_Stream_TradeCount function helps you track the number of trades for a given symbol in real time. It is especially useful for active traders who need up-to-the-second trade information directly within Excel. By leveraging MarketXLS’s streaming capabilities, you can monitor market liquidity and transaction activity without manually refreshing or navigating away from your spreadsheets.

Why Use This Function?

  • Provides real-time trade counts for any valid stock symbol.
  • Seamlessly updates in Excel using RTD streaming—no manual refresh needed.
  • Helps gauge liquidity and market activity for intraday trading or analysis.
  • Allows integration with other Excel calculations for deeper insights.
  • Ideal for traders, analysts, or anyone needing up-to-date transaction data.

How to Use in Excel

=QM_Stream_TradeCount("symbol")
  1. In any cell, enter the formula =QM_Stream_TradeCount("AAPL") (replace "AAPL" with your chosen ticker).
  2. Ensure you have a valid MarketXLS license and data subscription configured for streaming quotes.
  3. The function will automatically stream the latest trade count for that symbol.

Parameters Explained

Parameter Description Example Values Notes
symbol The ticker symbol representing the stock or instrument you want to track. AAPL, MSFT Must be a valid, recognized symbol. Empty or invalid symbols typically return "NA".

Example Usage

Basic Examples

  1. =QM_Stream_TradeCount("AAPL")
    • Returns the streaming, real-time trade count for Apple Inc.
    • Updates automatically in Excel as trading occurs.

  2. =QM_Stream_TradeCount("MSFT")
    • Shows the ongoing trade count for Microsoft in real time.

  3. =QM_Stream_TradeCount(A1)
    • If A1 contains a valid ticker symbol (e.g., "TSLA"), cell returns the real-time trade count for that symbol.
    • Helps quickly switch between symbols by updating the value in A1.

Advanced Scenarios

  • Combine QM_Stream_TradeCount with other MarketXLS RTD functions (e.g., real-time price, volume) for a comprehensive, real-time trading dashboard.
  • Track trade counts across multiple symbols in a single Excel sheet to compare liquidity or trading interest side-by-side.
  • Integrate with macros or conditional formatting to highlight when trade counts exceed certain thresholds (e.g., sudden spikes in activity).

Common Questions and Troubleshooting

• “Why am I getting ‘NA’?”

  • Check that you entered a valid symbol. If the symbol is invalid or empty, the function returns “NA.”

• “Why do I see a message about licensing?”

  • Ensure your MarketXLS subscription is active and properly configured under Settings ? Data Subscriptions. An invalid license returns a licensing error.

• “What if the function doesn’t update automatically?”

  • Verify you have real-time streaming enabled and functioning. Recheck your MarketXLS data subscription status and that the symbol is correctly added to the RTD queue.

• “Can I reference cells containing stock symbols?”

  • Yes. Simply replace the literal symbol with a cell reference. The function will stream the trade count for whichever valid ticker is in that cell.

In summary, QM_Stream_TradeCount offers a powerful way to stay on top of real-time trading activity. Whether you’re monitoring liquidity or quickly comparing transaction volumes across multiple stocks, MarketXLS’s streaming function ensures your Excel sheet is always up to date with the latest trade counts. By leveraging additional MarketXLS RTD functions alongside QM_Stream_TradeCount, you can create a robust, real-time trading tool that helps inform your decisions every step of the way.

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 Trade Count and Other Financial Formulas
How does MarketXLS work?