"""r10_report.py -- per variant and period: R10 triggers, per trade after 0.2%, halves, win."""
import json
from collections import defaultdict
from pathlib import Path
import numpy as np
HERE = Path(__file__).resolve().parent
names = {"A": "2024-26 Star lists (incl. rescans)", "B": "2024-26 old-score top 30 (trade bot)", "C": "2016-18 top 30 (out of sample)"}
P = {}
for p in "ABC":
    f = HERE / f"r10_{p}.json"
    if f.exists():
        P[p] = json.load(open(f))
vars_ = sorted({r["var"] for X in P.values() for r in X})
def st(X):
    if not X: return f"{'-':>32}"
    a = np.array([r["pl"] for r in X]); days = sorted({r["day"] for r in X}); h = days[len(days) // 2]
    y = np.array([r["day"] < h for r in X])
    return f"{len(X):4} {a.mean():+.3f}% ({a[y].mean() if y.any() else 0:+.2f}/{a[~y].mean() if (~y).any() else 0:+.2f}) w{np.mean(a > 0):.0%}"
print("R10 per trade after 0.2% cost, C3 exit (halves) win%  |  " + " | ".join(names[p] for p in P))
rows = []
for v in vars_:
    cells = [st([r for r in P[p] if r["var"] == v]) for p in P]
    rows.append((v, cells))
for v, cells in rows:
    print(f"  {v:18} " + " | ".join(cells))
d = "rm1.5_ch1.0_bs50"
for p in P:
    X = [r for r in P[p] if r["var"] == d]
    w = defaultdict(list)
    for r in X: w[r["why"]].append(r["pl"])
    print(f"default {d} {names[p]} exits: " + ", ".join(f"{k} {len(v)} {np.mean(v):+.2f}%" for k, v in w.items()))
print("R10REPORT_DONE")
