Rolling Options: How to Roll Up, Down, and Out for Better Returns in Excel

In this article

What Does "Rolling an Option" Mean?

Rolling an option means closing an existing options position and opening a new one on the same underlying at the same time, usually with a later expiration (rolling out), a higher strike (rolling up), a lower strike (rolling down), or a combination. Traders roll to buy more time, lock in gains, or avoid assignment. The cost of a roll is the difference between what you receive for the old contract and what you pay for the new one, which you can calculate in Excel with MarketXLS option prices.

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
Rolling Options - how to roll up, down, and out with strategy comparison and Excel analysis using MarketXLS

For example, you placed a bet that AAPL would reach $200 by March. March is approaching, the stock is at $195, and you still believe the move is coming, just not yet. Instead of letting the option expire worthless or closing at a loss, you roll the position to April (or even June), giving your thesis more time to play out.

Rolling options is not a single strategy—it's a family of adjustments. You can roll up, roll down, roll out, or combine these moves. Each variation serves a different purpose, from locking in partial gains to managing losing trades defensively.

In this guide, we'll cover every type of roll, when each makes sense, the costs involved, and how to execute and analyze rolls directly in Excel using MarketXLS.

Why Traders Roll Options Instead of Closing

Before diving into the mechanics, it's worth understanding why rolling is often preferable to simply closing a position:

  • Your thesis is intact. The trade hasn't worked yet, but you still believe in the direction. Rolling buys time without starting over.
  • You want to lock in partial gains. If a call has moved in your favor, rolling up captures some profit while maintaining upside exposure.
  • Avoid assignment. Short option sellers facing assignment risk can roll to a later expiration to sidestep exercise.
  • Tax timing. Closing and reopening may trigger wash-sale complications. Rolling in a single transaction can simplify record-keeping (consult your tax advisor).
  • Reduce cost basis. Rolling a covered call or cash-secured put to a higher-premium contract can lower your effective cost basis on the underlying.

The alternative—closing and walking away—makes sense when your thesis has changed, when the cost of rolling exceeds the expected benefit, or when you need to free up capital. We'll cover the "roll vs. close" decision in detail below.

The Four Types of Option Rolls

Rolling options breaks down into four primary variations. Each adjusts a different parameter of your contract.

Roll Out (Roll Forward)

What it is: Close the current option and open a new one at the same strike price but with a later expiration date.

When to use it: Your directional view hasn't changed, but you need more time. This is the most common roll and the simplest to execute.

Example: You hold an AAPL April $200 call. The stock is at $197 with two weeks to expiration. You sell the April $200 call and buy the May $200 call. The net cost is the difference in premiums (the "debit" to roll).

Key consideration: Rolling out always costs money for long options because the later-dated contract carries more time value. For short options, rolling out typically generates a credit because you're selling more time premium.

Roll Up

What it is: Close the current option and open a new one at a higher strike price. The expiration may stay the same or change.

When to use it: The underlying has moved in your favor (for calls), and you want to take some profit off the table while maintaining upside exposure. Also used defensively for short puts that have moved against you.

Example: You bought an AAPL April $190 call when the stock was at $188. AAPL has rallied to $205. You sell the $190 call (capturing intrinsic value) and buy an April $210 call. The roll generates a net credit because the $190 call is deep in-the-money.

Key consideration: Rolling up a long call locks in gains but reduces your delta exposure. You're trading certainty (realized profit) for continued upside with less capital at risk.

Roll Down

What it is: Close the current option and open a new one at a lower strike price. Again, expiration may or may not change.

When to use it: The underlying has moved against your call position, and you want to lower your breakeven point. For puts, rolling down is an offensive move when the stock drops further than expected.

Example: You sold an AAPL April $200 covered call. The stock drops to $185. You buy back the $200 call cheaply and sell a $190 call to collect more premium, lowering your effective cost basis.

Key consideration: Rolling down a short call collects additional premium but brings assignment risk closer to the current price. Balance income against the risk of having shares called away.

Roll Up and Out (Combination Roll)

What it is: Change both the strike price and the expiration date simultaneously. This is the most flexible—and most complex—type of roll.

When to use it: You need both a strike adjustment and more time. Common for covered call writers who want to avoid assignment while extending income generation, or for long option holders managing a losing position.

Example: You sold an AAPL April $195 covered call. The stock has rallied to $198 and you don't want assignment. You buy back the April $195 call and sell a May $205 call. If the credit from the May $205 exceeds the cost to close the April $195, you execute the roll for a net credit.

Key consideration: Combination rolls require careful cost analysis. The further out in time and strike you go, the more variables are in play—implied volatility, theta decay rate, and delta all shift.

Comparison: Roll Types at a Glance

Roll TypeStrike ChangeExpiration ChangeTypical Cost (Long)Typical Cost (Short)Best For
Roll OutSameLaterNet debitNet creditBuying more time, same thesis
Roll UpHigherSame or laterNet credit (calls)Net debit (puts)Locking in call gains, defensive put adjustment
Roll DownLowerSame or laterNet debit (calls)Net credit (calls)Lowering breakeven, collecting more premium
Roll Up & OutHigher + LaterLaterVariesOften net creditAvoiding assignment + extending income

Offensive vs. Defensive Rolls

Not all rolls serve the same strategic purpose. It helps to categorize them by intent:

Offensive Rolls

Offensive rolls are made from a position of strength. Your trade is working, and you want to optimize it:

  • Rolling up a winning call to lock in profits while staying long.
  • Rolling out a profitable short put to collect additional premium on a stock you're happy to own.
  • Rolling down a winning put to capture more downside if your bearish thesis is accelerating.

The goal of an offensive roll is to maximize total return on a trade that's already moving in your direction.

Defensive Rolls

Defensive rolls are damage-control moves. Your trade is losing or facing assignment, and you want to buy time or reduce risk:

  • Rolling out a losing call to give the stock more time to reach your strike.
  • Rolling down a losing long call to lower your breakeven (though this often means spending more premium).
  • Rolling up and out a short call to avoid assignment when the stock rallies past your strike.
  • Rolling out a short put when the stock drops and you want to avoid being assigned shares at an unfavorable price.

The goal of a defensive roll is to give the position a second chance without dramatically increasing risk.

When to Roll vs. When to Close

The decision to roll or close comes down to a few key questions:

  1. Is your thesis still valid? If the fundamental reason for the trade has changed, close the position. Rolling a broken thesis just delays the inevitable.
  2. What's the cost of the roll? Calculate the net debit or credit. If rolling costs more than the expected value of the new position, closing is better.
  3. How much time are you buying? Rolling out one week rarely makes sense—theta decay accelerates in the final weeks. Roll to a meaningful time horizon (30–60 days is common).
  4. What's your opportunity cost? Capital tied up in a rolled position can't be deployed elsewhere. If you see a better trade, take it.
  5. Have you hit your maximum loss threshold? Every trade should have a predefined loss limit. If rolling would exceed that limit, close instead.

Rule of thumb: If you wouldn't enter the new position as a fresh trade, don't roll into it.

How Time Decay (Theta) Affects Rolling Decisions

Time decay is the silent partner in every rolling decision. Here's how it works in practice:

  • For long options: Theta works against you. As expiration approaches, your option loses value faster each day. Rolling out resets the clock, but you pay for that privilege through the debit required to enter the later-dated contract.
  • For short options: Theta works in your favor. Short sellers want time decay. Rolling out a short option collects more premium but also resets the theta curve, meaning you wait longer for the full decay.

The theta acceleration zone: Time decay speeds up as expiration approaches, especially for at-the-money options in the final few weeks. Many traders roll with about 14 to 21 days remaining, before the steepest decay.

Practical tip: Compare the daily theta of your current position versus the rolled position. If the new contract's theta is significantly lower (in absolute terms), the roll extends your time horizon efficiently.

How Implied Volatility Impacts Rolling

Implied volatility (IV) is the second critical variable in roll analysis:

  • High IV environment: Option premiums are elevated. Rolling out costs more for long positions (you're buying expensive time) but generates larger credits for short positions (you're selling expensive time). High IV is generally favorable for rolling short options.
  • Low IV environment: Premiums are cheap. Long holders can roll out at lower cost, but short sellers receive less premium for the extension. Low IV is generally favorable for rolling long options.
  • IV skew between expirations: Sometimes near-term IV is elevated (e.g., ahead of earnings) while further-dated IV is calmer. This skew affects the cost of rolling—you might sell expensive near-term volatility and buy cheaper far-term volatility, creating a favorable spread.

Practical tip: Before rolling, compare the IV of your current contract versus the target contract. If you're rolling a long option into a significantly higher-IV contract, you're overpaying for time. Consider waiting for IV to normalize or choosing a different expiration.

Step-by-Step: How to Roll an Option

Here's the mechanical process for executing a roll, applicable to any roll type:

Step 1: Assess Your Current Position

Review your existing option's Greeks, current price, and time remaining. Determine whether it's in-the-money (ITM), at-the-money (ATM), or out-of-the-money (OTM).

Step 2: Define Your Roll Parameters

Decide which type of roll you need:

  • Same strike, later date → Roll out
  • Higher strike → Roll up
  • Lower strike → Roll down
  • Both → Combination roll

Step 3: Analyze the New Contract

Compare the new option's premium, Greeks (especially delta and theta), implied volatility, and open interest. Ensure sufficient liquidity—wide bid-ask spreads can make rolls expensive.

Step 4: Calculate the Net Cost

  • For long positions: Net cost = premium of new option − proceeds from closing old option. A positive number is a debit (costs money); negative is a credit (generates income).
  • For short positions: Net cost = cost to buy back old option − premium received for new option.

Step 5: Execute as a Spread Order

Most brokerages allow you to execute a roll as a single spread order (sell-to-close + buy-to-open, or buy-to-close + sell-to-open). This ensures simultaneous execution and often provides better fills than legging in separately.

Step 6: Monitor the New Position

After rolling, track the new position as you would any fresh trade. Set new profit targets and stop-loss levels.

How to Analyze Option Rolls in Excel with MarketXLS

MarketXLS pulls option chains and option prices into Excel, so you can calculate the cost of each roll candidate in a worksheet. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans. On Mac or Excel for the web, prefix functions with mxls.. Here's how to set up a roll analysis worksheet:

Pull the Current Stock Price

Start by getting the current price of your underlying:

=Last("AAPL")

Formula documentation: Last

This returns the last traded price for AAPL, which you'll reference throughout your analysis.

Load the Option Chain

To see all available strikes and expirations:

=QM_GetOptionChain("AAPL")

Formula documentation: QM_GetOptionChain

This populates a full option chain with strikes, expirations, bid/ask prices, volume, and open interest. Use this to identify your target roll contract.

Build Option Symbols

Once you've identified the strike and expiration for your roll, construct the option symbol:

=OptionSymbol("AAPL", "2026-04-17", "C", 200)

Formula documentation: OptionSymbol

This returns the QuoteMedia option symbol (e.g., @AAPL 260417C00200000, with the ticker padded to six characters) that you can use to pull quotes. Referencing the OptionSymbol cell is safer than typing the symbol.

For the new contract you're rolling into:

=OptionSymbol("AAPL", "2026-05-15", "C", 200)

Formula documentation: OptionSymbol

Get Live Option Prices

With your option symbols, pull prices for both the old and new contracts:

=QM_Last("@AAPL 260417C00200000")

Formula documentation: QM_Last

=QM_Last("@AAPL 260515C00200000")

Formula documentation: QM_Last

Calculate the Roll Cost

In a separate cell, compute the net cost:

=QM_Last("@AAPL 260515C00200000") - QM_Last("@AAPL 260417C00200000")

Formula documentation: QM_Last

A positive result means the roll costs a net debit; negative means you receive a net credit.

Build a Roll Comparison Table

Create a worksheet that compares multiple roll candidates side by side:

Current PositionRoll Out (May)Roll Up & Out (May $210)
Symbol=OptionSymbol("AAPL","2026-04-17","C",200)=OptionSymbol("AAPL","2026-05-15","C",200)=OptionSymbol("AAPL","2026-05-15","C",210)
Last Price=QM_Last(B2)=QM_Last(C2)=QM_Last(D2)
Stock Price=Last("AAPL")=Last("AAPL")=Last("AAPL")
Net Roll Cost—=C3-B3=D3-B3

This layout lets you instantly compare the cost of different roll scenarios and make data-driven decisions.

Monitor Greeks with the Option Chain

Use =QM_GetOptionChain("AAPL") to compare delta, gamma, theta, and vega across your candidates. Pay special attention to:

  • Theta: Is the new contract's daily decay rate acceptable?
  • Delta: Does the new strike give you the directional exposure you want?
  • Open Interest: Is there enough liquidity for clean execution?

The QM_ functions return a snapshot that updates when Excel recalculates; for continuously updating prices, use the QM_Stream_ functions (Advanced and Business plans).

Real-World Rolling Scenarios

Scenario 1: Rolling Out a Covered Call

You own 100 shares of AAPL at $190 and sold an April $200 covered call for $4.50. AAPL is at $198 with 10 days to expiration. You don't want assignment.

Action: Buy back the April $200 call (now trading at $6.00) and sell the May $205 call for $5.00.

Net cost: $6.00 − $5.00 = $1.00 debit per share ($100 total).

Result: You've moved the assignment trigger $5 higher and bought 30+ more days. The $1.00 debit reduces your total premium collected to $3.50, but you keep your shares and maintain income potential.

Scenario 2: Rolling Down a Losing Long Call

You bought an AAPL April $210 call for $5.00. The stock has dropped to $195, and your call is worth $1.50. You still believe AAPL will recover but need a lower breakeven.

Action: Sell the April $210 call for $1.50 and buy the May $200 call for $6.00.

Net cost: $6.00 − $1.50 = $4.50 debit. Total invested: $5.00 (original) + $4.50 (net roll debit) = $9.50.

Result: Counting everything you have paid, your breakeven moves from $215 to $209.50 ($200 strike + $9.50), and you've gained 30+ extra days. However, your total capital at risk has increased. Only roll if you have high conviction.

Scenario 3: Offensive Roll Down on a Winning Put

You bought an AAPL April $200 put for $3.00 when the stock was at $198. AAPL has dropped to $182, and your put is now worth $19.00.

Action: Sell the April $200 put for $19.00 and buy an April $185 put for $5.00.

Net credit: $19.00 − $5.00 = $14.00 credit ($1,400 per contract taken off the table). You keep bearish exposure through the $185 put.

Result: You've banked $14.00 per share in profit while keeping a bearish position if the decline continues.

Costs and Risks of Rolling Options

Transaction Costs

Every roll involves two trades (close + open), meaning double the commissions and fees. While most brokers charge minimal per-contract fees, frequent rolling on large positions can add up.

Bid-Ask Spread

The bid-ask spread is often the largest hidden cost of rolling. Illiquid options can have spreads of $0.20–$0.50 or more. With two legs, you're paying the spread twice. Always check open interest and volume before rolling.

Increased Capital at Risk

Rolling out a losing long position means committing additional capital. Each roll raises your total investment, and if the trade ultimately fails, losses compound.

Opportunity Cost

Capital locked in a rolled position cannot be used elsewhere. If a better setup emerges, you may regret being tied to a mediocre trade.

Over-Rolling

Some traders develop a habit of rolling losing positions indefinitely, hoping for a turnaround that never comes. Set a maximum number of rolls or a total loss limit for each trade.

Tax Implications of Rolling Options

Rolling options has tax consequences that vary by jurisdiction. In the U.S.:

  • Closing the original option creates a realized gain or loss for the tax year in which it occurs.
  • The new option is treated as a separate position with its own cost basis and holding period.
  • Wash-sale rules may apply if you close at a loss and open a substantially identical position within 30 days. Consult a tax advisor for your specific situation.
  • Holding periods matter: options held less than one year generate short-term capital gains (taxed at ordinary income rates); over one year qualifies for long-term rates.

Keep meticulous records of every roll—entry dates, exit dates, premiums paid, and premiums received. Your brokerage should provide this data, but maintaining your own log (easily done in an Excel spreadsheet with MarketXLS) is a smart backup.

Frequently Asked Questions

What does it mean to roll an option?

Rolling an option means closing your existing options contract and simultaneously opening a new one on the same underlying asset. The new contract typically has a different expiration date, strike price, or both. The goal is to adjust your position—buying more time, locking in gains, or repositioning your strike—without completely exiting the trade.

Is rolling an option the same as closing and reopening?

Mechanically, yes—rolling involves closing one contract and opening another. However, most brokerages let you execute both legs as a single spread order, which ensures simultaneous execution and often provides better pricing than placing two separate orders. For tax purposes, each leg is treated as a distinct transaction.

Does rolling an option cost money?

It depends on the direction and type of roll. Rolling out a long option (buying more time at the same strike) almost always costs a net debit because the later-dated option has more time value. Rolling a short option out typically generates a net credit. Rolling up or down can produce either a debit or credit depending on the moneyness of each contract.

When should I roll an option instead of closing it?

Roll when your original thesis is still intact but needs more time or a strike adjustment to work. Close when your thesis has changed, the cost of rolling exceeds the expected benefit, or you've hit your predefined loss limit. A useful test: would you enter the new position as a fresh trade? If not, don't roll into it.

How many times can you roll an option?

There's no limit to how many times you can roll an option. However, each roll incurs transaction costs and potentially widens your total risk. Many traders set a maximum of two to three rolls per position. If a trade requires more than that, it's usually better to close and reassess.

Can you roll options on any underlying asset?

You can roll options on any asset with a liquid options market—stocks, ETFs, indices, and some futures. The key requirement is sufficient liquidity (tight bid-ask spreads and adequate open interest) in both the contract you're closing and the one you're opening. Thinly traded options make rolling expensive and difficult to execute at fair prices.

Start Analyzing Option Rolls in Excel Today

Rolling options lets you extend a winning position, defend a losing one, or manage assignment risk, as long as the new position is one you would enter as a fresh trade. This article is educational and not investment advice.

With MarketXLS, you can analyze a roll directly in Excel: pull option chains with =QM_GetOptionChain("AAPL"), build option symbols with =OptionSymbol(...), compare premiums with =QM_Last(...), and track your underlying with =Last("AAPL").

Get started with MarketXLS today →

About the authors
Ankur

About Ankur

CEO & Founder, MarketXLS

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

Written collaboratively by Ankur, Anagh 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