Option Filter
Returns a filtered option chain based on option type (calls/puts) and expiration date range using QuoteMedia's data service.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Underlying stock ticker |
| CallsOrPuts | String | Yes | "Calls", "Puts", or "Both" |
| StartDate | Date | Yes | Start of expiration range |
| EndDate | Date | No | End of expiration range |
Notes
- Flexible filtering for option chains
- Useful for custom screening
- Can filter by type and date simultaneously
Examples
=QM_OptionFilter("AAPL", "Calls", DATE(2024,3,1))=QM_OptionFilter("SPY", "Puts", DATE(2024,3,1), DATE(2024,6,30))=QM_OptionFilter("TSLA", "Both", TODAY())=QM_OptionFilter(A1, B1, C1, D1)When to Use
- Custom option screening
- Specific type filtering (calls only or puts only)
- Date range filtering
- Building custom analysis
When NOT to Use
Common Issues & FAQ
Q: What values can I use for CallsOrPuts? A: Use "Calls" for call options only, "Puts" for put options only, or "Both" for all options.
Q: Is EndDate required? A: No. If omitted, returns all options expiring on or after StartDate.
Q: What date format should I use? A: Use Excel's DATE() function: DATE(2024,3,15) for March 15, 2024.
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?