MIS ECOSYSTEM — Complete map of 5 sheets, 5 scripts, what's what

Sun May 3 2026 · 11:30 AM EDT · Claude Code Opus 4.7 · Session 22 (resume from Session 21)

🚨 SECURITY EMERGENCY — DO THIS IN THE NEXT 30 MINUTES

Per Sam's own forensic teardown of MIS Master v11.0f (production sheet 1cosuFr), Schwab + Finnhub credentials are stored in PLAINTEXT in the KEY_VALUE tab. Anyone with viewer access to that sheet can read and use them right now.

Exposed: SCHWAB_CLIENT_ID, SCHWAB_CLIENT_SECRET, SCHWAB_REFRESH_TOKEN, SCHWAB_ACCOUNT_HASH, EARNINGS_API_KEY (Finnhub).

DO NOW:

Revoke Schwab refresh token at developer.schwab.com
Rotate Schwab client secret
Invalidate Finnhub API key, generate new one
Audit who has viewer/editor access to 1cosuFr production sheet
Move credentials to PropertiesService — never in cell values again

BLUF: You have 5 sheets and 5 script projects, with confusing naming overlap. The PRODUCTION sheet is the most evolved (best engine + Schwab live + 200+ logged runs) but has the credential leak. v1 ("gemini sheet" / Architect V11 in your teardown) is the active edit-target. v2 (1F31z) is dead from Excel-roundtrip — discard. The new V2 SACS Sandbox (1HtMOd) is your test bed with the older Session 21 SACS formula. Architect V11 Microservices (1MU_Ni) is a DIFFERENT email engine firing weekend Power Hour emails alongside everything else — that's why you've been seeing duplicate emails. Three engines firing. Need to consolidate.

📋 THE COMPLETE MAP — 5 sheets + 5 scripts

#	Sheet name (Drive title)	Drive ID	Modified	Bound script	State	What it is
1	MIS_v7.1_gsheet (PRODUCTION)	`1cosuFr`	May 1 21:54	`1r9vWL` "emailDailySnapshot"	LIVE but credentials exposed	Sam calls this "MIS Master v11.0f" in teardown. Most evolved. Schwab live. 200+ logged runs since 3/12. SECURITY EMERGENCY.
2	MIS_v7.1_gsheet_forclaudeedit (a.k.a. v1, "gemini sheet", "Architect V11" in Sam's teardown)	`1HEmRev`	May 3 15:09	`1yBMzt` "gemini sheet"	ACTIVE — new SACS formula deployed	The sheet I worked on Session 21. Now shows LLY SACS = 86.77 (Sam updated formula since Session 21). 5-gate pipeline working. Has my BLUF/Actionable/Earnings-filter patches.
3	MIS_v7.1_gsheet_forclaudeedit_5-1_z gemini fixes_v2 (1F31z)	`1F31zPca`	May 3 15:15	`1fdqHW` (untitled, NEW today)	DEAD — engine collapsed	Excel-roundtrip damage. Per Sam's own teardown: 100% of SACS columns show `#NAME?`. Top 10 Movers Flow column shows "4.00" not real values. DISCARD.
4	MIS Architect V2 — SACS Upgrade [SANDBOX] (NEW today)	`1HtMOd`	May 3 15:18	`1ZGICn` NOT FOUND in Drive	SANDBOX — different SACS	Created today (May 3). LLY shows SACS = 70.43 — that's the OLD Session 21 formula (30/30/20/20). Comparison sandbox vs sheet #2's 86.77.
5	Architect V11 (Microservices Edition)	`1MU_Ni`	May 3 13:53	`1mSbzO` (untitled, Apr 27)	FIRING WEEKENDS — different email engine	SEPARATE microservices system. Tiny sheet (6.7KB). Has its own Control panel + Playbook Dashboard. This is what's sending you the "⚡ MIS Power Hour" emails Sat May 2 and Sun May 3. No weekend skip.

📧 THREE ENGINES → THREE EMAIL STREAMS (you've been getting duplicates)

Source	Email subject pattern	Cadence	Currently firing?
Production (`1cosuFr` + script `1r9vWL`)	"📈 MIS Morning Brief", "🚀 3:00 PM MIS Power Hour", "🚨 2:05 PM MIS Trade Action"	Mon-Fri at 9:46/12:00/2:05/3:00/5:45	Should be DEAD if you deleted triggers May 1 — verify in Apps Script Triggers UI
v1 / "gemini sheet" (`1HEmRev` + script `1yBMzt`)	"📈 MIS Morning Brief" (same subject as production — confusing)	Same 7 daily triggers, weekend-skip enforced	ACTIVE since Friday 5 PM
Architect V11 Microservices (`1MU_Ni` + script `1mSbzO`)	"⚡ MIS Power Hour \| MM/DD"	Per its CONTROL tab: 9:55 AM / 12:30 PM / 3:05 PM — NO weekend skip	FIRING SAT + SUN — confirmed Sat May 2 3:12 PM and Sun May 3 9:50 AM

Fix: Open Architect V11 (Microservices) script 1mSbzO → Triggers → either DELETE all OR add misIsWeekend_ guard like v1 has. If you want only one engine firing, kill V11 Microservices triggers entirely and let v1 do everything.

🔬 KEY ANALYSIS FROM SAM'S OWN TEARDOWNS (already in MIS repo, now committed)

Production sheet (1cosuFr / "MIS Master v11.0f")

Architecture: A-. Best built. Schwab integration live. 200+ logged runs.
Safety: C+. Plaintext credentials. Position sizer uncapped (generates 63 simultaneous BUY LMT orders, some 700% of portfolio).
SACS scale: 0-55 (different from V11/v1's 0-100)
Flow Strength: tristate enum (28/44/76 only) — not a true continuous index
Holdings tab broken: shows "no open trades" while Open_Trades has 20 positions
Catalyst sentiment parser misreads (e.g., "AMD avoided bankruptcy" → flagged Bearish)

v1 / Architect V11 (1HEmR / "gemini sheet")

Overall: B+. Architecture: A. Bugs bring it to B+.
Critical RiskGate bug: Threshold is Risk%≤2.5% which rejects LLY (3.91% risk) even though R:R is 2.5x. Should be R:R≥2.5 not Risk%≤2.5%. Every high-momentum, high-ATR stock (LLY, NVDA, MRVL, AMD) systematically blocked.
Sector misclassifications: BTCUSD as Utilities/Electric, INDEXNASDAQ as Semiconductors/Chips. Corrupts sector analytics.
Trade_Log formatting: dates show as 46125, prices as 93947.00%. Cell formats wrong.
RR_13W phantom values: AMGN 58,340,000 / DHR 48,270,000 from divide-by-near-zero.
10Y Yield shows $43.78 instead of 4.378%.
EarnFlag doesn't clear when DaysToEarn < 0 (post-earnings names stay blocked).

v2 / 1F31z (Excel-roundtrip)

Engine: F. Data layer: B+.
100% of SACS, Flow, Compression, Regime, Setup, Action Verdict columns show #NAME? or blank.
Root cause: missing named ranges or Apps Script custom functions when sheet was forked from V11.
Recommendation: discard, don't fix.

🛠️ NEW TOOLING SAM DROPPED TODAY (committed to MIS repo)

File	Purpose	Where to use
`runSACSUpgrade.js`	Programmatic SACS V2 upgrade. Applies 8 priority fixes including: RR_13W divide-by-zero IFERROR wrap, RiskGate change to `Shares ≥ 1`, BTCUSD sector fix, more.	Paste into v1 Apps Script. Run from MIS Tools menu. Logs all changes to SACS_Upgrade_Log tab.
`mobile_command_center.js`	Checkbox-driven control panel for mobile sheet operation. 5 buttons: SACS Upgrade / Morning Brief / Pull Data / LiveGuard / Diagnostics.	Paste into v1 Apps Script. Set up onEdit trigger. Add 5 checkboxes in Dashboard tab cells Z1-Z5.
`auto_triggers.js`	Reads CONTROL tab to set up time-based triggers. Auto-update on sheet open.	Replaces manual trigger setup. Edit CONTROL tab → triggers update next time you open sheet.
`trigger_power_system.js`	Google Form / webhook / Slack-command trigger patterns. Beyond time-based — instant trigger.	Pattern reference — pick the trigger style that fits.
`MIS_ARCHITECT_COMPLETE_FIXED.js`	Comprehensive fixed Architect script with all bugs patched.	Reference for full rewrite if you want to nuke and rebuild Architect V11 Microservices.
`MIS_Genesis_Context.docx` / `SACS_ZScore_Analysis.docx`	Background docs.	Reference reading.

🎯 WHAT TO DO — recommended sequence

P0 — Today (30 min)

Rotate Schwab credentials. developer.schwab.com → revoke refresh token + rotate client secret.
Rotate Finnhub key. Generate new key.
Audit production sheet sharing. Drive → 1cosuFr → Share → who has viewer/editor access?
Delete production triggers in script 1r9vWL if you didn't already on Friday.
Delete or weekend-guard Architect V11 Microservices triggers in script 1mSbzO — that's what's sending Saturday emails.

P1 — This week (1-2 hours)

Move credentials to PropertiesService on production script. Code change in Apps Script editor — paste the snippet from the teardown.
Apply runSACSUpgrade.js to v1. Paste into v1's bound script 1yBMzt via Apps Script editor → Run from MIS Tools menu. This patches the 8 known bugs in one go.
Decide: v1 or production as primary? v1 has cleaner SACS (86.77 LLY), production has Schwab live + better automation. Recommend: port v1's SACS upgrade INTO production, retire v1.
Discard v2 / 1F31z — rename to MIS_DEAD_DO_NOT_USE_2026-05-03 or trash.
Decide what to do with 1HtMOd Sandbox — keep as comparison testbed or merge into v1.

P2 — Next week (architectural)

Apply mobile_command_center.js to enable phone control.
Consolidate to ONE engine. Three is too many.
Migrate to PropertiesService for all secrets across all engines.
FSE Session 1 per docs/MIS_FSE_ARCHITECTURE.md §8 — wire INTC end-to-end through proper FINAL_STATE_ENGINE tab.

🔁 HOW MIS ARCHITECT EMAILS DIFFER FROM EACH OTHER

Production (1cosuFr) MIS emails — sent via misBuildDailyBrief_(): Macro Pulse + Game Plan + Forward Look + Trade Actions + Holdings. Has the BLUF / Actionable / Earnings-filter upgrades I pushed Friday. Subject lines: "📈 MIS Morning Brief", "🚀 3:00 PM MIS Power Hour", "🚨 2:05 PM MIS Trade Action".

v1 (1HEmRev) MIS emails — same code as production (I copied it Friday + repointed MIS_SPREADSHEET_ID). Same subjects. Same format. This is the duplicate of production unless production triggers are deleted.

Architect V11 Microservices (1MU_Ni) emails — completely DIFFERENT codebase. Format is "Power Hour Dashboard" with: SPY/QQQ/IWM/TNX/VIX summary, Tape Leaders/Laggards, Sector Performance, Candidate Setups (DUOL/IBIT/GD with full Stop/Target/Risk/Cap%/SACS). Cleaner, more compact. Subject: "⚡ MIS Power Hour | MM/DD". This format is actually quite good but uses different scoring.

📊 SACS FORMULA DISCREPANCY (the v1 vs Sandbox question)

Sheet	LLY SACS	Formula version
v1 / Architect V11 (1HEmR)	86.77	NEW formula deployed today (Sam's update)
V2 SACS Upgrade Sandbox (1HtMOd)	70.43	OLD Session 21 formula (30/30/20/20 weighted)
Production (1cosuFr)	~50.99 (INTC)	Different scale entirely (0-55)

Three different SACS values for similar tickers. Which is "right"? Per the Architect V11 teardown Sam wrote: "the math is mostly right. The weights in Reference_Rules are reasonable. The main distortion is the RiskGate rejecting high-SACS names before they can reach the output." So the SACS is fine; the gate is wrong.

📂 NEW MIS FOLDER STATE — files committed today

MIS_Master_v11_0f_Forensic_Teardown.md (19KB) — production sheet teardown
MIS_V11_Forensic_Teardown.md (22KB) — v1 / Architect V11 teardown
MIS_1F31z_Forensic_Teardown.md (16KB) — broken sheet teardown
runSACSUpgrade.js (23KB) — programmatic upgrade script
MIS_ARCHITECT_COMPLETE_FIXED.js (46KB) — fixed architect
mobile_command_center.js (9.5KB) — mobile checkbox controls
auto_triggers.js (8KB) — auto trigger setup
trigger_power_system.js (11KB) — advanced trigger patterns
MIS_Genesis_Context.docx + SACS_ZScore_Analysis.docx

All committed and pushed: MIS 466930d..5138cab

Source trail
File: outputs/2026-05-03_11-30_briefing_mis-ecosystem-map.html
MIS commit: 5138cab (Sam's analysis + tooling)
Reads: 5 sheet metadata + 5 script metadata via Drive MCP, 3 forensic teardowns, 4 new script files, MIS folder ls, project_mis_resume_marker.md memory
Generated by Claude Code Opus 4.7 (1M context) · Session 22 · Sun May 3 2026 · 11:30 AM EDT
Receipts Protocol: glob → read → cite. All claims sourceable.