MarketXLS

Stream Data from QM Data Bundles

Streams real-time data for any available QuoteMedia metric. This is a flexible function that allows you to specify which data point you want to stream.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX
Options OCC Symbol AAPL240315C00170000

Available Metrics

Common metrics include: Last, Bid, Ask, Volume, Open, High, Low, Close, Change, PercentageChange, Vwap, and more.

Notes

  • Data streams automatically update in Excel
  • Uses RTD (Real-Time Data) technology

Syntax

=QM_Stream_Value(Metric, Symbol)
Excel Desktop (Windows)

Parameters

metricstringRequired

The data metric to stream (e.g., Last, Bid, Ask, Volume)

symbolstringRequired

Stock ticker symbol

Returns

varies

Real-time streaming value for the specified metric

Examples

=QM_Stream_Value("Last", "AAPL")
Stream last price for Apple
=QM_Stream_Value("Bid", "MSFT")
Stream bid price for Microsoft
=QM_Stream_Value("Volume", "TSLA")
Stream volume for Tesla
=QM_Stream_Value("Vwap", "SPY")
Stream VWAP for SPY ETF
=QM_Stream_Value(A1, B1)
Metric and symbol from cells

When to Use

  • Dynamic metric selection via cell reference
  • Building flexible real-time dashboards
  • When metric type is determined by user input
  • Creating generic streaming templates

When NOT to Use

Scenario Use Instead
Need specific last price QM_Stream_Last()
Need specific bid/ask QM_Stream_Bid(), QM_Stream_Ask()
Need on-demand snapshot QM_Last()
Need historical data Close_Historical()

Common Issues & FAQ

Why am I getting #N/A?

Check that:

  • The metric name is valid
  • The symbol format is correct

Which metrics are available?

Common metrics: Last, Bid, Ask, Volume, Open, High, Low, Close, Change, PercentageChange, Vwap, Twap.

Why isn't the data updating?

Ensure RTD is enabled in Excel and QuoteMedia connection is active.

Related Formulas

More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:

See QM_Stream_Value used in a complete workbook: Stay Ahead with SGX Nifty Live tracking (with MarketXLS)

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 Data from QM Data Bundles and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions