Options Trading Excel Model (With Fundamentals)
Originally published: 26/11/2018 10:37
Last version published: 02/01/2022 19:03
Publication number: ELQ-21702-9
View all versions & Certificate

Options Trading Excel Model (With Fundamentals)

Options Strategy Excel Model With Greeks

This is a 15 tab VBA enabled excel model comprised of 10 Derivatives strategy commonly used by the option trader. These strategies are:

1) Covered Calls
2) Protective Puts
3) Bullish Spread
4) Bearish Spreads
5) Butterfly Spreads
6) Box Spreads
7) Straddle
8) Strangle
9) Collar
10)Strips Straps

How to use the model:

On the "Intro" tab, use the GO arrow. It will take you the "Input" page where you have to put the INPUTS in the blue cells. There will be 4 inputs which you need to fill:
1) Market View
2) Risk Appetite
3) Player
4) Extremes
5) Ticker Name (Security Symbol)
6) Current Market Price of Security
To access option chain data of current month just click get data after entered the security symbol. It is automated for INDIA.

After inputting all this data, there will be an automatic presentation of all the strategies that seems to match your criteria. Then, after taking note of these strategies just click the "START" button. It will re-direct you to the "home page" where you have to select the strategy (which you have recollect from second tab i,e. Input Sheet.)

Then, on every strategy page there are inputs which are shown in blue. You just have to input the values in them and it will help you better understand money management.

Special feature which i have added in this VBA enabled Work-book it is automated for NIFTY India.However it can be used for other countries also only one thing is changed that is it will not automatic download option chain data.

I have also added the valuation sheet where i have used Binomial Tree and Black Schole Model for Option valuation. Which will help you to decide wether option is under or over valued.

And at the last I Have made a option strategy sheet where you can try and formulate your own strategy except the above mentioned and calculate your pay off accordingly.

This Best Practice includes
1 Excel Options Model

Acquire business license for $49.00

Add to cart

Add to bookmarks


Further information

Options trading

Risk Management


5.0 / 5 (2 votes)

please wait...