Get a Value from QuoteMedia
A generic function that retrieves any available QuoteMedia metric for a given symbol. This is useful for accessing data points that don't have dedicated functions.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Options (OCC) | SYMBOL+YYMMDD+C/P+STRIKE | AAPL240315C00170000 |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Metric | String | Yes | The QuoteMedia field name to retrieve |
| Symbol | String | Yes | Stock ticker or option symbol |
Common Metrics
| Metric | Description |
|---|---|
| bid | Current bid price |
| ask | Current ask price |
| last | Last trade price |
| change | Price change |
| pctchange | Percent change |
| volume | Trading volume |
| open | Opening price |
| high | Day high |
| low | Day low |
Notes
- This is a flexible function for accessing any QuoteMedia field
- For common data points, consider using dedicated functions for clarity
Examples
When to Use
- Access specific QuoteMedia metrics
- Build flexible spreadsheets with dynamic metrics
- Get data not covered by dedicated functions
- Quick data exploration
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need last price | QM_Last() or Last() |
| Need volume | QM_Volume() |
| Need streaming data | QM_Stream_* functions |
| Need historical data | QM_GetHistory() |
Common Issues & FAQ
Q: What metrics are available? A: Common metrics include: bid, ask, last, change, pctchange, volume, open, high, low, close, prevclose, and many more.
Q: Why am I getting an error? A: Check that:
- The metric name is spelled correctly
- The symbol is valid
- QuoteMedia supports the metric for this security type
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?