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
Need more from this template?
The free version covers the basics. The Pro version goes further.
- Log up to 40 options trades with strategy, premium, and P&L
- Dashboard with total P&L and win rate
- Basic strategy breakdown by trade type
- Works in Excel and Google Sheets
- Log up to 150 options trades with ticker, strategy, direction, expiration date, strike, premium, contracts, open and close dates, and P&L
- Dashboard with 6 KPI cards: total P&L, win rate, average win, average loss, premium collected, and open positions count
- Strategy Analysis showing win rate, average P&L, total P&L, and trade count per options strategy (Covered Call, CSP, Iron Condor, etc.)
- Monthly P&L sheet showing premium collected, premium paid, realized P&L, and win rate by month
- Greeks Tracker for open positions with Delta, Theta, Vega, and Gamma inputs and a portfolio-level Greeks summary
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 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.