Ask
These conversations were asked of the sample journal in advance. In your own journal, Ask answers anything, with an AI key you save once.
Wed 28 Oct, 14:17
Show me my result over time and where the drawdown was
Over 62 trading days the journal is at +9,292, and 38 of those days ended up.
The deepest drop from a high was −1,484, on 2026-09-20.
The green area is the running total. The red one underneath, on the right-hand scale, is how far it sat below its own highest point at the time: the shorter it is, the steadier the curve. Figures from your journal, not advice.
What it ran · 1 query
1 62 rows
SELECT day, equity, ROUND(equity - MAX(equity) OVER (ORDER BY day), 2) AS drawdown, day_pnl FROM (SELECT CAST(DATE(closed_at) AS DATETIME) AS day, ROUND(SUM(net_pnl), 2) AS day_pnl, ROUND(SUM(SUM(net_pnl)) OVER (ORDER BY DATE(closed_at)), 2) AS equity FROM journal_trades WHERE status = 'closed' AND closed_at IS NOT NULL GROUP BY DATE(closed_at)) d ORDER BY day
| day | equity | drawdown | day_pnl |
|---|---|---|---|
| 2026-08-05 00:00:00 | 324.30 | 0.00 | 324.30 |
| 2026-08-06 00:00:00 | 136.46 | -187.84 | -187.85 |
| 2026-08-07 00:00:00 | 79.24 | -245.06 | -57.22 |
| 2026-08-10 00:00:00 | -169.36 | -493.66 | -248.59 |
| 2026-08-12 00:00:00 | -185.39 | -509.69 | -16.03 |
| 2026-08-14 00:00:00 | 5.13 | -319.17 | 190.52 |
| 2026-08-15 00:00:00 | -239.19 | -563.49 | -244.32 |
| 2026-08-17 00:00:00 | 113.16 | -211.14 | 352.35 |
| 2026-08-19 00:00:00 | 320.48 | -3.82 | 207.33 |
| 2026-08-20 00:00:00 | 326.03 | 0.00 | 5.54 |
| 2026-08-21 00:00:00 | 414.73 | 0.00 | 88.70 |
| 2026-08-22 00:00:00 | 597.80 | 0.00 | 183.08 |
| 2026-08-25 00:00:00 | 467.40 | -130.40 | -130.40 |
| 2026-08-26 00:00:00 | 658.88 | 0.00 | 191.47 |
| 2026-08-27 00:00:00 | 755.34 | 0.00 | 96.47 |
| 2026-08-29 00:00:00 | 18.39 | -736.95 | -736.95 |
| 2026-08-30 00:00:00 | -183.89 | -939.23 | -202.28 |
| 2026-08-31 00:00:00 | -40.03 | -795.37 | 143.86 |
| 2026-09-01 00:00:00 | 766.42 | 0.00 | 806.45 |
| 2026-09-02 00:00:00 | 456.60 | -309.82 | -309.82 |