"""r11_report.py NAME -- per setting: triggers, per trade after 0.2% (C3 / level exit), halves, win, trades/day, both periods."""
import json, sys
from collections import defaultdict
import numpy as np
name = sys.argv[1] if len(sys.argv) > 1 else "r11"
P = {p: json.load(open(f"{name}_{p}.json")) for p in ("lib", "10y")}
lab = {"lib": "2024-26", "10y": "2016-18"}
def st(X, k):
    if not X: return "-"
    a = np.array([x[k] for x in X]); d = sorted({x["day"] for x in X}); h = d[len(d) // 2]; y = np.array([x["day"] < h for x in X])
    return f"{a.mean():+.3f}% ({a[y].mean():+.2f}/{a[~y].mean():+.2f}) w{np.mean(a > 0):.0%}"
rows = []
for v in sorted({x["var"] for X in P.values() for x in X}):
    cells = []; score = []
    for p in ("lib", "10y"):
        X = [x for x in P[p] if x["var"] == v]; nd = len({x["day"] for x in P[p]}) or 1
        cells.append(f"{lab[p]}: n {len(X):6} ({len(X) / 503:.1f}/day) C3 {st(X, 'c3')} | LV {st(X, 'lv')}")
        score.append(min(np.mean([x['c3'] for x in X]), np.mean([x['lv'] for x in X])) if X else -9)
    rows.append((min(score), v, cells))
print(f"{name.upper()} per trigger (no account limits), per trade after 0.2% cost, (halves) win  -- sorted by the worse of the 4 numbers")
for sc, v, cells in sorted(rows, reverse=True):
    print(f"  {v:26} {cells[0]}\n  {'':26} {cells[1]}")
