MarketXLS

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

Syntax

=QM_ListDynamic(Method, [Arg1], [ArgVal1], [Arg2], [ArgVal2], ...)
Excel Desktop (Windows)

Parameters

methodstringRequired

The QuoteMedia method/endpoint to call

arg1string

First argument name

argVal1string

First argument value

Returns

array

Dynamically updating tabular data from QuoteMedia

Examples

=QM_ListDynamic("getHistory", "symbol", "AAPL")
Dynamic AAPL history
=QM_ListDynamic("getQuotes", "symbols", "AAPL,MSFT,GOOGL")
Dynamic quotes
=QM_ListDynamic(A1, B1, C1)
Parameters from cells

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

Why is my spreadsheet slow?

Dynamic functions continuously update, using more resources. Use sparingly and consider static QM_List() for historical analysis.

How often does it update?

Update frequency depends on Excel settings and data type. Market data typically updates every few seconds during market hours.

Can I control the refresh rate?

Refresh rate is managed by Excel and the data connection. You can adjust Excel's calculation settings to manage performance.

Related Formulas

More MarketXLS Price History formulas you can use in the same worksheet:

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 Get Tabular Data from QuoteMedia (Dynamic) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions