Live Algo Performance Dashboard (per-lane W/L + net P&L) — 2026-07-05

A per-lane W/L + net P&L dashboard of the live 5m algo, built 2026-07-05 from CLOB-settled realized P&L. Two reusable pull/render scripts plus a self-contained HTML artifact.

Scripts live in the SESSION SCRATCHPAD — ephemeral

dashboard_data.py and build_dashboard.py were built in the session scratchpad, NOT the repo — they are not persisted and will vanish with the session. If we want to keep the dashboard, move both into scripts/ in crypto_algo (repo wowjeeez/pmv2-crypto-algo). Flagging this explicitly so the tooling isn’t silently lost.

What it is

A per-lane (and per-asset / daily / overall) win/loss + net P&L view of the live algo — one glance at which lanes are green vs red.

Data source

pmv2_autotrade_orders.realized_pnl_usd — CLOB settlement, net of fees (the taker fee is baked into cost_basis). This is the label-truth-grade P&L column (24/24 sign-match vs CLOB tokens[].winner — see crypto-shortterm-lane-state-adverse-fill-2026-07-05), so no CLOB backfill is needed for it. Do NOT build P&L off resolved_up (over-books near-ties — crypto-shortterm-pnl-attribution-corrections-2026-07-03).

The two scripts (reusable)

• dashboard_data.py — pulls overall / daily / per-lane / per-asset metrics as JSON from the live DB via duckdb + postgres READ-ONLY (the SUPABASE_DB_URL → PG* env + ATTACH … (TYPE postgres, READ_ONLY) + postgres_query pattern from crypto-shortterm-data-sources).
• build_dashboard.py — re-bakes that JSON into a self-contained, dark-themed HTML dashboard (no external deps).

Deployment — claude.ai artifact (SNAPSHOT, not live)

Deployed as a claude.ai artifact. It is a SNAPSHOT, not live — Artifacts have no network access, so they cannot query the DB.

Refresh procedure

Refresh = re-run build_dashboard.py (which re-pulls fresh JSON via dashboard_data.py) + redeploy the artifact. There is no live auto-update.

Snapshot at build (2026-07-05)

Metric	Value
Booked net	~+$136
Fills	1,847
Win rate	74.0% vs 73.0% breakeven
Live-forward net (excl. dry btc-up)	~+$307

• xrp / doge — both-sides green (~78%), the strongest lanes.
• sol-down / eth-down — the soft down-side cluster.
• btc-up — the **−$171drag\ast \ast ,now\ast \ast DRY\ast \ast (adversefill,notsignal—see[[crypto-shortterm-lane-state-adverse-fill-2026-07-05]]);thisiswhylive-forward(+$307) is well above booked (~+$136).

Related

• crypto-shortterm-lane-state-adverse-fill-2026-07-05 — realized_pnl_usd == CLOB truth (the data source’s warrant) + btc-up DRY (the −$171 drag pulled out of the live-forward figure).
• crypto-shortterm-data-sources — the duckdb + postgres READ-ONLY live-DB access pattern the pull uses.
• crypto-shortterm-pnl-attribution-corrections-2026-07-03 — why realized_pnl_usd (not resolved_up) is the P&L label.
• crypto-shortterm-multi-asset-status-babylon-2026-07-02 — the 10-lane lineup the per-lane breakdown covers.
• crypto-shortterm — project index.