Rule backtester
Pick a series to trade, a signal and simple entry and exit rules. Everything runs in your browser on official data; the rule is in the URL, so a result can be shared.
Pick a series to trade, a signal and simple entry and exit rules. Everything runs in your browser on official data; the rule is in the URL, so a result can be shared.
When German power is unusually expensive against France (z-score above 2 over 60 days), bet on the spread narrowing; exit when it is back near its mean.
In-sample research, not a trading recommendation.
The rule is tested on the same history it may have been tuned on: judge it on the control period (after 26 Oct 2024), which you should not have used to choose the settings. P&L is the change of the DE-LU − France day-ahead base spread while the rule is in a position, in €/MWh — a spot spread is a measure of the signal, not an instrument you can hold. 53 trades in 6.9 years.
| Period | Trades | Total P&L (€/MWh) | Hit rate | Avg win / loss | Sharpe | Max drawdown | In position | Trades / year |
|---|---|---|---|---|---|---|---|---|
| Tuning period (first 70%) | 30 | +153.79 | 70% | +13.92 / −15.40 | 0.42 | −68.66 | 4% | 6.2 |
| Control period (last 30%) | 23 | +630.61 | 74% | +47.68 / −30.00 | 1.33 | −175.73 | 10% | 11.1 |
| Whole history | 53 | +784.40 | 72% | +29.03 / −21.24 | 0.81 | −175.73 | 6% | 7.7 |
* Fewer than 20 trades: the Sharpe ratio is not meaningful. Sharpe is computed on daily P&L in €/MWh, annualised with the series' observations per year.
| Cost per round trip | Total P&L (€/MWh) | Sharpe |
|---|---|---|
| 0× the stated cost | +837.40 | 0.87 |
| 1× the stated cost | +784.40 | 0.81 |
| 2× the stated cost | +731.40 | 0.75 |
| 4× the stated cost | +625.40 | 0.64 |
| Entry | Exit | Entry level | Exit level | P&L (€/MWh) | Why it closed |
|---|---|---|---|---|---|
| 9 Apr 2020 | 13 Apr 2020 | 6.27 | −9.46 | +14.73 | signal |
| 17 Apr 2020 | 20 Apr 2020 | 13.71 | −2.26 | +14.97 | signal |
| 12 Nov 2020 | 16 Nov 2020 | 0.08 | −2.80 | +1.87 | signal |
| 26 Dec 2020 | 27 Dec 2020 | −10.60 | −33.03 | +21.43 | signal |
| 28 Jun 2021 | 29 Jun 2021 | 0.89 | 1.58 | −1.69 | signal |
| 9 Jul 2021 | 10 Jul 2021 | 0.74 | −1.15 | +0.89 | signal |
| 15 Jul 2021 | 17 Jul 2021 | 15.65 | −1.69 | +16.34 | signal |
| 29 Jul 2021 | 30 Jul 2021 | −2.56 | 22.13 | −25.70 | signal |
| 31 Jul 2021 | 1 Aug 2021 | 2.37 | 8.38 | −7.01 | signal |
| 7 Aug 2021 | 9 Aug 2021 | 18.37 | 1.01 | +16.36 | signal |
| 1 Apr 2023 | 4 Apr 2023 | −3.47 | −3.05 | −1.42 | signal |
| 16 May 2023 | 17 May 2023 | −0.90 | −2.93 | +1.03 | signal |
| 2 Jul 2023 | 3 Jul 2023 | −52.67 | −14.27 | −39.40 | signal |
| 7 Aug 2023 | 8 Aug 2023 | −50.62 | −55.87 | +4.25 | signal |
| 12 Sept 2023 | 14 Sept 2023 | 23.72 | 19.53 | +3.19 | signal |
| 19 Oct 2023 | 20 Oct 2023 | 12.25 | 1.13 | +10.13 | signal |
| 29 Oct 2023 | 30 Oct 2023 | 7.27 | 0.67 | +5.59 | signal |
| 3 Jan 2024 | 4 Jan 2024 | −0.90 | 6.43 | −8.33 | signal |
| 18 Jan 2024 | 20 Jan 2024 | 6.85 | −4.21 | +10.06 | signal |
| 8 Feb 2024 | 11 Feb 2024 | 37.03 | 4.48 | +31.54 | signal |
| 21 Mar 2024 | 25 Mar 2024 | 27.33 | 36.92 | −10.59 | signal |
| 26 Mar 2024 | 30 Mar 2024 | 19.53 | 1.21 | +17.32 | signal |
| 4 Apr 2024 | 8 Apr 2024 | 54.99 | 79.52 | −25.54 | signal |
| 9 Apr 2024 | 14 Apr 2024 | 56.30 | 14.15 | +41.15 | signal |
| 16 Apr 2024 | 24 Apr 2024 | 53.06 | 26.98 | +25.08 | signal |
| 9 May 2024 | 13 May 2024 | 43.74 | 22.86 | +19.88 | signal |
| 28 May 2024 | 3 Jun 2024 | 71.45 | 89.40 | −18.95 | signal |
| 4 Jun 2024 | 6 Jun 2024 | 57.65 | 34.88 | +21.78 | signal |
| 18 Sept 2024 | 19 Sept 2024 | 29.41 | 23.27 | +5.14 | signal |
| 24 Sept 2024 | 26 Sept 2024 | 37.64 | 26.97 | +9.67 | signal |
| 7 Nov 2024 | 9 Nov 2024 | 50.14 | 2.88 | +46.27 | signal |
| 12 Dec 2024 | 14 Dec 2024 | 222.21 | −8.24 | +229.46 | signal |
| 21 Mar 2025 | 23 Mar 2025 | 42.85 | 5.58 | +36.27 | signal |
| 15 Apr 2025 | 22 Apr 2025 | 53.21 | 40.06 | +12.15 | signal |
| 6 May 2025 | 12 May 2025 | 77.37 | 44.01 | +32.36 | signal |
| 22 Jul 2025 | 23 Jul 2025 | 19.26 | −5.12 | +23.37 | signal |
| 22 Aug 2025 | 23 Aug 2025 | 22.97 | 4.69 | +17.28 | signal |
| 2 Sept 2025 | 8 Sept 2025 | 94.00 | 57.54 | +35.46 | signal |
| 10 Sept 2025 | 13 Sept 2025 | 112.10 | 51.26 | +59.83 | signal |
| 23 Sept 2025 | 26 Sept 2025 | 88.92 | 8.19 | +79.73 | signal |
| 26 Nov 2025 | 28 Nov 2025 | 65.20 | 6.95 | +57.25 | signal |
| 7 Feb 2026 | 28 Feb 2026 | 44.86 | 36.32 | +7.54 | max hold |
| 2 Jun 2026 | 5 Jun 2026 | 98.92 | 67.84 | +30.08 | signal |
| 9 Jun 2026 | 14 Jun 2026 | 64.07 | −2.71 | +65.78 | signal |
| 25 Aug 2026 | 26 Aug 2026 | −12.50 | −6.19 | −7.31 | signal |
| 1 Sept 2026 | 2 Sept 2026 | −4.92 | 0.14 | −6.06 | signal |
| 14 Sept 2026 | 16 Sept 2026 | 40.22 | 4.06 | +35.16 | signal |
| 23 Sept 2026 | 25 Sept 2026 | 31.73 | 15.11 | +15.62 | signal |
| 22 Oct 2026 | 23 Oct 2026 | −7.66 | 64.83 | −73.50 | signal |
| 24 Oct 2026 | 25 Oct 2026 | −18.64 | −12.22 | −7.42 | signal |
| 30 Oct 2026 | 1 Nov 2026 | 20.91 | 22.17 | −2.26 | signal |
| 12 Nov 2026 | 13 Nov 2026 | −7.50 | −35.51 | +27.02 | signal |
| 18 Nov 2026 | 19 Nov 2026 | 82.01 | 164.48 | −83.47 | open at end |