Our data - Your workflow.
Users can use Option Samurai to import live data and calculations directly from our app to their worksheets. This enables you to create custom workflows, advanced models, reports, unique calculations, watchlists, trade-logs, scans, and more. The possibilities are endless, and the use-cases are flexible enough to fit your workflow.
In addition, the sheets will constantly update and have the most recent data every time you refresh, so you can create them once and use them forever.
One of the killer applications for this plugin is importing options data and integrating it with stock data and your workflow to have custom tools for your options trading.
The plug-in creates several new functions that allow you to call specific data points directly into cells. The functions are built modularly, so you can refer to other cells and change the stocks or data points imported on the fly.
- OPTIONSAMURAI.STOCK - Imports stock data. The first argument is the ticker; then, you can add as many data points as you want.
- OPTIONSAMURAI.OPTION - Imports options data. The first four arguments are used to call the specific option (ticker, call/put, expiration, strike); then, you can add as many data points as you want.
- OPTIONSAMURAI.HEADER - Imports the data points' names. No need to call a specific ticker.
In Google Sheets the names of the formulas are a bit different (without the 'OptionSamurai' in the beginning). But they work the same.
In the option function, The first four fields are used to point to the option:
- Call or Put
- Expiration (in the format YYYY-MM-DD)
The following fields are the data you want to import.
Unique options integration
This exciting feature allows you to build custom tools to help with your trading style every day.
How to use the floating formula?
The easiest way to use the formula initially is by using the formula builder on the right pane. Below we describe the parameters you can use.
Parameters to control:
- Expiration date:
- Specific - Enter a specific date
- Days to expiration: Always greater than a number. Write as ">30" for more than 30 DTE (closest to)
- Specific - Enter a specific value. (read more below)
- Moneyness - Distance of the strike from the current stock price. Write as "5%." for 5% above current price and "-5%" for 5% below.
- N-th - Counts the strikes in the chain and chooses the N strike from the closest ATM. For example, write "3N" for the 3rd strike ABOVE ATM. Write "-4N" for the 4th strike BELOW the ATM strike.
- ITM - Short for In The Money - Similar to N-th - Counts the strikes ITM and returns the N number. For example, write "2ITM" for the 2nd ITM strike (below for Calls and above for puts).
- OTM - Short for Out The Money - Similar to ITM - Counts the strikes OTM and returns the N number. For example, write "4OTM" for the 4th OTM strike (above for Calls and below for puts).
=OPTIONSAMURAI.OPTION("AAPL", "CALL", ">20", "-5%", "name", "stock_last", "strike")
The above formula will return the call for ticker AAPL (Apple Inc.) with the expiration closest and above 20 days. The strike will be 5% below the current stock price (Moneyness filter), and the formula will return the name of the stock, the stock's last price, and the strike for the option.
=OPTIONSAMURAI.OPTION("AA", "CALL", ">30", "0OTM", "name", "stock_last", "strike", "mid")
The above formula will return the call option for AA (Alcoa Corporation) with the expiration date of closest and above 30 days. The strike will be the closest out-the-money (above in our case, as it's a call). The formula will return the stock name, last price, and the option's strike and mid-price.
=option("FB", "CALL", ">30", "25d", "name", "stock_last", "strike", "mid", "moneyness")
The above formula will return the Call option for Meta Platforms (FB) with an expiration date greater than 30 days. The strike will be with the closest to 25 deltas. The formula will return the stock's name and last price and the option's strike and mid-price.
Installing the plug-in
The installation instructions are a bit different, depending on the version you work with. You can read detailed installation instructions for each version in this article.
The Process Overview:
- You will need to install the plugin (from the store or download it from our site).
- Find your API key from the 'settings' tab. You will see installation instructions there as well.
- Login to Excel or Google Sheets (office.com, for example).
- Activate the plug-in.
- Once the plug-in is activated, sign in:
- Click on the Samurai icon on the Home tab.
- Click on the login link
- Copy the Access Token code from the setting tab in OptionSamurai.com
For detailed instructions. Check here.
What data is available?
Good covered calls trades on Dividend Aristocrats: We've created an Excel template example to help you get started and see some of the benefits you can achieve. Read this blog post about the Excel integration for more information and the template.
The possibilities for this integration are endless. You can create any custom workflow you think of and save time and gain a sharper edge in the market.
We will be adding examples in the future. But some of the use-cases are:
- Custom watchlists with options data
- Calculators for custom strategies
- Enrich your trade log and open positions to see aggregated statistics (greeks, beta weight, etc.)
- An automatic valuation model for stocks
- Automatically compare several strategies and stock holding in different scenarios.
- Create unique calculations for options.
- And much more.
Installation instructions in Knowledgebase.
Troubleshooting the Excel/Google sheets plugin
A blog post about the Excel integration (blog).
Use case Example: Dividend Aristocrats Excel Template - Usecase
Getting started importing stocks and options data into Google Sheets and Excel Blog post.
Go to the Settings page (App)
Go to the main page of Option Samurai (pricing, overview, etc.)