The spine is the PostgreSQL database (trsports_tradingjournal_dev). It owns all facts: trades, alerts, journal notes, users.
The cockpit is the Accountability HUD — the daily landing page that enforces rules across all 6 traders.
Everything else is a lens onto the spine — different views for different jobs.
If the spine dies, everything dies. If a lens dies, you rebuild it in a weekend.
The 14 properties
Accountability HUD v2Cockpit
Daily rule enforcement for all 6 traders. Primary landing page. Tracks DML violations, streaks, week bans, buying power, ticket meter.
Covers: James, Enrique, Preston, Nolan, Brian, Thomas
Grain: Day / Week
SMB Risk Plan: 10 numbered rules
Daily ReviewLIVE · Primary daily review surface
The actual daily review entry point — “what happened today?” One page per trading day: every fill/sequence, machine-hypothesis and volume-at-entry classification, canonical-model comparison stats, and a deep link into the Strategy Lens per trade. This is the foundation the next-generation Execution Scorecard is being built on top of — it is not itself the finished scorecard (see Scorecards below).
Canonical strategy registry. Every strategy — built-in and user-uploaded — gets a row with its own optimization grid, backtest, live performance. VWAP bands 3×4 is the first strategy; others follow the same shape. All trades in the DB get scored against every registered strategy.
FL2 V2 Multi-Band Trail backtest (Mar 30 – Apr 10) + walk-forward. This is strategy row 1 in the Param Surface registry — the same strategy needs to run over live trades, not just its backtest window. Every new strategy added follows this same shape.
Needs: gen_walkforward.py to read live trades via main.daily_summary + indicator_alerts (not a fixed window)
Publishes: strategy registry row with params, backtest stats, live-performance delta
Data freshness: must advance as new trades land; currently static (2-week window)
Morning Game PlanLIVE
Daily pre-market doc. 7 sections: Technical Bias (ChipHazzard multi-TF), Vital Dawn snapshot, Ned Davis breadth composite (8 indicators, KITE top-100), Stocks In Play with Planned vs Actual, Flagged Names, Earnings, Econ Calendar. Calendar nav + date dropdown.
Multi-TF Risk Read: SPY/QQQ/IWM × 5m/15m/30m/65m ChipHazzard state
Planned vs Actual: Would-Have sim on untraded picks (5-min bars)
Output: /mgp/YYYY-MM-DD.html before market open (daily 05:47 ET)
Risk Manager HUDCockpit · New
Stop-utilization gauge per trader. Summary row: # clear / warning / danger / breach. Risk View sort (worst first). 60s auto-refresh countdown. Currently on mock data — awaiting live API endpoint from smb subdomain.
Trader control dashboard for intraday risk discipline. Sets daily limits (max loss, trade count, sizing), tracks real-time P&L + win rate, logs trades by playbook + HTF setup. Danger Zone halts trading at max loss requiring acknowledgment. Backed by shared user_settings endpoint — same daily_stop value seeds MGP Max Risk + Accountability HUD.
Storage: main.user_settings via /scorecards/api/user_settings.php (CORS-enabled for smb subdomain)
Linked to: Sizing Calculator (Strategy Bar v1.1.0), MGP Max Risk calc
Outstanding: register dot on hub freshness signal · wire MGP risk pipe to read this endpoint instead of hardcoded settings
MTF VP ScannerNEW · In Progress
Multi-timeframe volume profile confluence scanner. DB scaffold applied, BTCUSD backfill seeded. Live TradingView hookup pending.
DB scaffold applied: 2026-04-21
Pending: live TradingView webhook → DB write
Strategy LibraryLens · Scientific Layer
Curated catalog — LIVE 2026-04-30. All setups, one page. Filterable by family (VWAP/Pullback, Counter-trend, Level Breakout, Event-Driven, Gap Fade), direction, timing. The "what am I trading?" answer that precedes Scorecards' "how did I trade it?".
Defines the family taxonomy used by Playbooks + Scorecards
User Strategy UploadNEW · Proposed
Self-service: upload your own strategy as JSON rules → backtest against your journal → admin approval → row in Param Surface. Plugs into the curated Strategy Library above.
New table: main.user_strategies
Reuses backtest engine (kti backtest-*)
Adds role and is_approved to main.users
Infrastructure · Machine Roster
Tailscale-mesh networking. IPs in the 100.x.x.x range are stable regardless of DHCP / network / ISP.
SSH aliases configured on domino-1 — any agent can use ssh jimdo / ssh a2 directly.
ssh jimdo · key-based auth · added 2026-05-13. Will mirror scheduled tasks once warm-backup script ships.
a2 (cloud / a1prospect.com)
Postgres source-of-truth · web host · accountability daemons
Linux · user: trsports
ssh a2 · serves trsportsacademy.com + smb.a1prospect.com. No kti (Windows-only).
james-trader (planned)
James's new dedicated trading machine
Windows · runs Gr8Trade, IBKR, eTrade clients
Tailscale + SSH setup pending. Will host the Execution Gateway.
Projects · the 9 initiatives
Locked 2026-06-20. Codenames are aligned to descriptive titles (no metaphor decoding required).
Each card shows live open-task count from todos.json. Click for the per-project Gantt.
Reading /todos/todos.json…
Live freshness
Source 1: /system/freshness.json (local property mtimes).
Source 2: App Watchdog (cross-host a2 probe every 30 min via Task Scheduler on domino-1 — covers 14 apps).
Reading /system/freshness.json…
How it all connects — the 30-second pitch
One database is the spine. All trades, all alerts, all journal notes live in PostgreSQL.
One page is the daily cockpit — the Accountability HUD — where the whole team lands each morning to see rule compliance.
The lenses read left-to-right as the trader's lifecycle:Strategy Library (what am I trading?) →
Playbooks (how do I teach it?) →
Morning Game Plan (what's the plan today?) →
Accountability HUD (did everyone obey the rules?) →
Scorecards (how did I execute?) →
Monthly Reports (what's the trend?) →
Param Surface (which strategy works best?).
Same data, ordered by when in the trader's day each lens earns attention.
Same-day review has its own mini-lifecycle inside GRADE:Daily Review (what happened today?) →
Strategy Lens (why did this setup happen?) →
Execution Scorecard (how well did I execute? — next-gen, in progress).
Daily Review is now the actual daily-review entry point — trades, sequences, machine/model observations, volume-at-entry, review notes, and links into the Lens; the existing Scorecards lens above still stands while that richer workflow evolves into its replacement. Scorecards/review data ultimately rolls up into Monthly Reports and Param Surface for longer-term trend and process analysis.
NOT empty (verified 2026-04-18). Has entry_price, vwap, bands, market_regime, playbook_type. Likely missing: stop_price, tp1, tp2, grade, rvol, ema_slope.
Non-negotiable rules (the fix-it-once contract)
Single source of truth per concept. Trades → main.journal. Alerts → alerts_tradingview.indicator_alerts. Notes → main.daily_report_cards. No page computes or caches its own version. data
All times are Eastern (America/New_York). Every displayed and stored time is ET. Display strings always include the " ET" suffix (e.g. 16:30 ET, 2026-06-20T16:30:00-04:00). UTC may exist only inside internal protocol layers (scheduled-tasks API, Postgres TIMESTAMPTZ storage, git commits) and must be converted to ET at the boundary before display, storage in user-facing JSON, or log lines. Filenames date-keyed to the ET calendar day. Use zoneinfo.ZoneInfo("America/New_York") in Python whenever possible (handles DST automatically). Anti-patterns: datetime.utcnow() for user-facing values, missing " ET" suffix, scheduling cron in UTC when wall-clock ET was meant. Full rule: feedback_timezone_eastern.md. time
All identities resolve through one function.account_id → user_id → trader_name. Adding a trader is a row, not code. identity
Every generator is idempotent + declares provenance. Same DB state ⇒ byte-identical output. Every page footer declares generated_at, generator_version, source_tables, row_counts. provenance
Pre-publish chart checks: non-zero rows, ET timestamps, stacked axes share first+last bar, intraday bars have constant session delta. charts
System status at a glance updated 2026-04-22
Accountability HUD — live, data freshness unverified
Risk Manager HUD — UI built (gauges, sort, auto-refresh); on mock data until smb live API wired
Scorecards (James) — generator runs; 4/1–4/13 manifest gaps; DB enrichment requires server-side run or SSH tunnel
Monthly reports — freshness unknown; gen_reports.py runs in EOD batch