In this article:

Free Options Tracker for Google Sheets (2024 Update)‍

May 8, 2024

Google Sheets Options Tracker 

An options tracker for Google Sheets is useful for efficiently managing and analyzing options portfolios, enhancing strategic decision-making and investment returns.

Access our free options tracker for Google Sheets here.

google sheets options tracker

Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’.

options tracker google sheets

How to Use the Options Tracker for Google Sheets

Follow the steps below to use our options tracker for Google Sheets. 

1. Open Your Google Sheets Template

Start by opening your Google Sheets options trading template. This document includes a "Trade Log" sheet for documenting individual trades and a "Portfolio Summary" for an overview of your portfolio's performance.

2. Edit Yellow Cells in Trade Log

In the "Trade Log" sheet, you'll find cells highlighted in yellow.

In the "Stock Symbol" column, enter the ticker symbol for the stock underlying your option contract. Use symbols recognized by Google Finance to enable real-time price updates.

Fill in the "Open Date" when you initiated the trade and the "Exp Date" for its expiration. These dates frame the duration of your option contract.

In the "C" (contracts) column, note how many contracts you're dealing with. This number impacts the scale of your trade and potential returns or losses.

3. Input Trades in Trade Log

Document each new trade in the "Trade Log" sheet. This includes adding the "Exp Date" for when the option expires, specifying whether it's a "Call" or "Put," and whether you're buying or selling. In the "B/S" column, mark whether you bought (B) or sold (S) the option. Enter the stock's price at the time of the contract's opening in the "Stock Price DOC" column for return calculations.

4. View Green Cells for Automated Data

Cells highlighted in green are automatically updated using formulas already set up in your template.

5. Check Portfolio Summary Sheet

Switch to the "Portfolio Summary" sheet to see a summarized view of your trading activities. Here you'll find aggregated data such as your total "Open Profit/Loss," "Closed Profit/Loss," and reserves for both cash and margin.

6. Update Trade Status

Back in the "Trade Log," update the status of your trades as "Open," "Closed," or "Exercised" depending on their current situation to keep your records accurate and up-to-date.

7. Review Monthly and Annual Gains

The "Portfolio Summary" sheet also displays your earnings from options trading, broken down by month and year, in the "Monthly Option Income per Year" section.

Finally, consider creating backups to protect your data against loss or corruption.

We hope that you now have a better understanding of how to use our options tracker for Google Sheets. If you enjoyed this article, you might also like our article on our free sports betting tracker for Google Sheets or our article on Google Sheets crypto tracker. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->