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.
Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’.
Follow the steps below to use our options tracker for Google Sheets.
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.
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.
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.
Cells highlighted in green are automatically updated using formulas already set up in your template.
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.
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.
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.
