/vwap-bands/sizing/. Interactive position sizing per trade_playbooks_scientific_spec §5: grade × edge-overlay × DD-taper → live share count, multiplier bars, worked example (72 shares). Standalone for now; DB wiring pending migrations.strategy-bar.js extended with computeSizing, gradeMult, edgeOverlay, ddTaper; sizing badge + edge tooltip CSS; Scientific layer demo section added to strategy-bar/index.html. Backwards-compatible..sci-tip tooltips on stat labels; new 4-up Scientific-Layer row (Expectancy-R, Sortino-60, Avg MAE-R, Leave-on-table-R) with placeholder values for future generated playbooks.9 SQL files in migrations/scientific_layer/. Live DB untouched. Run manually in order via psql tunnel — see README.md.
| # | File | What it does | Phase 0 task |
|---|---|---|---|
| 001 | 001_indicator_alerts_columns.sql | Add stop_price, tp1, tp2, grade to indicator_alerts | 0a |
| 002 | 002_journal_r_multiple_columns.sql | Add R-multiple + MAE/MFE + grade columns to main.journal | 0b |
| 003 | 003_banned_names_table.sql | Create main.banned_names with date versioning | 0c |
| 004 | 004_daily_summary_view.sql | Create main.daily_summary VIEW | p0-daily-summary-view (3/6) |
| 005 | 005_rolling_stats_matview.sql | Create main.rolling_stats MATVIEW (Sharpe/Sortino/Calmar-60) | 0e |
| 006 | 006_setup_performance_view.sql | Create main.setup_performance VIEW | 0f |
| 007 | 007_users_sizing_columns.sql | Add daily_risk_budget, per_trade_risk_pct to main.users | Phase 1 |
| 008 | 008_sizing_helpers.sql | SQL helpers: grade_mult(), edge_overlay_fn(), dd_taper_fn() | Phase 1 |
| 009 | 009_sizing_recommendation_view.sql | Create main.sizing_recommendation VIEW | Phase 1 |
| Task | Owner | Blocker |
|---|---|---|
| P0 Scientific layer migrations 001–009 | user | Need psql run in order via DB tunnel (set_db.sh start) |
| P0 p0-daily-summary-view (3/6) | user | Migration 004 staged but unrun |
| P0 journal-user-steps | user | Run add_scorecard_columns.sql, confirm user_id=2, click Save |
| P0 p0-indicator-alerts-ddl | user | psql -c '\d alerts_tradingview.indicator_alerts' dump |
| P1 risk-hud-api-wire | claude | Needs live smb subdomain endpoint URL + payload schema |
| P0 data-freshness-audit | claude | Needs DB access via SSH tunnel or a2 direct |
| P1 pm-activity-scanner-deploy | user | Import task_scheduler_import.xml on DESKTOP-AKU8I62 |
set_db.sh start, then psql each file in order. ~15 min. Unlocks p0-daily-summary-view (3/6) + sizing calculator DB wiring + rolling_stats + sizing_recommendation.risk-hud-api-wire) — confirm smb endpoint URL + payload schema, replace mock data in risk.html.p0-freshness-dashboard) — /system/freshness.json + stale-badge on hub. Unblocked for Claude.