OptionsWhatIf

A tool for stock option investors/speculators.

Inform your investment decisions by creating data sheets that show potential stock option profit and ROI at varied price points.

OptionsWhatIf is a Google Sheets add-on and can be obtained here.

Enter a stock symbol (US markets) and choose the desired option expiration dates and a new sheet will be inserted showing potential profit and ROI at six different price points. The new sheet will contain price data for the options and six columns that show profit and ROI if the price changes 10%, 33%,50%, 66%, 90%, and 100%. Price data on a sheet can be updated by selecting the "Update prices" button on the sidebar. The mid point of the bid/ask is used as the option price.