MIS MASTER SUMMARY — your single source of truth

🎯 #1 — YOUR MAIN SHEET (and what to click each day)

📋 #2 — EVERY SHEET / SCRIPT YOU HAVE — status + action

📨 #3 — WHAT FIRES MON MAY 4 (your A/B test)

✅ #4 — WHAT'S FIXED vs WHAT'S NOT

✅ FIXED in v1 (live now):

• BLUF section at top of every email
• ACTIONABLE TODAY (Lean In + In Sync gate) separated from LEAN IN SETUPS (informational)
• Earnings list filtered to your holdings + watchlist + actionable (was a 30-ticker dump)
• Game Plan Bias reflects actionable count, not raw setup count
• Macro panel CODE upgraded to pull Gold spot / BTC / ETH / USD via CURRENCY:XAUUSD style symbols (will show real values IF Google Finance returns them — see #6)
• SPY direction falls back to S&P 500 macro line when SPY isn't in the signals universe
• SACS scaling expanded 1.8× (LLY now 86.77 vs old 70.43 cap)
• v1 script has runSACSUpgrade.js + mobile_command_center.js loaded — ready to run

❌ NOT YET FIXED:

• RiskGate still blocks LLY/AMD/MRVL despite high SACS — fix is to RUN runSACSUpgrade (already in v1 script, awaiting your click)
• Trade_Planner missing entry dates — Schwab seed CSV ready at MIS/SCHWAB_898_TRADE_LOG_SEED.csv for paste
• SPY MISSING_PRICE in Holdings — Tickers tab needs SPY row repair (5 min in browser)
• 13W high/low using too-short window — Momentum Engine column N/O formula needs widening
• Tape Breadth shows 0 up / 0 down — counter logic bug (deeper code fix)
• Holdings peak / drawdown / 1d-3d-7d delta tracking — schema addition needed
• Schwab + Finnhub credentials still PLAINTEXT in production sheet KEY_VALUE tab — needs rotation when you consolidate
• Sector misclassifications (BTCUSD as Utilities, INDEXNASDAQ as Semiconductors) — need Tickers tab edits

🌐 #5 — REAL GOLD/BITCOIN/ETHER VALUES (your concern about $3,300)

You're right to push back — I shouldn't pretend to know real-time prices. Honest answer:

The real fix in code (already pushed Friday): v1's misBuildMacroPulse_ at line 4334 of emailDailySnapshot.js uses these symbols. Tomorrow's email will show whatever Google Finance returns for them. If Gold or BTC come back blank, GF doesn't support that symbol consistently and we need an external API (Finnhub for crypto/forex, metals-api for gold).

🏗️ #6 — YOUR ARCHITECTURE QUESTION (one master script for all sheets?)

Your instinct is correct. The pattern you're describing is solid: one master sheet that pulls macro/signal data once, other sheets VLOOKUP from it. Two ways to do it:

Option A — One container-bound script per sheet (current approach)

Each sheet has its own bound script. Pro: when you open any sheet, its menu appears. Con: code drift across copies. This is what you have now.

Option B — One master script bound to ONE master sheet, controls all others (what you're describing)

Master sheet has the script. Master script uses SpreadsheetApp.openById('1cosuFr...') etc. to read/write OTHER sheets. Pro: one source of truth, no code drift. Con: triggers fire from master only — if master breaks, all stop. Pro: matches your mental model.

Recommendation: use Option B with v1 as the master. v1's script reads from production for Schwab data, writes signals back to production, fires emails for both. One codebase to maintain.

VLOOKUP vs QUERY weight question

The architecture you're proposing makes sense for one specific reason: GOOGLEFINANCE is the bottleneck. If 5 sheets each call =GOOGLEFINANCE("AAPL"), Google rate-limits you and one or more returns blank. If ONE master sheet calls it, then 5 sheets VLOOKUP from the master, you've reduced 5 GF calls to 1. Same data, no rate limit.

This is a real performance win, not just aesthetics.

📁 #7 — LOCAL FOLDER MAP

Working directory: C:\Users\ztrei\OneDrive\2. Hook Street\05. 2026 BH\

🚀 #8 — YOUR NEXT 3 MOVES (in order, no thinking)