public_html/sizing/index.html extended with a Live Alerts panel above the strategy selector. Cards render from pending_alerts.json; each shows symbol, direction, grade, entry/stop/TP1, R:R, and live-previewed share count. Click → applyAlert() loads strategy, locks entry/stop, shows source-indicator badge. Clear-alert returns to manual mode. Deep-link: ?alert_id=918422. Refresh re-polls feed.pending_alerts.json stub created — /public_html/sizing/pending_alerts.json. 4 realistic indicator_alerts-shaped rows (MSTR VWAP Pull-In, QQQ Trend, TSLA Backside, IBIT TD VWAP). Schema mirrors live table 1-for-1. Swap the one-line constant for /api/pending_alerts once migration 001 runs.vwap-bands/sizing/index.html now meta-refreshes to canonical trsportsacademy.com/sizing/. Old bookmarks alive, zero drift.bella_fade_examples/build_examples.py created. Ingests SNOW/HOOD daily + intraday KITE bar JSON, computes cumulative VWAP ±2σ bands, renders examples.html for the Bella Fade intern template.SCIENTIFIC_SPEC_CHANGELOG.md addendum defines the 4-step path to go fully live: run migration 001, upstream producers add stop/tp/grade fields to payload, build /api/pending_alerts PHP endpoint (SQL written), swap one-line URL constant. No new UI code needed.trsportsacademy.com/sizing/ is canonical. SMB subdomain path redirects there. Prevents sizing-calculator drift across subdomains.| Task | Owner | Blocker |
|---|---|---|
| Scientific layer migrations 001–009 | user | Needs psql run via set_db.sh start tunnel |
/api/pending_alerts live endpoint | claude | Migration 001 must run first (adds stop_price/tp1/tp2/grade) |
| p0-daily-summary-view (3/6) | user | Migration 004 staged, unrun |
| journal-user-steps (P0) | user | Run add_scorecard_columns.sql, confirm user_id=2, click Save |
| p0-indicator-alerts-ddl (P0) | user | psql -c '\d alerts_tradingview.indicator_alerts' dump |
| data-freshness-audit (P0) | claude | Needs DB access / SSH tunnel |
| risk-hud-api-wire (P1) | claude | Needs smb subdomain endpoint payload schema |
| pm-activity-scanner-deploy (P1) | user | Import XML on DESKTOP-AKU8I62 |
| Bella Fade examples page | claude | Needs SNOW/HOOD bar JSON at KITE temp path (builder ready) |
p0-freshness-dashboard) — Claude-owned, no user steps, unblocked now. One JSON feed + banner on hub.risk-hud-api-wire) — confirm smb endpoint URL + payload shape, remove mock data from risk.html.