Options Trading Tracker (Excel)

A simple yet powerful spreadsheet for tracking long options trades. This is a variant of my sports betting Excel spreadsheet. Helpful for analyzing sources of profit and loss by various segments - as well as getting feedback on strategies.

Flexibility:
- Add customizable trade type tags
- Add customizable strategy tags
- Add new rows for more segmentation

Metrics:
- Win rate
- Average win
- Average loss
- Payoff ratio
- Kelly Criterion
- Sharpe ratio
- Rolling profit and loss (PnL)

Segmentation:
- Day of week
- Month
- Trade type
- Trade type sub-segment
- Ticker
- Option delta
- Customizable model/strategy tag