Basics trading of spreadsheet options


Right click on the file, and save the link to a location on your spreadsheet.After you do your download, I suggest that you save a 2nd file using a different name. That way you will have a master file, in the event that you accidentally delete one of the spreadsheet formulas.I am trying to make all of the input cells a different color than the formula cells.The spreadsheet is a microsoft excel.xlsm file.

If you have an earlier version of excel, then let me know and I will send you a different file to use.Also, this is a macro enable spreadsheet.Since the different worksheets are using macros, you may see a security warning that they have been disabled when you open the spreadsheet. This is very useful, considering that most single options are not held to expiration, especially when they are long option trades. The GreeksChain worksheet for our options trading spreadsheet will give a calls and basics of options trading spreadsheet price chain for theoretical value and greeks, made from our user inputs for underlying price, volatility, and days to expiration.

Additionally, there is a calls and puts profit section for doing whatif scenarios and position adjustments. The stock options position comparison spreadsheet will take 2 different positions and give the risk reward for both overlaid on the same profit graph. Excellent interface. Great support - shoutout to Alex:) Only problem is that the risk exposure (i.e. maximum purchaseable option) is not forthcoming. It was a painful process to set up.




Basics of options trading spreadsheet

Basics of options trading spreadsheet