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
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
Q: What methods are available? A: Common methods include getHistory, getQuotes, getOptionChain. Refer to QuoteMedia API documentation for full list.
Q: How do I know what arguments to use? A: Each method has its own required and optional arguments. Common ones include: symbol, symbols, days, startDate, endDate.
Q: Why use this instead of dedicated functions? A: Use dedicated functions when available. This function is for advanced cases where you need specific parameters not exposed by other functions.
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?