Options Investing: The Best Way to Profit from Volatility

In this article

A covered call is an options strategy in which you own 100 shares of a stock and sell one call option against them, collecting the option premium as income. Volatility matters because higher implied volatility means higher call premiums, so covered calls pay more in volatile markets. The trade-off: if the stock rises above the strike, your shares are sold at the strike and you give up the gains above it, and if the stock falls, the premium only offsets part of the loss. A covered call does not profit from volatility in both directions.

See it in actionMarketXLS video

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos
Options Investing - The Best Way to Profit from Vol - options strategy analysis and payoff diagram in Excel with MarketXLS

The covered call strategy

A covered call has two parts: long 100 shares and short one call option on the same stock. Selling the call gives the buyer the right, but not the obligation, to buy your shares at the strike price until expiration. In exchange you receive the premium, which you keep whatever happens.

At expiration there are three outcomes:

  • Stock above the strike: the call is exercised and your shares are sold at the strike. Your profit is the gain up to the strike plus the premium, and nothing above the strike.
  • Stock between your purchase price and the strike: the call expires worthless. You keep the shares, the stock gain, and the premium.
  • Stock below your purchase price: the call expires worthless and you keep the shares. The premium reduces your loss, but you still lose on the stock.

How volatility affects covered calls

Option premiums rise with implied volatility, so the same call pays more when the market expects bigger price swings. That is why covered call sellers pay attention to volatility: a higher premium means more income and a lower breakeven. The risk also rises, because a volatile stock is more likely to either jump above the strike (capping your gain) or fall well below your purchase price (where the premium covers only a small part of the loss).

The covered call strategy: an example

Say you buy 100 shares of ABC at $100 and sell one 3-month call with a $105 strike for $3.00 per share ($300).

ABC price at expirationWhat happensResult per 100 shares
$110Shares called away at $105+$500 stock gain + $300 premium = +$800
$100Call expires worthless$0 stock gain + $300 premium = +$300
$90Call expires worthless-$1,000 stock loss + $300 premium = -$700

Your breakeven is $97 (purchase price minus premium), and your maximum profit is $800, reached at any price of $105 or higher.

How to use options to protect your portfolio

Covered calls provide only limited protection: the premium cushions a small decline. To protect against a large decline, investors buy put options (a protective or married put) or combine a put with a covered call (a collar). You can pull option chains and premiums into Excel with MarketXLS, for example =QM_GetOptionChain("AAPL"), to compare strikes and premiums; options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans.

This article is educational and not investment advice.

About the authors
Robin

About Robin

Co-Founder & COO, MarketXLS

Robin is a co-founder and the COO of MarketXLS. He works with Ankur and Anagh on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Robin, Ankur and Anagh.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

The Professional Investment Platform Inside Excel

Market data and options research tools in Excel

  • Option prices and Greeks in Excel
  • Historical options data in Excel
  • US stock and index options data
  • Prices and data on underlying stocks and indices
  • Use MarketXLS formulas in your Excel worksheets
  • Explore options research workflows in Excel
  • Excel formulas and sample worksheets

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo