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.
Mon 12 Oct, 17:17
Show me my result over time and where the drawdown was
Over 66 trading days the journal is at +4,376, and 35 of those days ended up.
The deepest drop from a high was −2,580, on 2026-09-07.
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 66 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-07-20 00:00:00 | 323.50 | 0.00 | 323.50 |
| 2026-07-21 00:00:00 | 541.09 | 0.00 | 217.59 |
| 2026-07-23 00:00:00 | 821.93 | 0.00 | 280.84 |
| 2026-07-25 00:00:00 | 833.47 | 0.00 | 11.54 |
| 2026-07-26 00:00:00 | 1370.88 | 0.00 | 537.41 |
| 2026-07-27 00:00:00 | 1213.66 | -157.22 | -157.23 |
| 2026-07-28 00:00:00 | 857.78 | -513.10 | -355.88 |
| 2026-07-29 00:00:00 | 719.81 | -651.07 | -137.97 |
| 2026-07-30 00:00:00 | 518.10 | -852.78 | -201.71 |
| 2026-07-31 00:00:00 | 276.04 | -1094.84 | -242.06 |
| 2026-08-02 00:00:00 | -57.88 | -1428.76 | -333.93 |
| 2026-08-03 00:00:00 | -303.06 | -1673.94 | -245.18 |
| 2026-08-04 00:00:00 | 16.18 | -1354.70 | 319.24 |
| 2026-08-05 00:00:00 | 252.08 | -1118.80 | 235.90 |
| 2026-08-06 00:00:00 | -110.03 | -1480.91 | -362.11 |
| 2026-08-07 00:00:00 | 17.98 | -1352.90 | 128.02 |
| 2026-08-08 00:00:00 | 222.73 | -1148.15 | 204.75 |
| 2026-08-10 00:00:00 | 313.88 | -1057.00 | 91.15 |
| 2026-08-11 00:00:00 | 9.34 | -1361.54 | -304.55 |
| 2026-08-12 00:00:00 | 252.82 | -1118.06 | 243.48 |