Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Options Rollover Strategy Example Template

This is a comprehensive Rollover Option Strategy Template specifically designed for trading in stock options. The stocks are based on any underlying equity, annotated in this example as 'AAPL', trading at a given price (e.g., 176.65). The template strategically highlights the current short position of an options trader and clearly delineates parameters such as the Option Symbol, Underlying Stock, Dates till Expiry (DTE), Option Type, Strike Price, Expiry Date, Bid/Ask price, Delta (∆), Theta (Θ), Dollar Change (∆$), Total proceeds from the option trade ($Proceeds), and Daily Dollar Change ($/Day).

For instance, the current position row shows a 5-day till expiry Put Option for AAPL with a strike price of 175, expiring on 10th November, with a -0.36 delta indicating it moves in the opposite direction to the underlying stock. Total proceeds from this option amount to 134 dollars, with a daily rate of 25 dollars.

The template also excellently outlines potential rollover options for subsequent Fridays, targeting a roll over to a strike price of 280. It provides a list of Rollover Candidates for AAPL with different expirations dates and calculates their potential proceeds and daily rates accordingly, aiding traders in selecting an optimal rollover strategy. Each candidate is gauged using the same parameters as the current positions, allowing for a straightforward comparison.

This template serves as a valuable decision-support tool, enabling traders to systematically identify and execute the most beneficial rollover strategies. It offers a tactical approach to expand and sustain trading success within the realm of stock options.

Options Rollover Strategy Example Template - MarketXLS

Created by: Ankur

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University