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

Stock Replacement Options Strategy

Written by Vanshika Kothari
Fri Jun 25 2021
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

It is clear from its name; Stock Replacement Options Strategy is a strategy that effectively recreates the position of owning stocks by using other financial instruments. It has become prevalent using options and has been used by investors and traders for a very long time and in recent years.

It is pretty simple to use a stock replacement options strategy. It offers benefits relating to the leverage provided by derivatives at a lower cost than that incurred from buying actual assets. Stock replacement options strategy aims to participate in the gains of stock with less overall cost.

Understanding the Stock Replacement Options Strategy

Investors or traders usually buy call option contracts deep in the money when they want to use options to earn the equivalent, or better, gains in underlying stocks while tying up less capital. Deep in the money call options are options contracts with an exercise or strike price significantly below the underlying price. They pay for an option contract that has gained or lost in value at a similar rate to the equivalent value of shares.

The reason behind buying deep in the money calls is that they have a delta value of 1, or very close to 1, which means that the price of these calls moves roughly with the price of the underlying security and effectively recreates the position of owning the actual underlying stock.

Understanding Stock Replacement Options Strategy with Example

For the purpose of understanding, let’s assume a trader buys 100 shares of Microsoft Corporation (NASDAQ: MSFT) at $240 per share. If the stock moved up to $264 per share, the total value of the investment rises by $2,400 That’s a 10% gain.

On the contrary, the trader can buy one deep in the money Microsoft Corporation (NASDAQ: MSFT) options contract with a strike price of $240 for $20.9. Since each contract controls 100 shares of stock, the value of the options contract at the start is $2,090.

If the delta of the option is 0.97, when the underlying stock moves up by $14, (the share price reaching to $264) the option moves up by $13.58 to bring the value of the contract to $3448 ($2,090 + ($13.58*100)). That’s a gain of 65% which is a lot more than the return of owning the stock itself.

Managing the Stock Replacement Options Strategy (Using Excel)

MarketXLS provides a convenient template for traders to manage their options strategies. All you need to do is enter the necessary inputs marked in yellow in the Active template sheet, and all the necessary details will be generated automatically.

All you need to do is Mention the Stock ticker in Cell E5 of the Active template sheet, enter the Expiry date of the option. A list of upcoming expiry dates has been provided adjacent to the input. Enter the Deep ITM Strike price you are looking to buy.

Stock Replacement Options Strategy

An entire comparison table is provided for the user to compare the profit from the stock concerning the profit from the options. It also generates a comparison chart and the payoff table concerning its different expiries. This template comes very handily for investors and traders to get complete details of their Stock Replacement Options Strategy and manage them well.

Benefits of Stock Replacement Options Strategy

Source: https://www.businesstoday.in/moneytoday/investment/all-about-options-how-investors-can-use-them/story/202674.html

It shall be clear from the above example that this strategy provides more significant gains by unlocking the potential of leverage. It gives the ability to make significant gains with less investment and avail the full benefit of any appreciation in the security.

There is limited loss as, in option buying, the maximum loss is always to the extent of the premium paid. Investors can also limit their volatility through strategic hedging under various resistance levels.

Conclusion/ Bottom Line

Beginners can also use the stock Replacement Options Strategy. It is a simple alternative to buying shares and reduces the maximum possible loss as well as takes advantage of the power of leverage. However, it comes with downsides because you can lose money if the share price doesn’t move at all and you don’t get the benefit of any paid dividends, but in the right circumstances, it can very much be the best strategy to use.

For more experienced traders, the ability to hedge the position if circumstances change and choose to what extent the position is hedged can be very appealing. However, hedging requires a high level of technical analysis skill to identify areas of resistance and support. If hedging is done in the wrong areas, significant profits can be lost.


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 to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made. All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.

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

STORE Capital Corporation logo

STORE Capital Corporation

Optionable: Yes
Market Cap: 8,978 M
Industry: REIT - Diversified
52 week range    
Dillard's Inc. logo

Dillard's Inc.

Optionable: Yes
Market Cap: 5,077 M
Industry: Department Stores
52 week range    
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

Optionable: Yes
Market Cap: 8,796 M
Industry: Specialty Retail
52 week range    
ICF International Inc. logo

ICF International Inc.

Optionable: Yes
Market Cap: 2,040 M
Industry: Business Services
52 week range    
First Interstate BancSystem Inc. logo

First Interstate BancSystem Inc.

Optionable: Yes
Market Cap: 4,622 M
Industry: Banks - Regional - US
52 week range    
Global Cord Blood Corporation logo

Global Cord Blood Corporation

Optionable: Yes
Market Cap: 317 M
Industry: Biotechnology
52 week range    
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Optionable: Yes
Market Cap: 7,684 M
Industry: Auto & Truck Dealerships
52 week range    
General Mills Inc. logo

General Mills Inc.

Optionable: Yes
Market Cap: 44,923 M
Industry: Packaged Foods
52 week range    
Allegiance Bancshares Inc. logo

Allegiance Bancshares Inc.

Optionable: Yes
Market Cap: 883 M
Industry: Banks - Regional - US
52 week range    
National Research Corporation logo

National Research Corporation

Optionable: No
Market Cap: 948 M
Industry: Diagnostics & Research
52 week range    

More Features