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.
Fri 30 Oct, 23:17
Show me my result over time and where the drawdown was
Over 59 trading days the journal is at +7,746, and 38 of those days ended up.
The deepest drop from a high was −2,126, on 2026-10-10.
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 59 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-07 00:00:00 | 359.51 | 0.00 | 359.51 |
| 2026-08-11 00:00:00 | 725.44 | 0.00 | 365.94 |
| 2026-08-12 00:00:00 | 288.25 | -437.19 | -437.20 |
| 2026-08-13 00:00:00 | 1202.13 | 0.00 | 913.89 |
| 2026-08-14 00:00:00 | 815.81 | -386.32 | -386.33 |
| 2026-08-15 00:00:00 | 1079.47 | -122.66 | 263.66 |
| 2026-08-16 00:00:00 | 1406.13 | 0.00 | 326.66 |
| 2026-08-17 00:00:00 | 1566.96 | 0.00 | 160.83 |
| 2026-08-18 00:00:00 | 1336.45 | -230.51 | -230.51 |
| 2026-08-19 00:00:00 | 1860.91 | 0.00 | 524.46 |
| 2026-08-21 00:00:00 | 1583.40 | -277.51 | -277.51 |
| 2026-08-24 00:00:00 | 1214.94 | -645.97 | -368.46 |
| 2026-08-25 00:00:00 | 1320.63 | -540.28 | 105.69 |
| 2026-08-26 00:00:00 | 2935.21 | 0.00 | 1614.58 |
| 2026-08-27 00:00:00 | 3435.02 | 0.00 | 499.80 |
| 2026-08-28 00:00:00 | 2921.02 | -514.00 | -513.99 |
| 2026-09-01 00:00:00 | 2672.06 | -762.96 | -248.96 |
| 2026-09-03 00:00:00 | 2246.19 | -1188.83 | -425.87 |
| 2026-09-04 00:00:00 | 2394.82 | -1040.20 | 148.63 |
| 2026-09-05 00:00:00 | 2557.53 | -877.49 | 162.71 |