Free Options Trading Journal Spreadsheet Template
Log options trades with contract details, premiums, and outcomes. Track strategy performance across puts, calls, and multi-leg positions.
What's Included
- Dashboard with options trading summary showing total premium collected, total premium paid, net P&L, and win rate
- Options log with underlying ticker, strike price, expiration date, contract type (put or call), and premium fields
- Premium and P&L tracking per contract with automatic calculations based on opening and closing premium prices
- Strategy type categorization for covered calls, cash-secured puts, spreads, straddles, and other option strategies
- Expiration and assignment tracking with color-coded status fields (open, closed, expired, or assigned)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Preview
See what's inside this template
How to Use This Options Trading Journal Template
Log each options trade
Enter the underlying ticker, strike price, expiration date, contract type (put or call), and premium for each trade.
Record strategy type
Classify the trade - covered call, cash-secured put, vertical spread, or other strategy - for performance analysis.
Update trade status
Mark each position as open, closed, expired, or assigned. Enter closing premium for completed trades.
Review performance
The dashboard shows total premium income, total paid, net P&L, and win rate across all options strategies.
Built by Claude AI. Perfected by us.
We use Claude AI to draft each free template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Frequently Asked Questions
Does it handle multi-leg positions?
Log each leg as a separate entry with the same underlying and expiration. Group them visually or add a position ID to link the legs.
How is premium P&L calculated?
P&L is the difference between opening premium and closing premium (or zero if expired worthless) multiplied by the contract multiplier.
Can I track assignment?
Yes. Mark the status as assigned when an option is exercised. Note the assignment price and any resulting stock position.
Does it separate income from speculation?
Use the strategy type field to categorize income strategies (covered calls, cash-secured puts) separately from directional or speculative trades.
How do I open this in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
What license is this template under?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
More Free Investing & Trading Templates
Looking for premium spreadsheet templates?
Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.