We have released a new Excel Tool ‘Option Chain’.
You can download this from here https://howutrade.in/tradingtools/
This is a relatime option chain, and supports all Option Greeks and Implied Volatility. Its design is based on the nseindia.com option chain.
Option Traders can manipulate any kind of option data with simple Excel formulas and can fire orders directly from the excel cell itself.
Syntax:
ImpliedCallVolatility(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Premium, DividendYield)
ImpliedPutVolatility(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Premium, DividendYield)
CallOption(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
PutOption(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
CallDelta(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
PutDelta(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
CallTheta(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
PutTheta(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
CallRho(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
PutRho(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
OptionGamma(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)
OptionVega(UnderlyingPrice, ExercisePrice, DaysToExpiry, Interest, Volatility, DividendYield)