Mastering the Art of Shorting Call Options

In this article

Mastering the Art of Shorting Call Options

Shorting a call option means selling a call you do not own. You receive the option premium up front, and you keep all of it if the stock is at or below the strike price at expiration. In exchange, you take on the obligation to sell 100 shares per contract at the strike price if the option is exercised. The maximum profit is the premium received; the maximum loss on an uncovered (naked) short call is unlimited, because the stock price has no upper limit. Short calls are a neutral-to-bearish position.

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
Mastering the Art of Shorting Call Options - options strategy analysis and payoff diagram in Excel with MarketXLS

How a short call works

When you sell to open a call option, the premium is credited to your account. If the stock stays below the strike, the call loses value as expiration nears and you can let it expire or buy it back cheaply. To close early, you buy the same call back ("buy to close"); your profit or loss is the premium received minus the price you pay to close. The closing price depends on the stock price relative to the strike, implied volatility and the time left to expiration.

Breakeven at expiration: strike price + premium received.

Understanding the risks

A naked short call has unlimited risk: if the stock rises far above the strike, you must either buy the call back at a much higher price or deliver shares you would have to buy at the market price. You can also be assigned early, especially before an ex-dividend date. Selling a call against 100 shares you already own (a covered call) removes the unlimited risk, because the shares can be delivered if the call is assigned.

Managing risk and setting exits

Set exit rules before you enter: for example, buy the call back if it doubles in price, or if the stock closes above a set level. You can also turn a naked short call into a defined-risk bear call spread by buying a higher-strike call with the same expiration.

Margin requirements

Brokers require margin for naked short calls, and usually a high options approval level. The margin requirement can rise quickly as the stock moves against you, which can force you to add cash or close the position at a loss. Check your broker's requirements before selling uncovered calls.

Analyzing short calls with MarketXLS

MarketXLS is an Excel add-in that returns option chains, quotes and Greeks through formulas such as =QM_GetOptionChain("AAPL") and =QM_GetOptionQuotesAndGreeks("AAPL"), so you can compare premiums, deltas and breakevens across strikes in a spreadsheet. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans; see pricing.

Conclusion

Shorting a call earns the premium if the stock stays below the strike, but a naked short call carries unlimited risk and margin demands. Most investors who want call-selling income use covered calls or bear call spreads, which cap the risk. This article is educational and not investment advice.

Here are some templates that you can use to create your own models

Delta Neutral Hedging

Search for all templates in the MarketXLS templates library.

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

Use of Options to Hedge Market Risk
How to hedge a drop in S&P 500 Using MarketXLS
Covered Calls- Managing And Tracking

Options Trading (Strategies)
Short Guts & Long Guts Option Strategy

About the authors
Anagh

About Anagh

CTO, MarketXLS

Anagh is the CTO of MarketXLS. He works with Ankur and Robin on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Anagh, Ankur and Robin.

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