Delta Hedging in Excel – 3 Examples

What Is Delta Hedging?

In stock markets, delta hedging is used to lower the risk and maximize profit.

Example 1- Calculate Delta Hedging Using Stocks in Excel

The dataset showcases a company’s condition in the Stock Market. It details the company’s option price and the underlying stock between the 1st and 31st of October 2022.

Calculate the delta based on the comparison between the 1st and 31st of October:

Delta is the ratio of the difference between the Option Price and the Underlying Stock .

Delta Hedging is a trading strategy to reduce directional risk.

STEPS:

• Use the following format to show Options and Underlying Stocks.
• For Option 1, the starting and the final values of Option and Underlying Stock were entered.
• Click C8 cell and use the following formula in the formula bar to calculate the Delta:

• Press Enter to see the result.

• Enter information for Option 2.
• Here, the starting and the final values of Option and Underlying Stock.
• Calculate the Delta for Option 2:

• Click C16 cell and enter the following formula:

• Press Enter to see the result.

To calculate the overall Delta for the company:

• Sum the Delta values.
• Select C17 cell and use the following formula:

• Press Enter.

To calculate the number of stocks you need to buy or sell:

• Select C17 and enter the following formula:

• Press Enter to exit the editing mode and see the result.

• For Delta Hedging, you need to sell your stocks if Delta is positive.
• After selling these stocks the resultant Delta will be 0.
• You need to buy the calculated amounts of stocks if Delta is negative.
• Enter the following formula in D19:

Example 2 – Applying Options for Delta Hedging in Excel

If the resultant Delta is 0.6, you have to buy contracts with -0.6. If the resultant Delta is -0.6, you have to buy contracts of +0.6.

STEPS:

• The previous dataset was used.
• In Option 1, information is unchanged.
• In Option 2,  information was slightly changed.

To recalculate the value of Delta for Option 2:

• Enter the following formula in C16:

• Press Enter to see the value.

To calculate the total Delta for your company:

• Enter the following formula in C17:

• Press Enter.

The Delta value is calculated.

To buy a contract with -0.2, so that the resultant Delta is 0:

• Enter the following formula in C19:

• Press Enter to see the result.

Example 3 – Manage and Adjust Delta Hedging

STEPS:

• This is the dataset.
• For Delta Hedging, you need to buy 10 contracts.

• Opinion 1 changes rapidly.
• The Delta value of Option 1 will be 13.
• The Final Value of the Option was supposed to be $120.
• But the Final value of the Option changes to $170.
• As a result, the value of Delta is changed to 0.3.
• The value of Option 2 is unchanged.
• The total Delta value is now 0.37.

Calculate the actions needed:

• Enter the following formula in F16:

• Press Enter.

• If F16 is greater than 0, it indicates that you need to buy.
• You need to sell the contracts for Delta Hedging.
• Enter the following formula in G17 cell:

• Press Enter to see the result.

Download Practice Workbook

Download the workbook.

Related Articles

• How to Calculate Delta in Excel
• How to Calculate Delta Delta CT in Excel
• Delta Neutral Strategy in Excel
• How to Calculate Delta Percentage in Excel
• How to Calculate Delta E Color in Excel
• Calculate Option Greek Delta in Excel
• How to Calculate VaR Using Delta-Normal Method in Excel

<< Go Back to Excel DELTA Function | Excel Functions | Learn Excel