Yield-Based Options: What You Need to Know

In this article
YieldBased Options: What You Need to Know - options strategy analysis and payoff diagram in Excel with MarketXLS

Yield Based Options: What You Need to Know

Yield-based options, also called yield enhancement strategies, add income to a portfolio by selling options and collecting the premium. The two most common are covered calls (selling calls against shares you own) and cash-secured puts (selling puts while holding enough cash to buy the shares). The premium raises the income from a holding, but it is not free: covered calls cap your upside at the strike, and cash-secured puts oblige you to buy the stock at the strike even if it has fallen further. Neither strategy removes the risk of owning the stock.

How yield enhancement with options works

You sell an option and receive the premium up front. If the option expires worthless, you keep the full premium and can sell another. If it finishes in the money, you either deliver your shares at the strike (covered call) or buy shares at the strike (cash-secured put). The annualized "yield" is often estimated as the premium divided by the capital committed, scaled to a year.

Common yield enhancement strategies

  • Covered call: own 100 shares, sell one call above the current price. Adds income; gives up gains above the strike.
  • Cash-secured put: hold cash equal to 100 shares at the strike, sell one put below the current price. Earns income while waiting to buy a stock at a lower price; you must buy if the stock falls below the strike.
  • Collar with income: own shares, sell a call and use part of the premium to buy a put, trading upside for downside protection.

Risks and trade-offs

  • Capped upside: covered calls give up gains above the strike, which can be large in a strong rally.
  • Downside remains: the premium only cushions a small decline; a large drop in the stock still causes losses.
  • Assignment: you can be assigned early, especially around ex-dividend dates.
  • Volatility: higher implied volatility means larger premiums, but it also reflects a higher chance of big moves.

Risk-adjusted returns and reward to risk

Selling options changes the shape of returns: it adds steady income in flat or slightly rising markets and gives up part of the gains in strong markets. Whether this improves risk-adjusted returns depends on the strikes, the premium received and the market path; it is not guaranteed.

Analyzing yield strategies with MarketXLS

MarketXLS is an Excel add-in that returns option chains and quotes through formulas such as =QM_GetOptionChain("AAPL"), so you can compare premiums and annualized yields across strikes and expirations in a spreadsheet. 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.

Search for all templates in the MarketXLS templates library.

Relevant blogs that you can read to learn more about the topic

How Are Options Priced?
Black Scholes Excel
Investing in Consumer Staples Sector
Marketxls New Release Version 9.3

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