Options Trading Journal Essentials 模板
Log options trades with contract details, premiums, and outcomes. Track strategy performance across puts, calls, and multi-leg positions.
包含内容
- 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 Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- 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
- 记录最多150笔期权交易，含代码、策略、方向、到期日、行权价、权利金、合约数、开仓和平仓日期及盈亏
- 仪表板包含6个KPI卡片：总盈亏、胜率、平均盈利、平均亏损、收取的权利金和未平仓合约数
- 策略分析显示每种期权策略的胜率、平均盈亏、总盈亏和交易数（备兑看涨、现金担保看跌、铁鹰式等）
- 月度盈亏表显示每月收取的权利金、支付的权利金、已实现盈亏和胜率
- Greeks跟踪器用于未平仓合约，含Delta、Theta、Vega和Gamma输入以及投资组合级别的Greeks汇总
预览
查看此模板的内容
如何使用这个Options Trading Journal模板
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.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
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.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。