QM_List — Generic QuoteMedia Data Pass-Through
A flexible function that calls any QuoteMedia REST API endpoint directly. Specify the method name and parameters to retrieve any supported data.
Available Methods
Quotes & Price Data
| Method | Description | Key Params |
|---|---|---|
| getEnhancedQuotes | Rich quote with fundamentals (PE, EPS, market cap, beta, dividend info, 52-week high/low, float, sector/industry) | symbols |
| getSnapQuotes | Full real-time quote (last, bid, ask, volume, imbalance data) | symbols |
| getQuotesMini | Lightweight quote (last, bid, ask, timestamps) | symbols |
Historical & Intraday
| Method | Description | Key Params |
|---|---|---|
| getHistory | Daily OHLCV price history | symbol, startDate, endDate |
| getFullHistory | Complete daily price history | symbol |
| getIntervals | Intraday bars at specified interval | symbol, interval (1, 5, 15, 60, 240) |
| getIntraday | Intraday tick-level data | symbol |
Options
| Method | Description | Key Params |
|---|---|---|
| getOptionQuotes | Full option chain | symbol, money (All/In/Out/At), greeks (True) |
| getOptionChainSymbols | List all option symbols for underlying | symbol |
| getRecentOptionStats | Daily put/call volume and open interest | symbol |
Trading Activity
| Method | Description | Key Params |
|---|---|---|
| getRecentTradesBySymbol | Last N trades with price, volume, exchange, flags | symbol |
| getMarketOpenStatus | Check if market is currently open | symbol |
Fundamentals & Research (may require additional entitlements)
| Method | Description | Key Params |
|---|---|---|
| getProfiles | Company profile | symbol |
| getBasicFundData | Basic fundamental data | symbol |
| getAnalyst | Analyst ratings | symbol |
| getDividendsBySymbol | Dividend history | symbol |
| getEarningsEstimatesBySymbol | Earnings estimates | symbol |
| getEarningsSurprisesBySymbol | Earnings surprises | symbol |
| getInsiderSummaryBySymbol | Insider trading summary | symbol |
| getHeadlines | News headlines | symbol |
Parameter Notes
- Use symbol (singular) for most endpoints
- Use symbols (plural, comma-separated) for quote endpoints: getEnhancedQuotes, getSnapQuotes, getQuotesMini
- interval for getIntervals: 1 (1-min), 5 (5-min), 15 (15-min), 60 (1-hour), 240 (4-hour)
- money for options: All, In, Out, At
- greeks: True to include option greeks
Syntax
=QM_List(Method, [Arg1], [ArgVal1], [Arg2], [ArgVal2], ...)Parameters
The QuoteMedia method/endpoint to call
First argument name
First argument value
Returns
Tabular data from QuoteMedia
Examples
When to Use
- Need custom QuoteMedia queries
- Parameters not supported by dedicated functions
- Advanced data retrieval needs
- Building flexible data templates
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Simple price history | QM_GetHistory() |
| Intraday data | QM_GetIntradayData* functions |
| Option chain | QM_GetOptionChain() |
| Need dynamic updates | QM_ListDynamic() |
Common Issues & FAQ
What methods are available?
Common methods include getHistory, getQuotes, getOptionChain. Refer to QuoteMedia API documentation for full list.
How do I know what arguments to use?
Each method has its own required and optional arguments. Common ones include: symbol, symbols, days, startDate, endDate.
Why use this instead of dedicated functions?
Use dedicated functions when available. This function is for advanced cases where you need specific parameters not exposed by other functions.
Excel Templates Using Get Tabular Data from QuoteMedia
These ready-made MarketXLS templates call QM_List() in their worksheet formulas. Open one to see the function working inside a complete model.
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