Help

Installing Excel/Google Sheet Plugin

Our data - Your workflow.

The Option Samurai Plugin allows you to import stocks and OPTIONS data quickly and easily into Excel/Google Sheets. This gives you endless possibilities in building custom workflows, saving time, and gaining a sharper edge.

This article describes the installation instructions. If you need an overview - please check this article.

If you are having difficulties installing the plugin. Check our Troubleshooting article.

The versions covered in this article: (Jump to the relevant version)

Excel Web (office 365 subscription).
Excel Desktop - Windows
Google Sheets
Excel Desktop - Mac

Excel Web

Go to the settings page in the app and pick the Excel plugin tab.
Download the file Menifest.zip. Unzip it and keep the XML file.
Log in to Excel web on the office.com website.
Go to File > Get Add-ins > Manage My Add-in
Click on the blue 'Manage My Add-ins' and choose upload my Add-in.
Pick the XML file you've downloaded and click upload.
After a few seconds, you should see the Option Samurai message and icon appear on the Home tab.
Please refresh the browser before using the plugin.
After installation, you can use our formulas by typing them directly or using the provided widget in a guided manner. You can register using the API key in the Settings tab. Please refer to the documentation for more details.

Excel Desktop - Windows

Excel desktop supported versions.

For Excel Desktop, we will create a shared folder and import the most updated version. Then install on Excel.

Click the Windows icon and search for 'run.'
Write cmd and enter.
Copy-paste the following command: net use \\share.optionsamurai.com\excel /user:guest guest You can close the terminal.

4. Open Excel. Go to Options.

5. Add Excel Add-in catalog as shown in the pictures below:

6. To activate the plugin - open a workbook.

7. Go to 'insert' press 'My Add-ins.' Switch to "Shared Folders." You will see the Samurai icon there. If not, press the "refresh button." Select the Option Samurai add-in and press the "Add" button.

8. The plugin will be added to the home ribbon. Click on the formula builder to start.

9. Copy the API key from the settings page in Option Samurai. Read more here.

Google Sheets

The Google Sheet installation is easy and done VIA the Google Workspace Marketplace.

1. Go to the Option Samurai Plugin page on Google Workspace Marketplace: Link.

2. Click the install button.

3. Approve the permissions (will allow importing web data to your sheets).

4. Open Google Sheets

5. In the Extension menu on top, you will see the Option Samurai and the Formula builder.

6. Open it, and copy the API key to it (The Key is in the Settings tab in the Option Samurai app).

7. Done. Read more in our documentation: here.

Excel Desktop on Mac

First, you will need to have a few prerequisites before starting. Make sure you have Excel version 15.19 (160206) or above installed on your Mac. You will also require the manifest .xml file for the add-in you wish to test.

To download the manifest.zip file from your Option Samurai account, follow these steps:

Go to the "Settings" tab.
Click on "Microsoft Office Excel".
Next, navigate to the "Excel on the web" tab.
You will find the link to download the file there.

Now, let's get into sideloading our add-in (here is the official guide on how to do it - or keep reading). The first step is to open Finder on your Mac device. Then, enter Command+Shift+G to open the "Go to folder" dialog. Here, you will need to enter the following filepath:

/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents/wef.

Please take note that in the event the "wef" folder is not present on your computer system, it will be necessary for you to create the folder. Once the folder has been created, copy and paste your add-in's manifest file into this newly established folder.

Once this is done, open Excel or restart it if it was already open. Go to the "Insert" tab and click on the little arrow next to the "My Add-Ins" button. You should now see the Option Samurai icon in the list.

Click on our add-in's icon and you will be welcomed with a message from Option Samurai on the right-hand side of the screen. At the bottom right, you will also see a message stating, "Functionality is limited. Please sign in to unlock." Don't worry; this means you need to provide Excel with your personal access token.

To get your personal access token:

Go to the "Settings" tab on your Option Samurai account.
Scroll down to the bottom of the screen, in the Excel Tab, and you will find your token.
Copy it and click on the "Sign in" link in the warning message mentioned earlier.

Paste your token into the Excel input field and click "Submit." And that's it; you're all set to use our add-in on Excel Desktop for Mac!

One thing to note is that if you experience any issues with Functionality, make sure to check that you have provided the correct access token. If the issue persists, please contact our support team for further assistance.

Excel & Google Sheets Integration knowledge base article.
Check our Excel / Google Sheets troubleshooting article.
A blog post about Excel Integration.
Go to the Settings tab and get the API key (App).

Was this article helpful?

How can we help you?

Excel Web

Excel Desktop - Windows

Google Sheets

Excel Desktop on Mac

Read more: