This worksheet for our options trading spreadsheet is an addition to the price to expiration profit graphs, where it will also give the profit curvature for the date of the options trade, along with any other date before expiration. 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 puts 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. This worksheet is especially useful for doing whatif modeling for different options position types or entry prices.
OptPos [option position] trading worksheet video showing how it is used for entering option trades and positions to get both a graph showing profit at expiration, as well as current profit at any given date, based on the change in theoretical value of the position.
Options trading spreadsheet video that discusses the StkOpt worksheet that can plot the stock option position profit at expiration, along with also plotting a stock trade only position for comparison.
Options trading spreadsheet video that discusses the GreeksChg worksheet and how theoretical value and the option greeks change over a 30 day period, including the differences that occur from changes in the underlying and/or volatility.
Options trading spreadsheet video that discusses the greeks worksheet inputs and outputs, especially with regards to the volatility input and what number to use. There is further discussion on ways that this worksheet can be used for projections and trading decisions.
Download link for microsoft excel options trading spreadsheet file. […]
Copyright © 2023 Tactical Trading, LLC.