# Daily Progress — 2026-04-23 (Wednesday)

## What Shipped

- **Sizing Calculator: alert-driven mode** — `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 fields, shows `source-indicator` badge. Clear-alert returns to manual. Deep-link: `?alert_id=918422`. Refresh button re-polls the feed.
- **`pending_alerts.json` stub** — Created at `/z/public_html/sizing/`. 4 realistic `indicator_alerts`-shaped rows (MSTR VWAP Pull-In, QQQ Trend, TSLA Backside, IBIT TD VWAP). Schema mirrors live table 1-for-1. Swapped for a real `/api/pending_alerts` endpoint once migration 001 runs.
- **Old sizing URL redirected** — `vwap-bands/sizing/index.html` now redirects to canonical `trsportsacademy.com/sizing/`. Old bookmarks live; zero drift risk.
- **Bella Fade examples builder** — `setup_daily_reporting/reports/bella_fade_examples/build_examples.py` created. Ingests SNOW/HOOD daily + intraday bar JSON from KITE temp files, computes cumulative VWAP ±2σ bands, and renders an `examples.html` for the Bella Fade intern template.

## What Moved Forward

- **Scientific layer alert wire-up path fully documented** — `SCIENTIFIC_SPEC_CHANGELOG.md` addendum defines the 4-step path to go fully live: run migration 001 (adds `stop_price`, `tp1`, `tp2`, `grade` to `indicator_alerts`), upstream producers include those fields, build `/api/pending_alerts` PHP endpoint (SQL written in spec), swap one-line constant in `index.html`. No new code needed beyond those steps.
- **Canonical URL policy set** — `trsportsacademy.com/sizing/` is canonical; the SMB subdomain path redirects there. Prevents future drift.

## What's Blocked

| 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 columns) |
| `p0-daily-summary-view` (3/6) | user | Migration 004 staged but 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 in KITE temp path (build_examples.py ready) |

## Tomorrow's Priority

1. **USER: run scientific_layer migrations 001–009** — unlocks live alert feed + p0-daily-summary-view + sizing DB wiring. ~15 min via tunnel.
2. **Phase 0 freshness dashboard** (`p0-freshness-dashboard`) — fully Claude-owned, no user steps required, unblocked now.
3. **Wire Risk HUD to live API** (`risk-hud-api-wire`) — confirm smb endpoint URL + payload shape, then remove mock data from `risk.html`.

## Files Touched

- `public_html/sizing/index.html` — extended with Live Alerts panel, applyAlert(), source-indicator badge, deep-link, refresh
- `public_html/sizing/pending_alerts.json` — **NEW**: 4-row stub alert feed (MSTR/QQQ/TSLA/IBIT)
- `gt_dev/db_reports/james-monthly-reports/vwap-bands/sizing/index.html` — replaced with meta-refresh redirect to canonical URL
- `setup_daily_reporting/reports/bella_fade_examples/build_examples.py` — **NEW**: Bella Fade worked-examples HTML generator (VWAP ±2σ from KITE bars)
- `setup_daily_reporting/reports/SCIENTIFIC_SPEC_CHANGELOG.md` — addendum: alert-driven pivot, canonical URL table, wire-up path, open decision points

---
*Generated by nightly-project-manager at 23:00 ET · 0 completed, 4 shipped/extended, 9 blocked · Top priority tomorrow: run migrations 001–009*
