Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Option StrategiesOptions strategiesStocks

How To Profit From Arbitrage Stocks And Options?

Written by Ansh Thakkar (Individual Contributor)
Fri Apr 23 2021
Put Call Parity
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Put Call Parity

What is Arbitrage?

Profit from Arbitrage means purchasing an asset in one market at a lower price and simultaneously selling the same in another market at a high price. The arbitrage profit earned by the trader is equal to the resulting difference between the prices.
The Arbitrage strategy is common in blockchain trading and the foreign exchange market.
It exploits the opportunity of earning profits through variations in prices in different markets. This strategy also exploits the market’s inefficiencies and pricing errors. Arbitrage opportunities are available for a very short period. They last for only a few seconds sometimes.
There are various complicated and straightforward scenarios of arbitrage trading.
Let us see how we can profit from arbitrage stocks and arbitrage options strategies.

Profit from Arbitrage Stocks

Let us understand a simple scenario of arbitrage trading.
Consider that a stock is trading at $12.40 on the New York Stock Exchange. At the exact moment, the same stock is trading at $12.44 on the Bombay Stock Exchange .
An arbitrage trader can earn profits by buying a good quantity of that stock from NYSE and simultaneously sell them at BSE before the price changes. These transactions happen in seconds. Hence, the arbitrage traders should have robust technology and computer software systems installed for facilitating these trades within seconds before the opportunity to earn profits lapses.

Though the arbitrage-trading strategy offers high-profit potential, it also carries an equal amount of risk with it. The risk is that these trades are difficult to track and execute by average day traders. Hence, traders who do not have systems installed that facilitate arbitrage trading should not try their hand at it. They might lose a lot of money if they fail to execute the sell order on time, and the price in both the exchanges falls below the purchase price.
Another risk is that there are possibilities that arbitrage trades are on leverage, which would reduce the money in hand after the execution leverage.

Other risks associated with arbitrage trading are:
• Opportunity risk – With the passage of time, the profits decreases, and the opportunity risk increases due to rising competition
• Liquidity risk – What if you are not able to sell the asset due to low demand
• Cost of transaction – For the entire process, you will need to pay specific transaction fees. The cost of a transaction is an essential factor that might make or break an arbitrage opportunity.
• While selling the same stock at BSE/ any other exchange, you might need to consider foreign exchange rates as well.

Profit from Arbitrage Options

The Options Arbitrage Strategy is
Put-Call Parity
The put-call parity is a relation as per which the investor gets the same payoff from:
1. Buying a put and buying the underlying stock
2. Buying a call and buying a risk-free, zero-coupon bond
This can be given as:
Price of underlying stock + Price of put = Price of call + Present value of exercise price
Cost of the first strategy                             = Cost of the second strategy

This parity tries to imply that the value of a call option at the present value of the strike price is the same as the corresponding put option and vice versa. The transactions of the options arbitrage are executed in the same market.
The conditions for this are:
• Put and call both have the same expiration date and the same exercise price
• The maturity date of the zero-coupon bond must be the same as the expiration date of the options
An arbitrage opportunity occurs if there is a deviation between the value of calls and puts with the same strike price.

Put-Call Parity in MarketXLS

MarketXLS provides a ready-to-use template for working on Put-Call Parity Strategy.
Put and call prices are related through put-call parity, which specifies that the put price plus the price of the underlying equals the call price plus the present value of the strike price. Further, for making profits using arbitrage, the software also helps you to find out whether the arbitrage opportunity exists or not.
Let us have a look at the template:

‘Active Template’ Sheet

Put Call Parity


The template automatically does all the calculations and analysis.
Here, you have to enter the following information:
• Mention Stock ticker in cell ‘C13’.
• Enter the Expiry date of the option in cell ‘C18’. A table of upcoming expiry dates has been provided beside the input.
In the above example, you can see that, according to the template analysis, Arbitrage Opportunity Exists for the option of the stock ‘MSFT.’
This is because put-call parity does not hold, and there is a deviation in the price.
The software also provides the payoff profile of the option by classifying it into two portfolios.


Profit from Arbitrage

Here, you have to enter the maximum and minimum value of the share price for the chart.
The template itself does all the other calculations based on the expiry price.
The resulting two portfolios are shown in a chart format.

The Bottom Line

Arbitrage trading enhances and improves the efficiency of capital markets. As mentioned earlier, arbitrage trading carries risk alongside profits. New traders should be careful while using the strategy of arbitrage trading in stocks as well as options.
Arbitrage trading opportunities are of a very short span.  Algorithm-based trading software tracks them.
For more such interesting articles on various topics and strategies of the stock market, please visit https://marketxls.com/blog/.


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