Generate potential profit sheets and ROI models for your options trading.
Listing updated:April 3, 2026
Works with:
1K+
Overview
Stop guessing your exit. Visualize your potential ROI at every price point.
OptionsWhatIf™ is a professional-grade generator for investors who want to visualize their potential gains instantly. Instead of wrestling with complex manual formulas, our add-on programmatically builds a complete "What-If" matrix directly in your Google Sheets™—calculating outcomes so you don't have to.

How it works:
Open the sidebar and enter any stock symbol (e.g., TSLA, NVDA).

Choose your Option Type (Put or Call) and enter your target Strike Prices.

Click "Generate Options Sheet" to build your custom model.

Use the "Update Prices" button to refresh your ROI calculations with live market premiums.

The Result:
A brand-new, organized spreadsheet tab featuring a comprehensive profit matrix. See exactly how much your position stands to gain or lose across a wide range of stock prices—no manual data entry required.

Why use OptionsWhatIf™ for your investing?
Live Price Sync: Keep your ROI models accurate with a single click.

Compare Outcomes: Side-by-side comparison of different strike prices to see which offers the highest potential.

Zero Formulas: No need to learn spreadsheet syntax; the add-on builds and updates the entire model for you.

Don't just trade. Analyze your ROI. Install OptionsWhatIf™ and generate your first potential profit sheet today.

Google Sheets™ is a trademark of Google LLC.
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
OptionsWhatIf will ask for the permissions shown below. Learn more
OptionsWhatIf will need access to your Google account
This will allow OptionsWhatIf to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
P T.
August 17, 2021
How do I get a specific option last price for a strike price at a specific expiry date rather than a data dump of all strike prices fo ra specific expiry date.. I'll change my rating following the answer.
Is this review helpful?
Yes
No
Profile Picture
L Cheung
December 10, 2022
Doesn't Work.
Is this review helpful?
Yes
No
Profile Picture
Henrik Rasmussen
November 24, 2020
Tried to send Feedback, but got error. Would be nice to get more strike proces in add-on. Far enough away to get those likely used in Iron Condors, just over 1 standard deviation.
Is this review helpful?
Yes
No
Profile Picture
Scott Postma
September 21, 2020
Very nice and easy to use program. Wish there was an automatic update feature (like every 5 minutes or so)
Is this review helpful?
Yes
No
Profile Picture
Timothy Etim
November 25, 2020
I hope it works fine.
Is this review helpful?
Yes
No
Profile Picture
Mike Godfrey
November 26, 2020
I am not finding that the pricing data is accurate when i cross reference to TDA, RobinHood, Schwab, etc.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 3, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
1-7 of 7
Search
Clear search
Close search
Google apps
Main menu