Option Chain Out Of The Money

Returns only out-of-the-money (OTM) options from the option chain using QuoteMedia's data service.

What is Out-of-the-Money (OTM)?

Option Type OTM When
Call Strike > Current Stock Price
Put Strike < Current Stock Price

OTM options have no intrinsic value - only time value (extrinsic value).

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

  • Filters chain to only OTM options
  • Lower premium than ITM options
  • Higher percentage returns but higher risk

Syntax

=mxls.QM_GetOptionChainOutOfTheMoney(Symbol)
Excel Online (Mac & Windows)

Examples

=mxls.QM_GetOptionChainOutOfTheMoney("AAPL")
OTM options for Apple
=mxls.QM_GetOptionChainOutOfTheMoney("SPY")
OTM options for SPY
=mxls.QM_GetOptionChainOutOfTheMoney(A1)
Symbol from cell reference

When to Use

  • Speculative trading strategies
  • Lower capital requirement
  • High risk/reward trades
  • Selling premium strategies

When NOT to Use

Scenario Use Instead
Need full option chain QM_GetOptionChain()
Need ITM options QM_GetOptionChainInTheMoney()
Need ATM options QM_GetOptionChainAtTheMoney()
Need all with Greeks QM_GetOptionQuotesAndGreeks()

Common Issues & FAQ

What determines if an option is OTM?

For calls: strike > stock price. For puts: strike < stock price.

Why are OTM options cheaper?

OTM options have no intrinsic value, only time value. They expire worthless if the stock doesn't move favorably.

What's the risk of OTM options?

Higher chance of expiring worthless. However, they offer leveraged exposure with limited capital.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Option Chain Out Of The Money and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions