Options Trading Journal Plantilla Essentials
Log options trades with contract details, premiums, and outcomes. Track strategy performance across puts, calls, and multi-leg positions.
Qué incluye
- 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
- Registra hasta 150 operaciones de opciones con ticker, estrategia, dirección, fecha de vencimiento, strike, prima, contratos, fechas de apertura y cierre, y P&L
- Panel con 6 tarjetas de KPI: P&L total, tasa de acierto, ganancia promedio, pérdida promedio, prima cobrada y cantidad de posiciones abiertas
- Análisis por Estrategia que muestra tasa de acierto, P&L promedio, P&L total y cantidad de operaciones por estrategia de opciones (Covered Call, CSP, Iron Condor, etc.)
- Hoja de P&L Mensual que muestra prima cobrada, prima pagada, P&L realizado y tasa de acierto por mes
- Seguimiento de Greeks para posiciones abiertas con entradas de Delta, Theta, Vega y Gamma y un resumen de Greeks a nivel de portafolio
Vista previa
Mira qué contiene esta plantilla
Cómo usar esta plantilla de 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.
Creadas por Claude AI. Perfeccionadas por nosotros.
Usamos Claude AI para crear el borrador de cada plantilla, después de una investigación profunda. Luego nuestro equipo interviene. Refinamos el diseño, probamos cada fórmula a fondo, corregimos casos especiales y pulimos el diseño hasta que se siente como algo que realmente usaríamos nosotros mismos. La IA nos lleva al 80%. El último 20% es criterio humano.
Preguntas frecuentes
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.
¿Cómo abro esto en Google Sheets?
Sube el archivo .xlsx a Google Drive y luego ábrelo con Google Sheets. Todas las fórmulas y el formato se conservarán.
Más plantillas Essentials de Investing & Trading
¿Buscas plantillas premium?
Nuestras plantillas de pago incluyen paneles avanzados con múltiples hojas, gráficos nativos de Excel y actualizaciones continuas.