Options Spreadsheet

Options Profit Graph For Price Changes Before Expiration

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.

[…]

Options Spreadsheet

Options Pricing Spreadsheet For Theoretical Values And Greeks

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.

[…]

Options Spreadsheet

Stock Options Trade Position Comparison Spreadsheet

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.

[…]

Options Spreadsheet

Option Position Spreadsheet For Graphing Current Profits

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 Spreadsheet

Stock Option Position Profit Spreadsheet

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 Spreadsheet

Options Price And Greeks Change In A 30 Day Period

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 Spreadsheet

Options Trading Pricing Formula Inputs And Outputs

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.

[…]

Options Pricing

The Option Greeks – Delta Gamma Theta Vega

The option greeks, delta, gamma, theta, and vega, are output from the options pricing formula. These different components provide information that can be used for projecting options price movement and trade selection.

[…]