Optionable
Returns whether exchange-traded options are available for a given stock.
Syntax
=IsOptionable(Symbol)Returns
string
Whether options are available (Yes/No)
Examples
=IsOptionable("AAPL")=IsOptionable("SPY")When to Use
- Options trading research
- Strategy selection
- Covered call screening
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Option prices | Option pricing functions |
| Strike prices | StrikeNext() |
Common Issues & FAQ
Why might a stock not be optionable?
Low volume, price too high/low, or recently IPO'd.
Related Formulas
More MarketXLS Profile formulas you can use in the same worksheet:
- Profile Value
- Sector
- Share Percent Held By Insiders
- Share Percent Held by Institutions
- Shares Outstanding
- Shares Outstanding (On Demand)
- Shares Owned
- Shares Short
See IsOptionable used in a complete workbook: Live Option Chain Data in Google Sheets: What GOOGLEFINANCE Covers and Where MarketXLS Picks Up
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?