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

Short Call Put- Managing And Tracking

Written by Robin Bisarya
Wed Feb 10 2021
Short Call Put- Managing And Tracking - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Short Call Put- Managing And Tracking - MarketXLS

What is it?

Most beginner options strategies are named by juggling the four words- long, short, call, and put. Understand these four basic terminologies, and half the job is done. Here is what each one of these means-

Long: Long is when you buy an option contract (100 shares).

Short: Short is when you sell an option contract.

Call: Call is when you want to buy a certain amount of shares in the future with the contract’s help.

Put: Put is when you want to sell a certain amount of shares in the future with the contract’s help.

There is someone who wants to write a contract, and then there is someone who wants to buy that contract. Also, the traders may be bullish or bearish on a particular underlying. Combining these four terminologies, we get four strategies- Long-call, long-put, short-call, and short- put.

In a short call, the shareowner writes call contracts on his shares, and the buyer of the contracts gets an opportunity to buy them at a specific price, which is also called the strike price. The shareowner does this for a short term benefit on his share in the form of a premium. One important thing to notice here is that though the writer sells call options, he is bearish on the stock so that the options expire worthlessly, and he gets to keep his shares along with the premium.

Similarly, in the short-put strategy, when a shareowner is bullish on a stock, he will write off-put options to earn short-term profits as premium, and the buyer gets to short-sell that stock at a particular price in the future. There is a separate article for long-put, where it is explained very well.

This is a low volatility strategy because no matter how much the stock moves, the only profit a writer earns is the premium. It is a beginner strategy as it usually involves only one step.

Trading with marketXLS

I will be explaining the short-call with the help of a template from marketXLS. MarketXLS is an add-on to MS Excel, which helps a user procure livestock data and import it directly to excel. Apart from this, it also provides templates to manage and track options trades for different strategies. Here, I have used Microsoft(MSFT) options as an example. This trade is not taken in real, and it is just for explaining. As I am writing this article, the MSFT shares are trading at $242.

Let’s assume that the trend will be bearish in the next couple of days. Therefore, I wrote off a call option at $245, which will expire on 12-Feb-2021. But there is one more leg in which I bought a contract in the same underlying at $250. That’s because I want to place a safety net if at all the share starts trading above $245. Suppose the shares get closer to $245, and there is a high chance that it will surpass the strike, so you place a buy contract at $250, that’s it. This is mainly done to retain the shares. The net investment for the two agreements, as you can see, is $112. See, this is the beauty of marketXLS. You can include as many legs as you like, and you don’t have to play by rules and forge your strategies along the way. Below is a screenshot of how it is done.

Profits, losses, and breakeven

We have sold an out of the money contract (100 shares) of MSFT with a strike price of $245 at a premium of $1.56 and bought another contract with a strike of $250 at a premium of $0.52. Let’s have a look at the possible scenarios:

1. Let’s say the shares trade below the first strike of $245. The contract will be deemed worthless, and you get to keep your shares along with the premium of $96. This is the best-case scenario in this trade.
2. The worst case will be when it surpasses $245 but not $250. But, only if you want your shares back. If you are comfortable letting go of your shares, you are still profitable with all your earned premiums.
3. When the share surpasses the strike of $250, you get to buy back your shares at $250. There will be a net loss in this case. $500-$96= ($404). However, there is no such obligation to buy back the shares.
Therefore, it mostly depends on what a trader wants from a particular trade. Below is a graphical representation of how the trade will look like.

The green line depicts the profits, the blue line when the yields decline, and the red line shows the losses following the share price. The breakeven point is at $246.56.


In a nutshell, short-call or put is a low volatility beginner trading strategy. Owning shares is not always mandatory to carry out this trade. One can always buy shares in a multiple of 100 and write off contracts on them. Though this is a one-step strategy, one can always play around with different strikes and expiry to gain the most out of it. And marketXLS helps a trader manage and track trades in real-time at a low price.


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 to help users collect the required information from various sources deemed an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.


Learn more about options here.

Learn more about short call/put here.


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
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get 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

Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

Optionable: Yes
Market Cap: 2,812 M
Industry: Auto & Truck Dealerships
52 week range    
PulteGroup Inc. logo

PulteGroup Inc.

Optionable: Yes
Market Cap: 11,760 M
Industry: Residential Construction
52 week range    
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

Optionable: Yes
Market Cap: 8,021 M
Industry: Specialty Retail
52 week range    
Moelis & Company Class A logo

Moelis & Company Class A

Optionable: Yes
Market Cap: 2,906 M
Industry: Asset Management
52 week range    
Houlihan Lokey Inc. Class A logo

Houlihan Lokey Inc. Class A

Optionable: Yes
Market Cap: 6,656 M
Industry: Capital Markets
52 week range    
Coca-Cola European Partners plc logo

Coca-Cola European Partners plc

Optionable: Yes
Market Cap: 25,255 M
Industry: Beverages - Soft Drinks
52 week range    
Dun & Bradstreet Corporation (The) logo

Dun & Bradstreet Corporation (The)

Optionable: Yes
Market Cap: 6,031 M
Industry: Business Services
52 week range    
Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

Optionable: Yes
Market Cap: 10,470 M
Industry: Specialty Retail
52 week range    
Columbia Sportswear Company logo

Columbia Sportswear Company

Optionable: Yes
Market Cap: 5,627 M
Industry: Apparel Manufacturing
52 week range    
CNX Coal Resources LP logo

CNX Coal Resources LP

Optionable: Yes
Market Cap: 7,105 M
Industry: All Other Business Support Services
52 week range    

More Features