← Back to Blog

How to Track Options Trades: Complete Beginner Guide

You've started trading options, and now you're wondering: how do I keep track of all this? Your brokerage shows individual trades but not the full picture. This beginner-friendly guide explains how to track options trades from scratch.

Why Track Your Options Trades?

Your brokerage tracks transactions, but it doesn't give you what you really need:

  • True P&L: Premium collected vs capital at risk
  • Return on capital: Not just dollars, but percentages
  • Strategy performance: Are your CSPs doing better than your covered calls?
  • Patterns: What's working and what isn't
  • Tax preparation: Wash sales, cost basis adjustments, etc.

What to Track for Each Trade

Basic Information

Field Example Why It Matters
Date Opened 2026-01-15 Holding period, tax purposes
Ticker AAPL Track performance by stock
Strategy CSP Compare strategy returns
Strike Price $170 Breakeven, assignment price
Expiration 2026-02-21 DTE, planning
Premium $3.50 Income received
Contracts 2 Position size
Account IRA Multi-account tracking

When the Trade Closes

Field Example Why It Matters
Date Closed 2026-02-21 Holding period
Close Price $0.15 (bought back) Final P&L calculation
Outcome Closed Early Win/loss categorization
P&L $670 Bottom line result

Tracking Methods for Beginners

Method 1: Simple Spreadsheet

Best for: Beginners with < 20 trades per month

Setup:

  1. Create a Google Sheet or Excel file
  2. Add columns for all fields above
  3. Add a "P&L" column with formula: =(Premium - Close Price) × Contracts × 100
  4. Add a "Return %" column: =P&L / (Strike × Contracts × 100)

Pros: Free, simple, customizable

Cons: Manual entry, error-prone, no automation

Method 2: Dedicated Tracking App

Best for: Active traders, complex strategies, wheel trading

Options Tracker handles:

  • Automatic P&L calculation
  • Assignment tracking (CSP → Stock → CC)
  • Cost basis adjustment
  • Multi-account support
  • Dashboard analytics

Pros: No formulas, automatic calculations, trade linking

Cons: Monthly cost (though free tier available)

Step-by-Step: Tracking Your First Trade

Let's walk through tracking a real trade:

1. You Sell a CSP

January 15: Sell AAPL $170 CSP expiring Feb 21 for $3.50 premium (1 contract)

Record:

  • Date: 2026-01-15
  • Ticker: AAPL
  • Strategy: CSP
  • Strike: $170
  • Expiration: 2026-02-21
  • Premium: $3.50
  • Contracts: 1
  • Capital at Risk: $17,000
  • Status: Open

2. Track While Open

Each week, you can note the current option price and unrealized P&L. This is optional but helps you decide when to close early.

3. Trade Closes

February 21: Option expires worthless (AAPL at $175)

Update:

  • Date Closed: 2026-02-21
  • Close Price: $0.00
  • Outcome: Expired Worthless
  • P&L: $350 ($3.50 × 100 shares)
  • Return: 2.06% ($350 / $17,000)
  • Days Held: 37
  • Annualized Return: 20.3%

Calculating P&L for Different Outcomes

Option Expires Worthless

P&L = Premium × 100 × Contracts

Buy Back Early

P&L = (Premium Received - Premium Paid to Close) × 100 × Contracts

Assigned on CSP

P&L for the CSP = Premium (this is realized)

New: Stock position with cost basis = Strike - Premium per share

Called Away on Covered Call

P&L = Premium + (Strike - Cost Basis) × 100 × Contracts

Using Free Tools

Before building a complex tracking system, use our free calculators to understand the metrics:

Common Beginner Mistakes

1. Not Tracking Losing Trades

It's tempting to "forget" trades that lost money. Don't. Losses are data points that help you improve.

2. Calculating Returns Wrong

Return = P&L / Capital at Risk, NOT P&L / Premium Collected

$350 profit on a $17,000 position is 2%, not "100% return on premium."

3. Ignoring Fees

Track commissions, assignment fees, and any other costs. They reduce your actual return.

4. Waiting Too Long to Start

Start tracking from your first trade. Going back to reconstruct history is painful.

Building Your Tracking Habit

1. Track Immediately

After every trade executes, take 30 seconds to log it. Don't wait until end of day.

2. Weekly Review

Every weekend, review your open positions and closed trades. What's working?

3. Monthly Analysis

Once a month, look at aggregate performance: total P&L, win rate, average return.

What Good Tracking Looks Like

After 3 months of tracking, you should be able to answer:

  • What's my total P&L this year?
  • What's my win rate (% of profitable trades)?
  • Which strategy (CSP, CC, etc.) performs best for me?
  • Which tickers do I trade most profitably?
  • What's my average return on capital?

If you can't answer these, your tracking needs improvement.

Next Steps

  1. Choose a tracking method (spreadsheet or app)
  2. Set up your basic fields
  3. Log your next trade immediately after execution
  4. Schedule weekly review time

For automatic tracking with no spreadsheet maintenance, try Options Tracker free. Or start with our free calculators to understand the key metrics.

Conclusion

Tracking options trades doesn't have to be complicated. Start simple: date, ticker, strategy, strike, premium, outcome, P&L. Build the habit of logging trades immediately, and you'll have valuable data to improve your trading.

The best time to start tracking was when you made your first trade. The second best time is now.

Frequently Asked Questions

What is the easiest way to track options trades?

For beginners, a simple spreadsheet with columns for date, ticker, strategy, strike, premium, and P&L works well. As you trade more actively, dedicated software like Options Tracker automates calculations and handles complex scenarios like assignments.

How do I calculate options P&L?

For selling options: P&L = (Premium Received - Premium Paid to Close) × 100 × Contracts. If expired worthless, close price is $0. For buying options: P&L = (Sell Price - Buy Price) × 100 × Contracts.

Should I track options trades in a spreadsheet or app?

Spreadsheets work for fewer than 20 trades/month with simple strategies. Apps are better for active traders, wheel strategies, or anyone wanting automatic calculations and analytics.

How often should I review my options trades?

Log trades immediately after execution. Review open positions weekly. Analyze overall performance monthly. This cadence helps you catch problems early and improve consistently.

What metrics matter most for options tracking?

Key metrics: (1) P&L per trade, (2) Return on capital, (3) Win rate, (4) Average win vs average loss, (5) Annualized return. These tell you if your strategy is profitable and sustainable.

Ready to simplify your options tracking?

Start tracking your wheel strategy trades automatically with Options Tracker.

Get Started Free