Options Trading Journal Modelo Essentials
Log options trades with contract details, premiums, and outcomes. Track strategy performance across puts, calls, and multi-leg positions.
O Que Está Incluído
- 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
- Registre até 150 operações de opções com ticker, estratégia, direção, data de vencimento, strike, prêmio, contratos, datas de abertura e fechamento, e P&L
- Painel com 6 cartões de KPI: P&L total, taxa de acerto, ganho médio, perda média, prêmio coletado e contagem de posições abertas
- Análise por Estratégia mostrando taxa de acerto, P&L médio, P&L total e contagem de operações por estratégia de opções (Covered Call, CSP, Iron Condor, etc.)
- Planilha de P&L Mensal mostrando prêmio coletado, prêmio pago, P&L realizado e taxa de acerto por mês
- Acompanhamento de Greeks para posições abertas com entradas de Delta, Theta, Vega e Gamma e um resumo de Greeks no nível do portfólio
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha 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.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
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.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Investing & Trading
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.