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.
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also 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

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

Lloyd L.

Professional Trader

I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying and pasting data from websites.

Samir Khan

InvestExcel.net

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year.

Kirubakaran K.

Investment Professional

I Love My MarketXLS. The market speaks to you when you know how to listen. With MarketXLS, the market truly does speak. Patterns emerge. Pricing behavior becomes clearer.

Don Zelezny

Entrepreneur & Options Trader