| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | trade_id | strategy | dte_bucket | expiration | status | entry_date | entry_time | entry_spot_price | entry_otm_pts | anchor_strike | lots | entry_credit_per_share | entry_credit_total | entry_pop | entry_ev_per_share | entry_ev_total | max_gain_total | max_loss_total | best_close_debit | best_close_at | worst_close_debit | worst_close_at | exit_date | exit_time | exit_debit_per_share | exit_spot_price | realized_pnl | pct_of_credit_captured | exit_otm_pts | exit_reason |
2 | 1 | strategy1 | error | 1 | ||||||||||||||||||||||||||
3 | 2 | strategy1 | 1-2 DTE | 2026-07-20 | closed | 2026-07-20 | 13:54:00 | 743.29 | -5.29 | 738 | 1 | 1.83 | 183 | 2026-07-20 | 14:29:24 | 0.49 | 745.15 | 134 | 0.2678 | -2.15 | dte_force_close | |||||||||
4 | 3 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 13:46:13 | 743.29 | -5.29 | 738 | 1 | 1.09 | 109 | 2026-07-20 | 15:01:25 | 0.27 | 745.581 | 82 | 0.2477 | -2.58 | dte_force_close | |||||||||
5 | 4 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-20 | 13:47:34 | 743.29 | -5.29 | 738 | 1 | 0.93 | 93 | 2026-07-20 | 19:39:18 | 0.48 | 742.3 | 45 | 0.5161 | 0.7 | max_reprice_force_close | |||||||||
6 | 5 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 14:00:06 | 748.69 | -4.69 | 744 | 1 | 0.52 | 52 | 2026-07-20 | 14:00:47 | 0.46 | 748.43 | 6 | 0.8846 | 0.57 | dte_force_close | |||||||||
7 | 6 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-20 | 14:01:08 | 748.69 | -4.69 | 744 | 1 | 0.85 | 85 | 2026-07-20 | 14:01:49 | 0.68 | 747.94 | 17 | 0.8 | 1.06 | defensive_reprice_1 | |||||||||
8 | 7 | strategy1 | 1-2 DTE | 2026-07-20 | closed | 2026-07-20 | 15:00:42 | 744.6 | -4.6 | 740 | 1 | 0.12 | 12 | 2026-07-20 | 15:01:25 | 0.21 | 745.6 | -9 | 1.75 | -0.6 | dte_force_close | |||||||||
9 | 8 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 15:00:42 | 744.6 | -4.6 | 740 | 1 | 0.7 | 70 | 2026-07-20 | 15:01:26 | 0.29 | 745.6 | 41 | 0.4143 | -0.6 | dte_force_close | |||||||||
10 | 9 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-20 | 15:01:05 | 744.6 | -4.6 | 740 | 1 | 0.81 | 81 | 2026-07-20 | 15:01:46 | 0.6 | 745.4872 | 21 | 0.7407 | -0.49 | defensive_reprice_1 | |||||||||
11 | 10 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 16:00:23 | 745.98 | -4.98 | 741 | 1 | 0.57 | 57 | 2026-07-20 | 16:03:04 | 0.48 | 745.35 | 9 | 0.8421 | 0.65 | dte_force_close | |||||||||
12 | 11 | strategy1 | 1-2 DTE | 2026-07-22 | error | 745.98 | -4.98 | 741 | 1 | 0.685 | 68.5 | |||||||||||||||||||
13 | 12 | strategy1 | 1-2 DTE | 2026-07-20 | error | 745.28 | -5.28 | 740 | 1 | 0.255 | 25.5 | |||||||||||||||||||
14 | 13 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 17:01:43 | 745.28 | -5.28 | 740 | 1 | 0.7 | 70 | 2026-07-20 | 17:02:24 | 0.27 | 746.07 | 43 | 0.3857 | -1.07 | dte_force_close | |||||||||
15 | 14 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-20 | 17:00:40 | 745.28 | -5.28 | 740 | 1 | 0.84 | 84 | 2026-07-20 | 17:02:04 | 0.87 | 745.89 | -3 | 1.0357 | -0.89 | defensive_reprice_3 | |||||||||
16 | 15 | strategy1 | 1-2 DTE | 2026-07-20 | closed | 2026-07-20 | 18:16:28 | 743.8 | -4.8 | 739 | 1 | 0.49 | 49 | 2026-07-20 | 18:17:29 | 0.5 | 745.04 | -1 | 1.0204 | -1.04 | dte_force_close | |||||||||
17 | 16 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 18:09:44 | 743.8 | -4.8 | 739 | 1 | 0.52 | 52 | 2026-07-20 | 18:38:17 | 0.5 | 744.5699 | 2 | 0.9615 | -0.57 | dte_force_close | |||||||||
18 | 17 | strategy1 | 1-2 DTE | 2026-07-22 | error | 743.8 | -4.8 | 739 | 1 | 0.79 | 79 | |||||||||||||||||||
19 | 18 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-20 | 19:00:25 | 742.55 | -4.55 | 738 | 1 | 0.65 | 65 | 2026-07-20 | 19:05:08 | 0.48 | 742.7 | 17 | 0.7385 | 0.3 | dte_force_close | |||||||||
20 | 19 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-20 | 19:00:25 | 742.55 | -4.55 | 738 | 1 | 0.78 | 78 | 2026-07-20 | 19:01:06 | 0.8 | 742.61 | -2 | 1.0256 | 0.39 | defensive_reprice_1 | |||||||||
21 | 20 | strategy1 | 1-2 DTE | 2026-07-21 | closed | 2026-07-21 | 13:46:14 | 742.09 | -5.09 | 737 | 1 | 0.73 | 73 | 2026-07-21 | 14:04:06 | 0.37 | 744.89 | 36 | 0.5068 | -2.89 | dte_force_close | |||||||||
22 | 21 | strategy1 | 1-2 DTE | 2026-07-22 | error | 2026-07-21 | 13:46:14 | 742.09 | -5.09 | 737 | 1 | 1.35 | 135 | |||||||||||||||||
23 | 22 | strategy1 | 1-2 DTE | 2026-07-23 | error | 2026-07-21 | 14:34:18 | 742.09 | -5.09 | 737 | 1 | 0.85 | 85 | |||||||||||||||||
24 | 23 | strategy1 | 1-2 DTE | 2026-07-21 | error | 744.52 | -4.52 | 740 | 1 | 0.16 | 16 | |||||||||||||||||||
25 | 24 | strategy1 | 1-2 DTE | 2026-07-22 | error | 744.52 | -4.52 | 740 | 1 | 0.61 | 61 | |||||||||||||||||||
26 | 25 | strategy1 | 1-2 DTE | 2026-07-23 | error | 744.52 | -4.52 | 740 | 1 | 0.77 | 77 | |||||||||||||||||||
27 | 26 | strategy1 | 1-2 DTE | 2026-07-22 | error | 746.735 | -4.735 | 742 | 1 | 0.585 | 58.5 | |||||||||||||||||||
28 | 27 | strategy1 | 1-2 DTE | 2026-07-23 | error | 746.735 | -4.735 | 742 | 1 | 0.75 | 75 | |||||||||||||||||||
29 | 28 | strategy1 | 1-2 DTE | 2026-07-22 | closed | 2026-07-21 | 16:03:00 | 747.6275 | -4.6275 | 743 | 1 | 0.54 | 54 | 2026-07-21 | 16:11:27 | 0.49 | 747.89 | 5 | 0.9074 | 0.11 | dte_force_close | |||||||||
30 | 29 | strategy1 | 1-2 DTE | 2026-07-23 | closed | 2026-07-21 | 16:03:00 | 747.6275 | -4.6275 | 743 | 1 | 0.7 | 70 | 2026-07-21 | 16:03:42 | 0.74 | 747.695 | -4 | 1.0571 | 0.3 | defensive_reprice_1 | |||||||||
31 | 30 | strategy1 | 1-2 DTE | 2026-07-22 | error | 748.65 | -4.65 | 744 | 1 | 0.495 | 49.5 | |||||||||||||||||||
32 | 31 | strategy1 | 1-2 DTE | 2026-07-23 | error | 748.65 | -4.65 | 744 | 1 | 0.695 | 69.5 | |||||||||||||||||||
33 | 32 | strategy1 | 1-2 DTE | 2026-07-22 | error | 748.7 | -4.7 | 744 | 1 | 0.45 | 45 | |||||||||||||||||||
34 | 33 | strategy1 | 1-2 DTE | 2026-07-23 | error | 748.7 | -4.7 | 744 | 1 | 0.65 | 65 | |||||||||||||||||||
35 | 34 | strategy1 | 1-2 DTE | 2026-07-22 | error | 748.6 | -4.6 | 744 | 1 | 0.42 | 42 | |||||||||||||||||||
36 | 35 | strategy1 | 1-2 DTE | 2026-07-23 | error | 748.6 | -4.6 | 744 | 1 | 0.68 | 68 | |||||||||||||||||||
37 | 36 | strategy1 | 6+ DTE | 2026-08-07 | error | 747 | 1 | 1.2 | 120 | |||||||||||||||||||||
38 | 37 | strategy1 | 6+ DTE | 2026-08-07 | error | 743 | 1 | 1.55 | 155 | |||||||||||||||||||||
39 | 38 | strategy1 | 6+ DTE | 2026-08-14 | pending_entry | 739 | 1 | 2.015 | 201.5 |