Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
OptionsOptions strategies

Covered Calls- Managing And Tracking

Written by Robin Bisarya
Fri Dec 11 2020
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

A brief about covered calls

A covered call is a financial transaction in which an investor sells call options on his assets and earns an option premium. This is mainly done by investors who hold shares for a long period but are skeptical about the price movement in the short run. Instead of depending only on the rise in the value of shares, investors make use of it by selling call options on their underlying assets. It’s like renting out an asset. A trader who doesn’t own stocks can also leverage this strategy. He can buy stocks at a current price and write off options on the stocks. One can also sell options without having them just like shorting stocks. This is called writing. However, there are certain things that need to be looked into while using this strategy. The approach will also vary with the goals of a trader.

Before getting into a trade

Stock types: This strategy works best with stable stocks. As long as the beta is 1 or less than 1 you are good to go. Because one doesn’t know, a stock may plummet to 0.
Volatility: A stock can be stable but the volatility in the market can drive the best of stocks crazy.
Trader’s attitude: Knowing what one wants from a trade is equally important. An investor might hold a stock very dear and only looking to earn from a premium. But a trader might want to gain from both intrinsic and extrinsic values.

These are some of the factors a trader can look for before jumping in with this strategy. However, after the trades are executed the adjusting of options varies with the attitude of a trader. An investor should only get into a trade if he anticipates it to go down so that he gets to keep his shares.

After getting into a trade

There can be different scenarios based on the stock movement and the attitude of a trader. Let’s say there are an investor and a short term trader looking to write call options at a specific strike price. Below is a table depicting how things are going to pan out in various conditions:



Rollover is basically keeping the options running by adjusting the strike prices and the expiry date. A trader who has sold call options might want to buy back if he thinks the stock is going to move up more. Or an investor might want to buy back with a hope to retain his shares.

For example, an investor sold call options at a strike of $50 for a premium of $1.50 with an expiry of 30 days. After the price reached near $50, say $48 or $49, the investor can buy back options at a lower price say $.50 with a higher strike of say $55. His net premium would be $1 and if the stock further moves, he can buy his shares back at $55.

Professional traders often maintain a journal to track their trades. However, it is very tiresome to carry out rollovers and track them in real-time. But, there is good news. It can be done easily with marketXLS. Apart from all the 600 financial functions to retrieve real-time data on stocks and the ability to analyze financial statements, the marketXLS package also comes with templates to track options trades on a real-time basis. Below is a marketXLS template to spot a potential rollover target. The idea is to look for a target on various expiry dates with the same strike price.

With the help of this marketXLS template, one can easily spot potential rollovers and their corresponding profits/losses as is shown in the last and second last columns.

Tracking Profits/losses

Now that you know the potential dates to gain profits, the next step would be to place your trades. But it is necessary to track them as well so that it gives an idea about when to exit a trade. Because sometimes the profits can turn into losses. This is when marketXLS tracking templates come in handy. You exactly know when to book profits and exit your trades. Below is an image for reference:

In this example, one contract of MSFT(Microsoft) is sold at $215 assuming that you already own the shares. When it nears the strike you buy back a call at $220 as you don’t want to let go of your shares. The total profits you are going to make is given in the bottom right corner. This particular template is for covered calls strategy, but you can design your own templates for different strategies by changing the stock, expiry, strike, direction, and position as needed. The marketXLS templates are very similar to the live option chains like yahoo finance as it contains all the necessary data required for a trade. They are also very flexible and can be modified according to users’ needs.


None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.

The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.

The article is written for helping users collect the required information from various sources deemed to be an authority in their content. The images, copyrights, and trademarks if any are the property of their owners, and no further representations are made.


Images from marketXLS.com

For more about rollover, read here.

For more about covered calls, read here.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
Academy Sports and Outdoors Inc logo

Academy Sports and Outdoors Inc

Optionable: Yes
Market Cap: 3,614 M
Industry: Beer, Wine, and Liquor Stores
52 week range    
Texas Roadhouse Inc. logo

Texas Roadhouse Inc.

Optionable: Yes
Market Cap: 5,743 M
Industry: Restaurants
52 week range    
Destination XL Group Inc. logo

Destination XL Group Inc.

Optionable: No
Market Cap: 340 M
Industry: Apparel Stores
52 week range    
Annaly Capital Management Inc logo

Annaly Capital Management Inc

Optionable: Yes
Market Cap: 8,363 M
Industry: REIT - Diversified
52 week range    
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

Optionable: Yes
Market Cap: 10,268 M
Industry: Specialty Retail
52 week range    
Waste Connections Inc. logo

Waste Connections Inc.

Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
STORE Capital Corporation logo

STORE Capital Corporation

Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range    
Sprouts Farmers Market Inc. logo

Sprouts Farmers Market Inc.

Optionable: Yes
Market Cap: 2,909 M
Industry: Grocery Stores
52 week range    
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Optionable: Yes
Market Cap: 7,483 M
Industry: Auto & Truck Dealerships
52 week range    

More Features