Get Tabular Data from QuoteMedia (Dynamic)
Similar to QM_List() but the data updates dynamically. This is useful for dashboards and real-time monitoring.
Difference from QM_List
| Feature | QM_List | QM_ListDynamic |
|---|---|---|
| Updates | On refresh only | Automatically |
| Performance | Lower resource use | Higher resource use |
| Use case | Static reports | Live dashboards |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Method | String | Yes | QuoteMedia method name |
| Arg1...Arg15 | String | No | Parameter names |
| ArgVal1...ArgVal15 | String | No | Parameter values |
Notes
- Data updates automatically without manual refresh
- Uses more system resources than static version
- Ideal for live monitoring dashboards
Examples
=QM_ListDynamic("getHistory", "symbol", "AAPL")=QM_ListDynamic("getQuotes", "symbols", "AAPL,MSFT,GOOGL")=QM_ListDynamic(A1, B1, C1)When to Use
- Live monitoring dashboards
- Real-time data displays
- Auto-updating reports
- Trading screens
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need live updates | QM_List() |
| Simple price history | QM_GetHistory() |
| Specific intraday dynamic | QM_GetIntradayData*Dynamic functions |
Common Issues & FAQ
Q: Why is my spreadsheet slow?
A: Dynamic functions continuously update, using more resources. Use sparingly and consider static QM_List() for historical analysis.
Q: How often does it update? A: Update frequency depends on Excel settings and data type. Market data typically updates every few seconds during market hours.
Q: Can I control the refresh rate? A: Refresh rate is managed by Excel and the data connection. You can adjust Excel's calculation settings to manage performance.
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?