OptionsWhatIf Google Sheets Add-On

A stock option tool for investors and speculators that shows possible outcomes for the stock options you select..

It can help guide your investment decisions by creating data sheets that show potential stock option profit and ROI at various price points.

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

After installing the add-on in Sheets, select the Sheets menu option Add-ons.OptionsWhatIf.Start.

Enter a stock symbol (US markets) and choose the desired option expiration dates and a new sheet will be inserted showing price data and potential profit and ROI at six different price points- price changes of 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. Profit is based on intrinsic value.