Analyze the uploaded tradebook using FIFO matching and provide the following metrics only for realized/closed trades.
- Overall Metrics
- Total trades
- Winning trades
- Losing trades
- Win rate %
- Loss rate %
- Net realized P&L
- Charges
- Average profit %
- Average loss %
- Median profit %
- Median loss %
- Maximum profit %
- Maximum loss %
- Minimum profit %
- Minimum loss %
- Distribution Analysis Show percentage distribution of trades at configurable intervals.
A. Loss distribution Show:
- 0 to -2
- -2 to -4
- -4 to -6
- -6 to -8
- <= -8
Include:
- number of trades
- percentage of total losing trades
B. Profit distribution Show:
- 0 to 2
- 2 to 4
- 4 to 6
- ...
- till 20
Include:
- number of trades
- percentage of total winning trades
C. Combined distribution Create non-overlapping intervals from -10 to 20 using 3% buckets: Example:
- -10 to <-7
- -7 to <-4
- -4 to <-1
- ...
- 17 to <20
-
=20
For each bucket show:
- number of trades
- percentage of total closed trades
Ensure all combined percentages sum exactly to 100%.
- Additional Insights
- Best trade
- Worst trade
- Median trade
- Profit factor
- Expectancy
- Largest winning streak
- Largest losing streak
- Optional Filters Allow filtering by:
- month
- stock symbol
- strategy
- intraday vs swing
Important:
- Use FIFO matching
- Ignore open positions unless explicitly requested
- Use realized P&L only
- Cross-check totals and percentages before final output
- Clearly separate winning and losing trade statistics