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
Examples
=QM_Stream_Value("Last", "AAPL")=QM_Stream_Value("Bid", "MSFT")=QM_Stream_Value("Volume", "TSLA")=QM_Stream_Value("Vwap", "SPY")=QM_Stream_Value(A1, B1)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
Q: Why am I getting #N/A? A: Check that:
- The metric name is valid
- The symbol format is correct
Q: Which metrics are available? A: Common metrics: Last, Bid, Ask, Volume, Open, High, Low, Close, Change, PercentageChange, Vwap, Twap.
Q: Why isn't the data updating? A: Ensure RTD is enabled in Excel and QuoteMedia connection is active.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?