Nifty option chain with greek excel sheet download

Nifty option chain with greek excel sheet download

Stock futures August 24, 2021

Nifty option chain with Options Greek 




Get live data of option chain in excel for life time analyze the data modify the data for own use.

Buy now the excel sheet from this link 

download link for excel sheet

 System Requirement : Excel 2016 & above
 Sheet: Follow this steps to set up
1) download the file
2) go to windows explorer & select the file, right click on it, and go to its properties
3) Now tick the unblock & then apply, OK
4) Excel requires 2016 & above
5) Open excel & check on menu "developer" option is there or Not ?
6) if developer option is not there, you can add from File-options-customized ribbon - tick on developers option
7) Go to File - Options - Trust Center - Trust Center Settings - 
8) select active x - & click on ENABLE ALL
9) Select Macro setting - Enable All
10) Protected View - 3 Enable all
11) External Content - all 5 option enable all
12) done, now restart the excel & open the file
13) This process is one time only, now your sheets runs live in market with click on refresh button



This blog will explain different types of options for Greeks and share an excel sheet of a nifty option chain with Greeks value. Option Greeks help us to understand how option price will change as environmental factors change like the stock price - time - the implied volatility.













Different types of option Greeks.


Delta.

  1. Delta is one of the four option greeks and option greeks help us understand how our option positions are expected to perform relative to change in the environment. 
  2. Option greeks delta is the directional risk management of an option and all that means is that delta tells us how much option price is expected to change relative to change in stock price.
  3. Specifically, option delta tells us the expected price change of that option relative to a 1 points movement in the stock price.
  4. Delta for a call option is +ve and delta for a put option is -ve
  5. The maximum value of call delta is 1
  6. The minimum value of call delta is 0.0
  7. The maximum value of put delta is -1
  8. The minimum value of put delta -0.0
  9. So how do these values affect the selection of option strike?
  10. let select two delta options 1st delta value Is 0.75 and 2nd delta value is 0.5
  11. If stock price increase by 10. 1st delta value Is 0.75  option price will increase by 7.5
  12. If stock price increase by 10. 2nd delta value Is 0.5  option price will increase by 5
  13. So selection of delta is important to factor and we will upload these values every day in an excel sheet.
  14. Chose the strike price with a delta of 1 so that you can gain maximum when a stock moves in your direction

Gamma

  1. Option gamma tells us the expected change of an options delta when the stock price changes.
  2. Option gamma is linked with the option delta.
  3. If option delta is 0.5 and option gamma is 0.05. when a stock moves 1 point new delta will be 0.55.
  4. Gamma plays important role in deciding the type of risk and fluctuation in option prices.
  5. If you are an option seller you don't want the fluctuation trades.
  6. Gamma value is the highest in at the money option.


  1. Gamma value is highest at the money strike as shown in the picture.
  2. Strike with 210 has the highest gamma value.
  3. The option value of strike price 210 will fluctuate more as compared to 200.
  4. Gamma is also linked with days to expiration
  5. Stock option with more days to expiration has low gamma value as compared to stock with less day of expiration.
  6. Let say Gamma of 210 strikes with 14 days to expiration has 0.07 gamma value 
  7. If the stock price moves 1 point delta will change by 0.07 
  8. If the delta was 0.8 and  the stock move 1 point new delta will be 0.87 
  9. If delta increased it will also increase the total profit
  10. If stock move 10 points and quantity is 1000 profit will be 8700

  1. Let say Gamma of 210 strikes with 197 days to expiration has a 0.02 gamma value 
  2. If the stock price moves 1 point delta will change by 0.02
  3. If the delta was 0.8 and  the stock move 1 point new delta will be 0.82
  4. If delta increased it will also increase the total profit
  5. If stock move 10 points and quantity is 1000 profit will be 8200
Gamma has two variable 
  1. Strike price - Near strike price has a high gamma value
  2. Days to expiration - Near expirations have a high gamma value and vice versa.


Option Theta

  1. Theta is the option Greeks that help us understand and estimate how much our option price will decay or lose value as time passes.
  2. Option price consist of two-part - Intrinsic value - extrinsic value.
  3.  extrinsic value is time value.
  4. Extrinsic value decay with time.
  5. Option theta helps us to understand how much value option value decreases each day if all factors remain the same.
  6. Theta of in the money and at the money options will increase near the expiration. 
  7. Theta of out of the money will decrease near the expiration.
  8. Option with more time with expiration will have less theta 
  9. If you are option buyers look for less theta option
  10. If you are an option seller look for high theta value.
Tags

Post a Comment

1 Comments

Thank you for your valuable comment