Option Chain Monthlies
Returns only monthly expiration options from the option chain using QuoteMedia's data service.
What are Monthly Options?
Monthly options (also called "standard" options) expire on the third Friday of each month. These are the traditional option expirations:
- More liquidity than weeklies for most stocks
- Standard settlement procedures
- Available on virtually all optionable stocks
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 |
Notes
- Monthly options expire on 3rd Friday
- Usually most liquid standard expirations
- Available on all optionable stocks
Examples
=QM_GetOptionChainMonthlies("AAPL")=QM_GetOptionChainMonthlies("SPY")Symbol from cell reference
When to Use
- Standard options trading
- Monthly income strategies
- Traditional options analysis
- Stocks without weekly options
When NOT to Use
Common Issues & FAQ
Q: When exactly do monthly options expire? A: Monthly options expire on the third Friday of the month at market close (4:00 PM ET).
Q: Are monthly options more liquid than weeklies? A: Generally yes, especially for less actively traded stocks. Weekly options are only available on highly liquid symbols.
Q: What if the third Friday is a holiday? A: If Friday is a holiday, options expire on the Thursday before.
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?