);
};
// ─────────────────────────────────────────────────────────────────────────────
// Per-ticker settings — edit Bloomberg ticker, peers, TradingView symbol, etc.
// for an EXISTING holding, straight from the page (no SQL editor).
// ─────────────────────────────────────────────────────────────────────────────
const TickerSettings = ({ inv, onSave, onClose }) => {
const isMobile = useIsMobile();
const [f, setF] = React.useState({
name: inv.name || '', tvSymbol: inv.tvSymbol || '', query: inv.query || '',
careersUrl: inv.careersUrl || '', bloombergTicker: inv.bloombergTicker || '',
peers: (inv.peers || []).join(', '), color: inv.color || PRESET_COLORS[0],
});
const [saving, setSaving] = React.useState(false);
const [err, setErr] = React.useState('');
const set = (k, v) => setF(p => ({ ...p, [k]: v }));
const lbl = { fontFamily: fontMono, fontSize: '10px', letterSpacing: '0.12em', color: tokens.inkMute, display: 'block', marginBottom: '5px' };
const inp = { width: '100%', padding: '8px 10px', border: `1px solid ${tokens.inkLine}`, background: '#FDFBF7', fontFamily: 'inherit', fontSize: '13px', color: tokens.ink, boxSizing: 'border-box', outline: 'none' };
const submit = async () => {
setSaving(true); setErr('');
const e = await onSave({
name: f.name.trim() || inv.name,
tv_symbol: f.tvSymbol.trim(),
exchange: f.tvSymbol.trim().split(':')[0],
query: f.query.trim() || f.name.trim() || inv.name,
careers_url: f.careersUrl.trim() || null,
bloomberg_ticker: f.bloombergTicker.trim() || null,
peers: parsePeers(f.peers),
color: f.color,
});
if (e) { setErr(e.message || 'Save failed.'); setSaving(false); } else onClose();
};
return (
SETTINGS · {inv.ticker}
COMPANY NAME
TRADINGVIEW SYMBOL
BLOOMBERG TICKER
set('bloombergTicker', e.target.value)} placeholder="ASMDEE SS Equity" />
{suggestBloomberg(f.tvSymbol) && f.bloombergTicker !== suggestBloomberg(f.tvSymbol) && (
set('bloombergTicker', suggestBloomberg(f.tvSymbol))}
style={{ fontFamily: fontMono, fontSize: '9px', color: tokens.inkMute, marginTop: '4px', cursor: 'pointer' }}>
↳ suggested: {suggestBloomberg(f.tvSymbol)}
)}
CAREERS URL (optional)
PEERS (comma-separated Bloomberg tickers — drives the comps panel)
COLOR
{PRESET_COLORS.map(c => (
set('color', c)} title={c}
style={{ width: '22px', height: '22px', borderRadius: '50%', background: c, cursor: 'pointer', flexShrink: 0, boxShadow: f.color === c ? `0 0 0 2px ${tokens.paper}, 0 0 0 3.5px ${c}` : 'none' }} />
))}
{err &&
{err}
}
{saving ? 'SAVING…' : 'SAVE'}
CANCEL
THEN ⟳ RUN PULL (comps) · saved to live_investments
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Bloomberg Financial Summary panel
// Reads from `bloomberg_snapshots` table (populated by scripts/bloomberg_push.py).
// Shows EV build-up waterfall + IS financials (LTM | FY1E | FY2E).
// ─────────────────────────────────────────────────────────────────────────────
// Local helper (scripts/bloomberg_runner.py) that lets the button trigger the
// Bloomberg pull on the owner's machine. Browsers permit https→localhost fetches.
const BLOOMBERG_RUNNER = 'http://127.0.0.1:8765';
const BloombergPanel = ({ investment }) => {
const isMobile = useIsMobile();
const [collapsed, toggleCollapsed] = useCollapsed('bloomberg');
const [snap, setSnap] = React.useState(null);
const [status, setStatus] = React.useState('loading');
const [runState, setRunState] = React.useState('idle'); // idle|running|ok|err
const [runMsg, setRunMsg] = React.useState('');
const loadSnap = React.useCallback((quiet) => {
const client = window._supabaseClient;
if (!client) { setStatus('unconfigured'); return; }
if (!quiet) { setStatus('loading'); setSnap(null); }
client
.from('bloomberg_snapshots')
.select('bloomberg_ticker, fetched_at, data')
.eq('ticker', investment.ticker)
.single()
.then(({ data, error }) => {
if (error || !data) { if (!quiet) setStatus('empty'); return; }
setSnap(data);
setStatus('ready');
});
}, [investment.ticker]);
React.useEffect(() => { loadSnap(false); }, [loadSnap]);
const runPull = React.useCallback(async () => {
setRunState('running');
setRunMsg('Running bloomberg_push.py on your machine…');
try {
const res = await fetch(BLOOMBERG_RUNNER + '/run', { method: 'POST' });
const j = await res.json().catch(() => ({}));
if (j.ok) {
setRunState('ok');
setRunMsg('Pull complete — refreshing data.');
loadSnap(true);
// Tell sibling panels (Comps, Value-Gap) that the snapshot changed.
window.dispatchEvent(new CustomEvent('bbg-snapshot-updated', { detail: investment.ticker }));
setTimeout(() => { setRunState('idle'); setRunMsg(''); }, 5000);
} else {
setRunState('err');
setRunMsg(j.error || 'Pull failed — is the Bloomberg Terminal open?');
}
} catch (e) {
setRunState('err');
setRunMsg('Local runner not reachable. Start it on your computer: python scripts/bloomberg_runner.py');
}
}, [loadSnap, investment.ticker]);
if (status === 'unconfigured') return null;
const panelHeader = (right) => (
BLOOMBERG · FINANCIAL SUMMARY
{right && {right} }
{runState === 'running' ? 'RUNNING…' : '⟳ RUN PULL'}
{!collapsed && runMsg && (
{runMsg}
)}
);
const shell = (header, body) => (
{header}
{!collapsed && body}
);
if (status === 'loading') return shell(
panelHeader(''),
LOADING…
);
if (status === 'empty') return shell(
panelHeader(''),
No Bloomberg data for {investment.ticker} yet.
Start the helper once (Terminal must be open): python scripts/bloomberg_runner.py ⟳ RUN PULL above — or run python scripts/bloomberg_push.py directly.
);
// ── Data + format helpers ──
const d = snap.data;
const ccy = d.reporting_currency || d.currency || 'USD';
const sym = ({ USD: '$', EUR: '€', GBP: '£' })[ccy] || (ccy + ' ');
const fmtM = (v) => {
if (v == null) return '—';
const abs = Math.abs(v);
const neg = v < 0;
const s = abs >= 1000 ? `${sym}${(abs / 1000).toFixed(1)}B` : `${sym}${Math.round(abs)}M`;
return neg ? `(${s})` : s;
};
const fmtX = (v) => v == null ? '—' : `${v.toFixed(1)}x`;
const fmtPct = (n, dn) => (!n || !dn) ? '—' : `${(n / dn * 100).toFixed(1)}%`;
const fmtEPS = (v) => v == null ? '—' : `${sym}${Math.abs(v).toFixed(2)}`;
const fmtGrowthVal = (pct) => {
if (pct == null) return '—';
return (pct >= 0 ? '+' : '') + pct.toFixed(1) + '%';
};
const ev = d.ev_buildup || {};
const periods = d.periods || [];
const ml = d.multiples_ltm || {};
const mf = d.multiples_fwd || [];
// Multiples columns: LTM actual + each forward estimate year
const mulCols = [ml, ...mf];
// Shared cell styles
const hdCellStyle = { fontFamily: fontMono, fontSize: '9px', letterSpacing: '0.14em', color: tokens.inkMute, paddingBottom: '7px', borderBottom: `1px solid ${tokens.inkLine}`, whiteSpace: 'nowrap' };
const hdNum = (est) => ({ ...hdCellStyle, textAlign: 'right', color: est ? tokens.ink : tokens.inkMute });
const numCellStyle = (v) => ({ fontFamily: fontMono, fontSize: '12px', color: v === '—' ? tokens.inkMute : tokens.ink, textAlign: 'right', padding: '7px 0', borderBottom: `1px solid ${tokens.inkLineSoft}`, whiteSpace: 'nowrap' });
const lblCellStyle = (muted) => ({ fontSize: '12px', color: muted ? tokens.inkSoft : tokens.ink, padding: '7px 0', borderBottom: `1px solid ${tokens.inkLineSoft}` });
const evRows = [
{ label: 'Market Cap', value: fmtM(ev.market_cap), indent: false, bold: false },
{ label: '+ Net Debt', value: fmtM(ev.net_debt), indent: true, bold: false },
{ label: '+ Minorities', value: fmtM(ev.minorities), indent: true, bold: false },
{ label: '+ Preferred', value: fmtM(ev.preferred), indent: true, bold: false },
{ label: 'Enterprise Value', value: fmtM(ev.ev), indent: false, bold: true },
];
const mulMetrics = [
{ label: 'EV / EBITDA', key: 'ev_ebitda' },
{ label: 'EV / Revenue', key: 'ev_revenue' },
{ label: 'P / E', key: 'pe' },
];
// Income-statement rows defined as accessors over each period column
const isMetrics = [
{ label: 'Revenue', muted: false, get: p => fmtM(p.revenue) },
// LTM overlaps the last reported fiscal year, so a "YoY" there is 0%/noise — blank it.
{ label: '↳ YoY growth', muted: true, get: p => p.kind === 'ltm' ? '—' : fmtGrowthVal(p.rev_growth) },
{ label: 'EBITDA', muted: false, get: p => fmtM(p.ebitda) },
{ label: 'EBITDA margin', muted: true, get: p => fmtPct(p.ebitda, p.revenue) },
{ label: 'EBIT', muted: true, get: p => fmtM(p.ebit) },
{ label: 'Net Income', muted: false, get: p => fmtM(p.net_income) },
{ label: 'EPS (diluted)', muted: false, get: p => fmtEPS(p.eps) },
{ label: 'CFO', muted: false, get: p => fmtM(p.cfo) },
{ label: 'FCF', muted: false, get: p => fmtM(p.fcf) },
];
const fye = d.fiscal_year_end; // e.g. "12/31" — fiscal periods are FY-based, not calendarized
const isHeader = isMobile
? `IS · ${ccy} M${fye ? ` · FYE ${fye}` : ''}`
: `INCOME STATEMENT · ${ccy} M` + (fye ? ` · FYE ${fye}` : '');
const fetchedAt = new Date(snap.fetched_at);
const updatedStr = fetchedAt.toLocaleDateString('en-US', { month: 'short', day: 'numeric' }) + ' ' +
fetchedAt.toLocaleTimeString([], { hour: '2-digit', minute: '2-digit' });
const isCols = `minmax(${isMobile ? '88px' : '120px'}, 1.4fr) repeat(${periods.length}, minmax(54px, 1fr))`;
return shell(
panelHeader(`${snap.bloomberg_ticker} · Updated ${updatedStr}`),
{/* ── Top: EV build-up + multiples side by side (stacked on mobile) ── */}
{/* EV waterfall */}
EV BUILD-UP
{ccy} M
{evRows.map(({ label, value, indent, bold }) => (
{label}
{value}
))}
{/* Multiples */}
VALUATION
{mulCols.map((c, i) => (
0)}>{c.label || (i === 0 ? 'LTM' : '—')}
))}
{mulMetrics.map(({ label, key }) => (
{label}
{mulCols.map((c, i) => {
const v = fmtX(c[key]);
return {v}
;
})}
))}
{/* ── Bottom: full-width income statement (CY24A · CY25A · LTM · CY26E · CY27E) ── */}
{/* Meta line sits above the scroll area so the long label never overlaps columns */}
{isHeader}
{periods.map((p, i) => (
{p.label}
))}
{isMetrics.map(({ label, get, muted }) => (
{label}
{periods.map((p, i) => {
const v = get(p);
return {v}
;
})}
))}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Peer Comps panel — benchmarks the holding vs its configured peer set on
// operating metrics (2 historical + 3 forward). Reads bloomberg_snapshots.data
// .comps, populated by scripts/bloomberg_push.py from the live_investments.peers
// list. Pure read; same RUN PULL button on the Bloomberg panel refreshes it.
// ─────────────────────────────────────────────────────────────────────────────
const _median = (arr) => {
const v = arr.filter((x) => x != null).sort((a, b) => a - b);
if (!v.length) return null;
const m = Math.floor(v.length / 2);
return v.length % 2 ? v[m] : (v[m - 1] + v[m]) / 2;
};
const CompsPanel = ({ investment }) => {
const isMobile = useIsMobile();
const [collapsed, toggleCollapsed] = useCollapsed('comps');
const [comps, setComps] = React.useState(undefined); // undefined=loading
const [updated, setUpdated] = React.useState('');
const loadComps = React.useCallback(() => {
const client = window._supabaseClient;
if (!client) { setComps(null); return; }
client.from('bloomberg_snapshots').select('data, fetched_at').eq('ticker', investment.ticker).maybeSingle()
.then(({ data }) => {
if (!data) { setComps(null); return; }
setUpdated(data.fetched_at ? new Date(data.fetched_at).toLocaleDateString() : '');
setComps((data.data && data.data.comps) || null);
});
}, [investment.ticker]);
React.useEffect(() => {
loadComps();
// Re-read when the Bloomberg panel completes a pull for this ticker.
const onUpd = (e) => { if (!e.detail || e.detail === investment.ticker) loadComps(); };
window.addEventListener('bbg-snapshot-updated', onUpd);
return () => window.removeEventListener('bbg-snapshot-updated', onUpd);
}, [loadComps, investment.ticker]);
const header = (right) => (
BLOOMBERG · PEER COMPS
{right &&
{right} }
);
const shell = (body, right) => (
{header(right)}{!collapsed && body}
);
if (comps === undefined) return null; // stay quiet until the snapshot resolves
if (!comps || comps.configured === false) {
// Distinguish "no peers configured" from "peers saved but the snapshot has
// no comps yet" (pull not run since saving, or the machine running the pull
// has an outdated bloomberg_push.py without comps support).
const peersSaved = (investment.peers || []).length;
return shell(
{peersSaved ? (
{peersSaved} peer{peersSaved === 1 ? '' : 's'} saved for {investment.ticker} — the last Bloomberg snapshot doesn't include comps yet.
Click ⟳ RUN PULL on the Bloomberg panel above.git pull origin main there first (comps were added to scripts/bloomberg_push.py recently).
) : (
No peer set configured for {investment.ticker}.
Use ⚙ EDIT above to add ~5 Bloomberg peer tickers
(e.g. GPN US Equity, FOUR US Equity, FIS US Equity ), then ⟳ RUN PULL on the Bloomberg panel.
)}
);
}
const cols = comps.columns || [];
const rows = comps.rows || [];
const peers = rows.filter((r) => !r.is_self);
const colHead = (
<>
COMPANY
{cols.map((c) => (
{c.label}
))}
);
// One metric block: a small matrix of companies × periods, self row highlighted,
// plus a peer-median row to read the holding against the set at a glance.
const MetricTable = ({ title, field, fmt, tone }) => {
const gridCols = `1.5fr repeat(${cols.length}, 1fr)`;
const cell = (v, self) => (
= 0 ? tokens.green : tokens.red) : tokens.ink),
fontWeight: self ? 600 : 400 }}>{fmt(v)}
);
return (
{title}
{colHead}
{rows.map((r) => (
{r.name}
{cols.map((c) => cell((r[field] || {})[c.label], r.is_self))}
))}
{peers.length > 0 && (
PEER MEDIAN
{cols.map((c) => cell(_median(peers.map((r) => (r[field] || {})[c.label])), false))}
)}
);
};
const pct = (v) => v == null ? '—' : (v >= 0 ? '+' : '') + v.toFixed(0) + '%';
const mgn = (v) => v == null ? '—' : v.toFixed(0) + '%';
// Forward-multiple matrix (estimate columns only).
const estCols = cols.filter((c) => c.kind === 'estimate');
const MultTable = ({ title, key2 }) => {
const gridCols = `1.5fr repeat(${estCols.length}, 1fr)`;
return (
{title}
COMPANY
{estCols.map((c) =>
{c.label}
)}
{rows.map((r) => (
{r.name}
{estCols.map((c) => {
const v = ((r.fwd_multiples || {})[c.label] || {})[key2];
return
{v == null ? '—' : v.toFixed(1) + 'x'}
;
})}
))}
);
};
return shell(
SELF = {investment.ticker} (highlighted). FCF consensus is unavailable, so forward FCF growth is blank. Source: Bloomberg · {updated || '—'}.
,
`${peers.length} PEERS · ${updated || '—'}`
);
};
// ─────────────────────────────────────────────────────────────────────────────
// People panel — management & board roster + psychographic profiles. Reads
// people_snapshots; the RESEARCH button runs the `people-intel` Edge Function
// (Claude + web search). Ownership/comp (item 3) + network (item 4) layer in here.
// ─────────────────────────────────────────────────────────────────────────────
const _confBand = (c) => c == null ? ['—', tokens.inkMute] : c >= 0.7 ? ['High', tokens.green] : c >= 0.4 ? ['Moderate', tokens.ochre || '#C9A24A'] : ['Low', tokens.red];
const ProfileCard = ({ p, accent }) => {
const [open, setOpen] = React.useState(false);
const conf = typeof p.confidence === 'number' ? p.confidence : null;
const [band, bandColor] = _confBand(conf);
const chips = (label, arr) => (arr && arr.length) ? (
{label}
{arr.map((m, i) => {m} )}
) : null;
const line = (label, v) => v ? (
) : null;
return (
{p.name}
{p.role}
CONF {band}{conf != null ? ` ${Math.round(conf * 100)}%` : ''}
{p.summary &&
{p.summary}
}
{chips('MOTIVATIONS', p.motivations)}
{line('DECISION STYLE', p.decision_style)}
{line('RISK POSTURE', p.risk_posture)}
{line('COMMUNICATION', p.communication_style)}
{p.activist_read && (
HOW TO ENGAGE
{p.activist_read}
)}
{p.sources && p.sources.length > 0 && (
setOpen(o => !o)} style={{ background: 'none', border: 'none', cursor: 'pointer', fontFamily: fontMono, fontSize: '10px', letterSpacing: '0.08em', color: tokens.inkMute, padding: 0 }}>
{open ? '▾' : '▸'} {p.sources.length} SOURCE{p.sources.length === 1 ? '' : 'S'}
{open && (
)}
)}
);
};
const PeoplePanel = ({ investment }) => {
const isMobile = useIsMobile();
const ticker = investment.ticker;
const accent = investment.color || tokens.ink;
const [collapsed, toggleCollapsed] = useCollapsed('people');
const [data, setData] = React.useState(undefined); // undefined=loading cache
const [run, setRun] = React.useState('idle'); // idle|running|error
const [err, setErr] = React.useState('');
React.useEffect(() => {
const client = window._supabaseClient;
if (!client) { setData(null); return; }
const load = () => client.from('people_snapshots').select('data').eq('ticker', ticker).maybeSingle()
.then(({ data: row }) => setData((row && row.data) || null));
load();
const onUpd = (e) => { if (!e.detail || e.detail === ticker) load(); };
window.addEventListener('people-snapshot-updated', onUpd);
return () => window.removeEventListener('people-snapshot-updated', onUpd);
}, [ticker]);
const research = React.useCallback(async () => {
const client = window._supabaseClient;
if (!client) return;
setRun('running'); setErr('');
try {
const payload = await invokePeopleIntel(ticker, investment.name || ticker, 'people');
setData(payload); setRun('idle');
} catch (e) { setErr(e.message || 'Research failed'); setRun('error'); }
}, [ticker, investment.name]);
const header = (
MANAGEMENT & BOARD INTEL
{data && data.fetched_at && {new Date(data.fetched_at).toLocaleDateString()} }
{run === 'running' ? 'RESEARCHING…' : '⟳ RESEARCH'}
);
const shell = (body) => (
{header}{!collapsed && body}
);
if (data === undefined) return null;
if (run === 'running' && (!data || !data.profiles)) return shell(
Researching management & board from public filings and sources — this can take a minute or two.
);
if (!data || (!(data.profiles || []).length && !(data.roster || []).length)) return shell(
No management/board intel for {ticker} yet.
{err &&
{err}
}
Click ⟳ RESEARCH to build the roster + psychographic profiles (needs the people-intel function deployed).
);
const profiles = data.profiles || [];
const roster = data.roster || [];
const mgmt = roster.filter((r) => r.type === 'management');
const board = roster.filter((r) => r.type === 'board');
const rosterCol = (title, list) => (
{title} · {list.length}
{list.map((m, i) => (
{m.name}
{(m.is_chair || m.is_lead_independent) && (
{m.is_lead_independent ? 'LEAD IND' : 'CHAIR'}
)}
{(m.role || '').toUpperCase()}
{m.bio &&
}
))}
);
return shell(
{err &&
{err}
}
{profiles.length > 0 && (
PSYCHOGRAPHIC PROFILES
{profiles.map((p, i) =>
)}
Synthesized from public sources by Claude · confidence is evidence-calibrated · verify before acting.
)}
{roster.length > 0 && (
{rosterCol('MANAGEMENT', mgmt)}
{rosterCol('BOARD', board)}
)}
);
};
// Shared invoker for the people-intel Edge Function (modes: people | governance | holders).
// The function does its research in the BACKGROUND (it would otherwise exceed the
// Edge wall-clock) and answers { started: true } immediately; we then poll
// people_snapshots until this mode's timestamp advances — or its error appears.
const invokePeopleIntel = async (ticker, company, mode) => {
if (!roleCanResearch()) throw new Error(DEMO_BLOCK_MSG);
const client = window._supabaseClient;
const since = new Date().toISOString();
const { data, error } = await client.functions.invoke('people-intel', { body: { ticker, company, mode } });
let payload = data;
if (error) { try { payload = await error.context.json(); } catch {} if (!payload || !payload.error) throw new Error(error.message || 'Edge function error'); }
if (payload && payload.error) throw new Error(payload.error);
if (!payload || !payload.started) {
// Older deploy: result returned inline — still notify sibling panels.
window.dispatchEvent(new CustomEvent('people-snapshot-updated', { detail: ticker }));
return payload;
}
const stampKey = mode === 'people' ? 'fetched_at' : `${mode}_fetched_at`;
const errKey = `${mode}_error`, errAtKey = `${mode}_error_at`;
const deadline = Date.now() + 6 * 60 * 1000;
while (Date.now() < deadline) {
await new Promise((r) => setTimeout(r, 6000));
const { data: row } = await client.from('people_snapshots').select('data').eq('ticker', ticker).maybeSingle();
const d = row && row.data;
if (!d) continue;
if (d[errKey] && d[errAtKey] && d[errAtKey] >= since) throw new Error(d[errKey]);
if (d[stampKey] && d[stampKey] >= since) {
// Tell every panel reading people_snapshots (network, people, holders) to re-read.
window.dispatchEvent(new CustomEvent('people-snapshot-updated', { detail: ticker }));
return d;
}
}
throw new Error('Research timed out (6 min) — it may still complete in the background; reload in a minute.');
};
// Panel chrome shared by the intel panels below.
const IntelShell = ({ title, right, onAction, actionLabel, running, collapseKey, children }) => {
const [collapsed, toggle] = useCollapsed(collapseKey || title);
return (
{title}
{right && {right} }
{onAction && (
{running ? 'RUNNING…' : actionLabel}
)}
{!collapsed && children}
);
};
// Money formatter for the governance tables ($1.2M / $840K).
const _fmtUsd = (v) => {
if (v == null) return '—';
const a = Math.abs(v);
if (a >= 1e9) return `$${(v / 1e9).toFixed(1)}B`;
if (a >= 1e6) return `$${(v / 1e6).toFixed(1)}M`;
if (a >= 1e3) return `$${Math.round(v / 1e3)}K`;
return `$${Math.round(v)}`;
};
// ─────────────────────────────────────────────────────────────────────────────
// Value-Creation Gap panel — quantifies the activist upside mechanically from
// the comps data: close the EBITDA-margin gap to peer median, re-rate to the
// peer-median forward multiple, or both. Pure client-side math; illustrative.
// ─────────────────────────────────────────────────────────────────────────────
const ValueGapPanel = ({ investment }) => {
const isMobile = useIsMobile();
const [snap, setSnap] = React.useState(undefined);
React.useEffect(() => {
const client = window._supabaseClient;
if (!client) { setSnap(null); return; }
const load = () => client.from('bloomberg_snapshots').select('data').eq('ticker', investment.ticker).maybeSingle()
.then(({ data }) => setSnap((data && data.data) || null));
load();
const onUpd = (e) => { if (!e.detail || e.detail === investment.ticker) load(); };
window.addEventListener('bbg-snapshot-updated', onUpd);
return () => window.removeEventListener('bbg-snapshot-updated', onUpd);
}, [investment.ticker]);
if (snap === undefined || !snap) return null;
const comps = snap.comps;
if (!comps || comps.configured === false || !(comps.rows || []).length) return null;
const estCols = (comps.columns || []).filter((c) => c.kind === 'estimate');
if (!estCols.length) return null;
const lab = estCols[0].label; // first forward year, e.g. FY26E
const self = comps.rows.find((r) => r.is_self) || {};
const peers = comps.rows.filter((r) => !r.is_self);
const estPeriod = (snap.periods || []).find((p) => p.kind === 'estimate' && p.label === lab) || (snap.periods || []).find((p) => p.kind === 'estimate') || {};
const ev = (snap.ev_buildup || {}).ev;
const rev = estPeriod.revenue, ebitda = estPeriod.ebitda;
if (ev == null || rev == null || ebitda == null) return null;
const selfMult = ev / ebitda;
const peerMult = _median(peers.map((r) => ((r.fwd_multiples || {})[lab] || {}).ev_ebitda));
const selfMargin = ebitda / rev * 100;
const peerMargin = _median(peers.map((r) => (r.ebitda_margin || {})[lab]));
const selfGrowth = (self.rev_growth || {})[lab];
const peerGrowth = _median(peers.map((r) => (r.rev_growth || {})[lab]));
const uplift = peerMargin != null ? Math.max(0, (peerMargin - selfMargin) / 100 * rev) : 0;
const ccy = snap.reporting_currency || snap.currency || 'USD';
const sym = ({ USD: '$', EUR: '€', GBP: '£' })[ccy] || (ccy + ' ');
const fmtM = (v) => v == null ? '—' : (Math.abs(v) >= 1000 ? `${sym}${(v / 1000).toFixed(1)}B` : `${sym}${Math.round(v)}M`);
const levers = [
{ name: `Close margin gap to peer median (${peerMargin != null ? peerMargin.toFixed(0) : '—'}% vs ${selfMargin.toFixed(0)}%)`, value: uplift * selfMult,
note: `+${fmtM(uplift)} EBITDA × ${selfMult.toFixed(1)}x current multiple` },
{ name: `Re-rate to peer-median multiple (${peerMult != null ? peerMult.toFixed(1) : '—'}x vs ${selfMult.toFixed(1)}x)`, value: peerMult != null ? ebitda * (peerMult - selfMult) : null,
note: `${fmtM(ebitda)} EBITDA × ${(peerMult != null ? (peerMult - selfMult) : 0).toFixed(1)}x re-rating` },
{ name: 'Both (peer margin × peer multiple)', value: peerMult != null && peerMargin != null ? (ebitda + uplift) * peerMult - ev : null,
note: `${fmtM(ebitda + uplift)} EBITDA × ${peerMult != null ? peerMult.toFixed(1) : '—'}x − current EV` },
];
const maxAbs = Math.max(1, ...levers.map((l) => Math.abs(l.value || 0)));
return (
{levers.map((l, i) => {
const pct = l.value != null ? l.value / ev * 100 : null;
const pos = (l.value || 0) >= 0;
return (
{l.name}
{l.value == null ? '—' : `${pos ? '+' : ''}${fmtM(l.value)} (${pos ? '+' : ''}${pct.toFixed(0)}% of EV)`}
{l.note.toUpperCase()}
);
})}
REV GROWTH {lab}: SELF {selfGrowth != null ? `${selfGrowth >= 0 ? '+' : ''}${selfGrowth.toFixed(0)}%` : '—'} · PEER MED {peerGrowth != null ? `${peerGrowth >= 0 ? '+' : ''}${peerGrowth.toFixed(0)}%` : '—'}
MECHANICAL PEER-CONVERGENCE MATH — NOT A PRICE TARGET
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Ownership & Compensation panel (item 3) — standardized across companies.
// Reads people_snapshots.{ownership,comp}; research = people-intel mode 'governance'.
// ─────────────────────────────────────────────────────────────────────────────
const OwnershipCompPanel = ({ investment }) => {
const isMobile = useIsMobile();
const ticker = investment.ticker;
const [data, setData] = React.useState(undefined);
const [run, setRun] = React.useState(false);
const [err, setErr] = React.useState('');
const load = React.useCallback(() => {
const client = window._supabaseClient;
if (!client) { setData(null); return; }
client.from('people_snapshots').select('data').eq('ticker', ticker).maybeSingle()
.then(({ data: row }) => setData((row && row.data) || null));
}, [ticker]);
React.useEffect(() => { load(); }, [load]);
const research = async () => {
setRun(true); setErr('');
try { setData(await invokePeopleIntel(ticker, investment.name || ticker, 'governance')); }
catch (e) { setErr(e.message); }
finally { setRun(false); }
};
if (data === undefined) return null;
const ownership = (data && data.ownership) || [];
const comp = (data && data.comp) || [];
const sayOnPay = comp.length ? comp.find((c) => c.say_on_pay_support_pct != null) : null;
const chips = (arr, fmt) => (arr || []).map((m, i) => (
{fmt(m)}
));
const body = (!ownership.length && !comp.length) ? (
No ownership/comp data for {ticker} yet.
{err &&
{err}
}
Click ⟳ RESEARCH PROXY — Claude reads the latest DEF 14A and standardizes ownership + STIP/LTIP structure.
) : (
{err &&
{err}
}
{ownership.length > 0 && (
INSIDER OWNERSHIP
{[...ownership].sort((a, b) => (b.pct || 0) - (a.pct || 0)).map((o, i) => (
{o.name}
{o.role}
{!isMobile && (
)}
{o.pct != null ? `${o.pct}%` : '—'}
{!isMobile &&
{_fmtUsd(o.value_usd)}
}
))}
)}
{comp.length > 0 && (
COMPENSATION STRUCTURE · {comp[0].fiscal_year || ''}
{sayOnPay && SAY-ON-PAY {sayOnPay.say_on_pay_support_pct}% SUPPORT }
{['NEO', 'SALARY', 'STIP TGT', 'STIP METRICS', 'LTIP TGT', 'LTIP MIX', 'LTIP METRICS', 'TOTAL'].map((h) => (
{h}
))}
{comp.map((c, i) => (
{_fmtUsd(c.salary)}
{c.stip_target_pct_of_salary != null ? `${c.stip_target_pct_of_salary}%${c.stip_max_pct ? ` / ${c.stip_max_pct}%` : ''}` : '—'}
{chips(c.stip_metrics, (m) => `${m.metric} ${m.weight_pct != null ? m.weight_pct + '%' : ''}`)}
{_fmtUsd(c.ltip_target_value)}
{chips(c.ltip_mix, (m) => `${m.vehicle} ${m.weight_pct != null ? m.weight_pct + '%' : ''}`)}
{chips(c.ltip_metrics, (m) => `${m.metric} ${m.weight_pct != null ? m.weight_pct + '%' : ''}${m.period ? ' · ' + m.period : ''}`)}
{_fmtUsd(c.total_comp)}
))}
STIP TGT = target bonus as % of salary (/ max where disclosed). Parsed from the DEF 14A by Claude — verify against the filing before relying on it.
)}
);
return (
{body}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Network map panel (item 4) — interactive vis-network graph of board/management
// overlaps (co-boards, shared employers/schools) from people_snapshots.network,
// with your own relationship tags layered on top (person_tags). Pan/zoom/drag/
// click are native; physics layout spreads labels so they don't collide.
// ─────────────────────────────────────────────────────────────────────────────
const EDGE_COLORS = { board_seat: '#9A938A', employer: '#7A9BB8', education: '#A88BC2', co_board: '#C9622E', shared_employer: '#7A9BB8', shared_education: '#A88BC2' };
// vis-network renderer. Builds DataSets from the graph, fits to view, and emits
// node selection up to the panel. Tag highlights (gold ring) update in place.
const VisNetwork = ({ net, accent, ticker, tags, onSelect }) => {
const ref = React.useRef(null);
const netRef = React.useRef(null);
const nodesRef = React.useRef(null);
const [failed, setFailed] = React.useState(false);
React.useEffect(() => {
let cancelled = false;
setFailed(false);
ensureVis(() => {
if (cancelled || !ref.current || !window.vis) return;
const personIds = new Set((net.nodes || []).filter((n) => n.type === 'person').map((n) => n.id));
const nodeArr = [{ id: '__HUB__', label: ticker, shape: 'dot', size: 26, color: { background: accent, border: accent }, font: { color: '#FBFAF6', size: 15, face: 'JetBrains Mono' }, fixed: { x: false, y: false } }];
const seen = new Set(['__HUB__']);
(net.nodes || []).forEach((n) => {
if (seen.has(n.id)) return; seen.add(n.id);
const person = n.type === 'person';
const tagged = !!tags[n.id];
nodeArr.push({
id: n.id, label: n.label || n.id,
shape: person ? 'dot' : 'diamond',
size: person ? 14 : 9,
color: { background: '#FBFAF6', border: tagged ? '#C9A24A' : (person ? tokens.ink : '#9A938A') },
borderWidth: tagged ? 3 : 1.5,
font: { size: person ? 14 : 11, color: person ? tokens.ink : '#7A736A', face: 'Inter' },
title: (n.label || n.id) + (n.role ? ' — ' + n.role : ''),
});
});
const edgeArr = [];
personIds.forEach((id) => edgeArr.push({ from: '__HUB__', to: id, color: { color: '#D8D2C6', opacity: 0.6 }, width: 1 }));
(net.edges || []).forEach((e) => {
const pp = personIds.has(e.source) && personIds.has(e.target);
edgeArr.push({ from: e.source, to: e.target, color: { color: EDGE_COLORS[e.kind] || '#B9B2A6' }, dashes: pp, width: pp ? 2.5 : 1, title: `${e.source} ↔ ${e.target}${e.detail ? ' — ' + e.detail : ''} (${e.kind})` });
});
try {
nodesRef.current = new window.vis.DataSet(nodeArr);
const edges = new window.vis.DataSet(edgeArr);
netRef.current = new window.vis.Network(ref.current, { nodes: nodesRef.current, edges }, {
physics: { solver: 'barnesHut', barnesHut: { gravitationalConstant: -9000, centralGravity: 0.25, springLength: 130, springConstant: 0.035, avoidOverlap: 0.5 }, stabilization: { iterations: 220 } },
interaction: { hover: true, tooltipDelay: 120, dragNodes: true, zoomView: true, dragView: true },
nodes: { borderWidth: 1.5, shadow: false },
edges: { smooth: { enabled: true, type: 'continuous' } },
});
netRef.current.on('selectNode', (p) => { if (p.nodes && p.nodes.length) onSelect(p.nodes[0] === '__HUB__' ? null : p.nodes[0]); });
netRef.current.on('deselectNode', () => onSelect(null));
// Freeze the layout once it has settled — otherwise the physics sim keeps
// nudging nodes and the whole graph slowly drifts/rotates forever.
// Nodes remain individually draggable with physics off.
netRef.current.once('stabilizationIterationsDone', () => {
if (!netRef.current) return;
netRef.current.setOptions({ physics: { enabled: false } });
netRef.current.fit({ animation: { duration: 300 } });
});
} catch (e) { setFailed(true); }
}, () => { if (!cancelled) setFailed(true); });
return () => { cancelled = true; if (netRef.current) { netRef.current.destroy(); netRef.current = null; } };
}, [net, ticker, accent]);
// Reflect tag changes (gold ring) without rebuilding the whole graph.
React.useEffect(() => {
const ds = nodesRef.current;
if (!ds) return;
const ups = [];
ds.forEach((nd) => {
if (nd.id === '__HUB__' || nd.shape !== 'dot') return;
const tagged = !!tags[nd.id];
ups.push({ id: nd.id, borderWidth: tagged ? 3 : 1.5, color: { background: '#FBFAF6', border: tagged ? '#C9A24A' : tokens.ink } });
});
if (ups.length) ds.update(ups);
}, [tags]);
if (failed) {
return (
Couldn't load the graph library. Check your connection and reopen this panel.
);
}
return
;
};
const NetworkPanel = ({ investment }) => {
const isMobile = useIsMobile();
const ticker = investment.ticker;
const accent = investment.color || '#C9A24A';
const [net, setNet] = React.useState(undefined);
const [tags, setTags] = React.useState({}); // person -> {relationship, note, id}
const [selected, setSelected] = React.useState(null);
React.useEffect(() => {
const client = window._supabaseClient;
if (!client) { setNet(null); return; }
const loadNet = () => client.from('people_snapshots').select('data').eq('ticker', ticker).maybeSingle()
.then(({ data: row }) => setNet((row && row.data && row.data.network) || null));
loadNet();
client.from('person_tags').select('id, person, relationship, note').eq('ticker', ticker)
.then(({ data: rows }) => {
const m = {};
(rows || []).forEach((r) => { m[r.person] = r; });
setTags(m);
});
// Re-read when a research run (e.g. RESEARCH PROXY) updates the snapshot.
const onUpd = (e) => { if (!e.detail || e.detail === ticker) loadNet(); };
window.addEventListener('people-snapshot-updated', onUpd);
return () => window.removeEventListener('people-snapshot-updated', onUpd);
}, [ticker]);
const toggleTag = async (person) => {
const client = window._supabaseClient;
if (!client) return;
if (tags[person]) {
await client.from('person_tags').delete().eq('id', tags[person].id);
setTags((t) => { const n = { ...t }; delete n[person]; return n; });
} else {
const { data: row } = await client.from('person_tags').insert({ ticker, person, relationship: 'know' }).select().single();
if (row) setTags((t) => ({ ...t, [person]: row }));
}
};
if (net === undefined) return null;
const hasGraph = net && (net.nodes || []).length > 0;
const body = !hasGraph ? (
No network data for {ticker} yet.
The graph is built by the ⟳ RESEARCH PROXY run on the Ownership & Compensation panel above (same research pass extracts the network).
) : (
DRAG TO MOVE · SCROLL TO ZOOM · CLICK A PERSON TO INSPECT & TAG
{/* selected-person detail + tagging */}
{selected && (() => {
const n = (net.nodes || []).find((x) => x.id === selected) || { id: selected };
const myEdges = (net.edges || []).filter((e) => e.source === selected || e.target === selected);
return (
{n.label || n.id}
{n.role && {n.role} }
toggleTag(selected)}
style={{ fontFamily: fontMono, fontSize: '10px', letterSpacing: '0.08em', padding: '5px 11px', cursor: 'pointer', background: tags[selected] ? '#C9A24A' : 'none', color: tags[selected] ? tokens.ink : tokens.inkSoft, border: `1px solid ${tags[selected] ? '#C9A24A' : tokens.inkLine}` }}>
{tags[selected] ? '★ I KNOW THEM' : '☆ TAG: I KNOW THEM'}
{myEdges.length > 0 && (
{myEdges.map((e, i) => (
({e.kind})
))}
)}
);
})()}
● PERSON ◆ EXTERNAL ORG
┄ CO-BOARD
— SHARED EMPLOYER
— SHARED SCHOOL
○ TAGGED (I KNOW THEM)
);
return (
{body}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Shareholder-base panel — passive/active mix, activists, 13F changes.
// Reads people_snapshots.holders; research = people-intel mode 'holders'.
// ─────────────────────────────────────────────────────────────────────────────
const HOLDER_COLORS = { passive: '#9A938A', active: '#1A4FB5', activist: '#C9622E', insider: '#1F6F5C', other: '#B9B2A6' };
const HoldersPanel = ({ investment }) => {
const ticker = investment.ticker;
const [data, setData] = React.useState(undefined);
const [run, setRun] = React.useState(false);
const [err, setErr] = React.useState('');
React.useEffect(() => {
const client = window._supabaseClient;
if (!client) { setData(null); return; }
const load = () => client.from('people_snapshots').select('data').eq('ticker', ticker).maybeSingle()
.then(({ data: row }) => setData((row && row.data) || null));
load();
const onUpd = (e) => { if (!e.detail || e.detail === ticker) load(); };
window.addEventListener('people-snapshot-updated', onUpd);
return () => window.removeEventListener('people-snapshot-updated', onUpd);
}, [ticker]);
const research = async () => {
setRun(true); setErr('');
try { setData(await invokePeopleIntel(ticker, investment.name || ticker, 'holders')); }
catch (e) { setErr(e.message); }
finally { setRun(false); }
};
if (data === undefined) return null;
const holders = (data && data.holders) || [];
const sum = (data && data.holders_summary) || null;
const maxPct = Math.max(0.1, ...holders.map((h) => h.pct || 0));
const body = !holders.length ? (
No shareholder-base data for {ticker} yet.
{err &&
{err}
}
Click ⟳ MAP HOLDERS — Claude researches 13F data + the proxy to map who decides a vote.
) : (
{err &&
{err}
}
{sum && (
{[['PASSIVE', sum.passive_pct], ['ACTIVE', sum.active_pct], ['INSIDER', sum.insider_pct], ['TOP-10', sum.top10_pct]].map(([k, v]) => (
{k}
{v != null ? `${v}%` : '—'}
))}
)}
{[...holders].sort((a, b) => (b.pct || 0) - (a.pct || 0)).map((h, i) => (
{h.name}
{h.pct != null ? `${h.pct}%` : '—'}
{(h.change || '—').toUpperCase()}
))}
{sum && sum.commentary && (
{sum.commentary}
)}
{Object.entries(HOLDER_COLORS).map(([k, c]) => · 13F-BASED APPROXIMATIONS
);
return (
{body}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Site-watch panel — alt-data from the company's own website. Watches configured
// pages (leadership, pricing, product/news), diffs on refresh, Claude summarizes
// investor-relevant changes. Reads site_snapshots; refresh = `site-watch` function.
// ─────────────────────────────────────────────────────────────────────────────
const SiteWatchPanel = ({ investment }) => {
const ticker = investment.ticker;
const [urls, setUrls] = React.useState([]);
const [snap, setSnap] = React.useState(undefined);
const [report, setReport] = React.useState(null);
const [run, setRun] = React.useState(false);
const [err, setErr] = React.useState('');
const [input, setInput] = React.useState('');
React.useEffect(() => {
const client = window._supabaseClient;
if (!client) { setSnap(null); return; }
client.from('live_investments').select('watch_urls').eq('ticker', ticker).limit(1).maybeSingle()
.then(({ data: row }) => setUrls((row && row.watch_urls) || []));
client.from('site_snapshots').select('data').eq('ticker', ticker).maybeSingle()
.then(({ data: row }) => setSnap((row && row.data) || null));
}, [ticker]);
const addUrl = async () => {
if (!roleCanManageTickers()) { setErr(DEMO_BLOCK_MSG); return; }
const u = input.trim();
if (!u || !/^https?:\/\//i.test(u)) { setErr('Paste a full URL (https://…)'); return; }
const client = window._supabaseClient;
const next = Array.from(new Set([...urls, u]));
const { data: { user } } = await client.auth.getUser();
await client.from('live_investments').update({ watch_urls: next }).eq('ticker', ticker);
setUrls(next); setInput(''); setErr('');
};
const removeUrl = async (u) => {
if (!roleCanManageTickers()) { setErr(DEMO_BLOCK_MSG); return; }
const client = window._supabaseClient;
const next = urls.filter((x) => x !== u);
const { data: { user } } = await client.auth.getUser();
await client.from('live_investments').update({ watch_urls: next }).eq('ticker', ticker);
setUrls(next);
};
const refresh = async () => {
const client = window._supabaseClient;
if (!roleCanResearch()) { setErr(DEMO_BLOCK_MSG); return; }
setRun(true); setErr('');
try {
const { data, error } = await client.functions.invoke('site-watch', { body: { ticker, company: investment.name || ticker } });
let payload = data;
if (error) { try { payload = await error.context.json(); } catch {} if (!payload || !payload.error) throw new Error(error.message || 'Edge function error'); }
if (payload && payload.error) { setErr(payload.error); return; }
setReport(payload.report || []);
setSnap((s) => ({ ...(s || {}), history: payload.history || (s && s.history) || [], fetched_at: payload.fetched_at }));
} catch (e) { setErr(e.message); }
finally { setRun(false); }
};
if (snap === undefined) return null;
const history = (snap && snap.history) || [];
const statusFor = (u) => (report || []).find((r) => r.url === u);
return (
{err &&
{err}
}
{/* watched urls */}
{urls.length === 0 ? (
Watch the company's own pages for change — leadership (exec departures), pricing (packaging moves), product/news (launch cadence). Add a page below.
) : (
{urls.map((u) => {
const st = statusFor(u);
const page = snap && snap.pages && snap.pages[u];
const lastChange = page && page.last_change;
return (
{u.replace(/^https?:\/\//, '')}
{st && {st.status.toUpperCase()} }
{roleCanManageTickers() && removeUrl(u)} style={{ background: 'none', border: 'none', cursor: 'pointer', color: tokens.inkMute, fontSize: '11px', padding: 0 }}>✕ }
{(st && st.status === 'changed' && st.summary) ? (
{st.summary} SIG {st.significance}/5
) : lastChange ? (
Last change {new Date(lastChange.at).toLocaleDateString()}: {lastChange.summary}
) : null}
);
})}
)}
{/* add url — owner + live demo only */}
{roleCanManageTickers() && (
＋ WATCH
)}
{/* change history */}
{history.length > 0 && (
CHANGE LOG
{history.slice(0, 8).map((h, i) => (
{new Date(h.at).toLocaleDateString()}
{h.summary}
))}
)}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// 02 · MARKET SIGNALS — weekly comp-sheet screening (MS EU Software & Services).
// Upload (or email-forward) the workbook → screens-intel parses it, runs the
// valuation regressions, scores the Finch Bay screen, and drafts top-3 ideas.
// ─────────────────────────────────────────────────────────────────────────────
const TAB_COLORS = { SW: '#0E0E0C', SVS: '#1A4FB5' };
const _pctf = (v, dp = 0) => v == null ? '—' : (v * 100).toFixed(dp) + '%';
const _xf = (v) => v == null ? '—' : v.toFixed(1) + 'x';
// SVG scatter with fitted line. Points carry {t, tab, x, y}; logY means y = ln(multiple).
const ScreenScatter = ({ reg, selected, onSelect }) => {
const W = 760, H = 420, P = { l: 54, r: 16, t: 14, b: 38 };
const pts = reg.points || [];
if (!pts.length) return null;
const xs = pts.map((p) => p.x), ys = pts.map((p) => p.y);
const xmin = Math.min(...xs), xmax = Math.max(...xs), ymin = Math.min(...ys), ymax = Math.max(...ys);
const xpad = (xmax - xmin) * 0.05 || 0.01, ypad = (ymax - ymin) * 0.06 || 0.1;
const X = (x) => P.l + (x - xmin + xpad) / (xmax - xmin + 2 * xpad) * (W - P.l - P.r);
const Y = (y) => H - P.b - (y - ymin + ypad) / (ymax - ymin + 2 * ypad) * (H - P.t - P.b);
// axis ticks
const xticks = [];
for (let i = 0; i <= 4; i++) xticks.push(xmin + (xmax - xmin) * i / 4);
let yticks;
if (reg.logY) {
yticks = [0.25, 0.5, 1, 2, 4, 8, 16, 32].filter((m) => Math.log(m) >= ymin - 0.05 && Math.log(m) <= ymax + 0.05)
.map((m) => ({ pos: Math.log(m), lab: m + 'x' }));
} else {
yticks = [];
for (let i = 0; i <= 4; i++) { const v = ymin + (ymax - ymin) * i / 4; yticks.push({ pos: v, lab: v.toFixed(0) + 'x' }); }
}
return (
{yticks.map((t, i) => (
{t.lab}
))}
{xticks.map((t, i) => (
{_pctf(t)}
))}
{/* fitted line */}
onSelect(sel ? null : p.t)}>
{p.t}
);
})}
{reg.xLabel.toUpperCase()}
{reg.yLabel.toUpperCase()}
);
};
const IdeaCard = ({ idea, rank }) => {
const [open, setOpen] = React.useState(rank === 0);
return (
setOpen((o) => !o)} style={{ display: 'flex', justifyContent: 'space-between', alignItems: 'baseline', cursor: 'pointer', gap: '10px' }}>
#{rank + 1}
{idea.name}
{idea.ticker}
{open ? '▾' : '▸'}
{open && (
{idea.why}
{idea.narrative && idea.narrative.length > 0 && (
MARKET NARRATIVE
{idea.narrative.map((n, i) =>
· {n}
)}
)}
{idea.questions && idea.questions.length > 0 && (
KEY QUESTIONS TO VALIDATE
{idea.questions.map((q, i) => (
{String(i + 1).padStart(2, '0')}
{q}
))}
)}
PROS
{(idea.pros || []).map((p, i) =>
+ {p}
)}
CONS
{(idea.cons || []).map((c, i) =>
− {c}
)}
)}
);
};
const ScreensPanel = () => {
const isMobile = useIsMobile();
const [snap, setSnap] = React.useState(undefined);
const [regId, setRegId] = React.useState('ro40_lnevs');
const [selected, setSelected] = React.useState(null);
const [busy, setBusy] = React.useState(false);
const [err, setErr] = React.useState('');
const fileRef = React.useRef(null);
const pollRef = React.useRef(null);
const load = React.useCallback(async () => {
const client = window._supabaseClient;
if (!client) { setSnap(null); return null; }
const { data: row } = await client.from('market_screens').select('data, fetched_at').eq('source', 'ms_eu_software').maybeSingle();
const d = (row && row.data) || null;
setSnap(d);
return d;
}, []);
React.useEffect(() => { load(); }, [load]);
// While ideas are still generating in the background, keep checking quietly.
React.useEffect(() => {
if (snap && snap.ideas_status === 'pending' && !pollRef.current) {
let tries = 0;
pollRef.current = setInterval(async () => {
const d = await load();
if (!d || d.ideas_status !== 'pending' || ++tries > 24) { clearInterval(pollRef.current); pollRef.current = null; }
}, 8000);
}
return () => { if (pollRef.current) { clearInterval(pollRef.current); pollRef.current = null; } };
}, [snap && snap.ideas_status, load]);
const upload = async (file) => {
if (!file) return;
if (!roleCanResearch()) { setErr(DEMO_BLOCK_MSG); return; }
setBusy(true); setErr('');
try {
const buf = await file.arrayBuffer();
let bin = ''; const u8 = new Uint8Array(buf);
for (let i = 0; i < u8.length; i += 0x8000) bin += String.fromCharCode.apply(null, u8.subarray(i, i + 0x8000));
const client = window._supabaseClient;
const since = new Date().toISOString();
const { data, error } = await client.functions.invoke('screens-intel', { body: { file_b64: btoa(bin), filename: file.name } });
let payload = data;
if (error) { try { payload = await error.context.json(); } catch {} if (!payload || !payload.error) throw new Error(error.message || 'Edge function error'); }
if (payload && payload.error) throw new Error(payload.error);
// Poll until the snapshot lands (parse is fast; ideas keep filling after).
const deadline = Date.now() + 3 * 60 * 1000;
while (Date.now() < deadline) {
await new Promise((r) => setTimeout(r, 4000));
const d = await load();
if (d && d.fetched_at && d.fetched_at >= since) {
if (d.error && d.error_at && d.error_at >= since) throw new Error(d.error);
return;
}
}
throw new Error('Parse timed out — reload in a minute.');
} catch (e) { setErr(e.message); }
finally { setBusy(false); if (fileRef.current) fileRef.current.value = ''; }
};
if (snap === undefined) return null;
const regs = (snap && snap.regressions) || [];
const reg = regs.find((r) => r.id === regId) || regs[0];
const rows = (snap && snap.rows) || [];
const byTicker = {}; rows.forEach((r) => { byTicker[r.ticker] = r; });
const selRow = selected ? byTicker[selected] : null;
const ranked = rows.filter((r) => r.score != null).sort((a, b) => b.score - a.score).slice(0, 14);
const ideas = (snap && snap.ideas) || [];
return (
fileRef.current && fileRef.current.click()} actionLabel={busy ? null : '⬆ UPLOAD XLSX'} running={busy}>
{err &&
{err}
}
{!snap || !rows.length ? (
No screen data yet.
⬆ UPLOAD XLSX with the weekly MS workbook — or just forward the Morgan Stanley email (with the attachment) to your ingest address with add_to_screens in the subject. Needs the screens-intel function deployed.
) : (
{/* regression picker */}
{regs.map((r) => (
setRegId(r.id)}
style={{ fontFamily: fontMono, fontSize: '10px', letterSpacing: '0.04em', padding: '6px 11px', cursor: 'pointer',
background: (reg && reg.id === r.id) ? tokens.ink : 'none', color: (reg && reg.id === r.id) ? tokens.paper : tokens.inkSoft,
border: `1px solid ${(reg && reg.id === r.id) ? tokens.ink : tokens.inkLine}` }}>
{r.label.split('—')[0].trim()} · R² {r.r2.toFixed(2)}
))}
{reg && (
{reg.label.toUpperCase()} · N={reg.n} · R²={reg.r2.toFixed(3)} · ● SOFTWARE ● IT SERVICES · CLICK A DOT
)}
{selRow && (
{selRow.name} {selRow.ticker} · {selRow.section}
{[['MCAP', selRow.mktcap != null ? `€${(selRow.mktcap / 1000).toFixed(1)}B` : '—'], ['G27', _pctf(selRow.g27, 1)], ['EBIT MGN', _pctf(selRow.m27, 1)], ['RO40', _pctf(selRow.ro40, 0)], ['EV/S 27', _xf(selRow.evs27)], ['EV/EBITDA 27', _xf(selRow.evebitda27)], ['FCF/EV', _pctf(selRow.fcfy27, 1)], ['GAP TO FIT', _pctf(selRow.gap, 0)], ['MS', `${selRow.rating || '—'} ${_pctf(selRow.upside, 0)}`]].map(([k, v]) => (
{k} {v}
)}
{/* screen ranking */}
FINCH BAY SCREEN · TOP RANKED (VALUATION GAP × QUALITY × MID-CAP FIT − LEVERAGE)
{['SCORE', 'COMPANY', 'MCAP', 'G27', 'RO40', 'EV/S 27', 'GAP TO FIT', 'ND/EBITDA', 'MS VIEW'].map((h) => (
{h}
))}
{ranked.map((r) => (
setSelected(selected === r.ticker ? null : r.ticker)}
style={{ display: 'grid', gridTemplateColumns: '44px 1.6fr 70px 64px 64px 70px 78px 64px 84px', gap: '8px', padding: '7px 0', borderBottom: `1px solid ${tokens.inkLineSoft}`, cursor: 'pointer', background: selected === r.ticker ? tokens.bgAlt : 'transparent', alignItems: 'baseline' }}>
{r.score}
{r.name} {r.ticker}
{r.mktcap != null ? `€${(r.mktcap / 1000).toFixed(1)}B` : '—'}
{_pctf(r.g27, 0)}
{_pctf(r.ro40, 0)}
{_xf(r.evs27)}
0 ? tokens.green : tokens.red }}>{_pctf(r.gap, 0)}
{r.ndebitda != null ? r.ndebitda.toFixed(1) : '—'}
{r.rating || '—'} {_pctf(r.upside, 0)}
))}
{/* idea candidates */}
TOP-3 IDEA CANDIDATES · CLAUDE × FINCH BAY PHILOSOPHY
{snap.ideas_status === 'pending' ? (
GENERATING IDEAS — this fills in within a minute or two…
) : snap.ideas_status === 'error' ? (
Idea generation failed: {snap.ideas_error}
) : ideas.length === 0 ? (
No ideas in this snapshot.
) : (
{ideas.map((idea, i) =>
)}
Screen + ideas are a starting point, not research — generated from the comp sheet without web access. Automate by forwarding the MS email (attachment included) to your ingest address with "add_to_screens" in the subject.
)}
);
};
// ─────────────────────────────────────────────────────────────────────────────
// Idea Database — the permanent, searchable archive of every idea generated
// across Section 02 (the MS comp screen + the AI Market Signals scan). Reads
// from `screen_ideas`; same card format as the freshly-generated ideas, plus
// provenance, free-text search, a source filter, and an owner workflow
// (★ star · verdict · notes) persisted back to the row.
// ─────────────────────────────────────────────────────────────────────────────
const formeCanWrite = () => (window.siteCanWrite ? window.siteCanWrite('forme') : roleCanResearch());
const GEN_LABELS = { ms_eu_software: 'MS SCREEN', ai_signals: 'AI SIGNALS', manual: 'MANUAL' };
const VERDICTS = [
{ id: 'pursuing', label: 'Pursuing', color: tokens.green },
{ id: 'watching', label: 'Watching', color: tokens.ochre },
{ id: 'passed', label: 'Passed', color: tokens.red },
];
const ArchiveIdeaCard = ({ idea, onPatch }) => {
const [open, setOpen] = React.useState(false);
const [notesOpen, setNotesOpen] = React.useState(false);
const [notes, setNotes] = React.useState(idea.notes || '');
const canWrite = formeCanWrite();
const m = idea.metrics || {};
const metricChips = [
m.mktcap != null && ['MCAP', `€${(m.mktcap / 1000).toFixed(1)}B`],
m.ro40 != null && ['RO40', _pctf(m.ro40, 0)],
m.gap != null && ['GAP', _pctf(m.gap, 0)],
m.evs27 != null && ['EV/S', _xf(m.evs27)],
].filter(Boolean);
const dt = idea.generated_at ? new Date(idea.generated_at).toLocaleDateString('en-US', { month: 'short', day: 'numeric', year: 'numeric' }) : '';
const star = () => canWrite && onPatch({ starred: !idea.starred });
const setVerdict = (v) => canWrite && onPatch({ verdict: idea.verdict === v ? null : v });
const saveNotes = () => { onPatch({ notes }); setNotesOpen(false); };
return (
setOpen((o) => !o)} style={{ cursor: 'pointer', minWidth: 0, flex: 1 }}>
{idea.name}
{idea.ticker &&
{idea.ticker} }
{GEN_LABELS[idea.generator] || idea.generator}
{dt}
{metricChips.map(([k, v]) => (
{k} {v}
{idea.starred ? '★' : '☆'}
setOpen((o) => !o)} style={{ cursor: 'pointer', fontFamily: fontMono, fontSize: '11px', color: tokens.inkMute }}>{open ? '▾' : '▸'}
{/* Verdict pills */}
{VERDICTS.map((v) => {
const on = idea.verdict === v.id;
return (
setVerdict(v.id)}
style={{ fontFamily: fontMono, fontSize: '9px', letterSpacing: '0.08em', padding: '3px 9px', cursor: canWrite ? 'pointer' : 'default',
border: `1px solid ${on ? v.color : tokens.inkLine}`, color: on ? tokens.paper : tokens.inkMute, background: on ? v.color : 'none' }}>
{v.label.toUpperCase()}
);
})}
{canWrite && (
setNotesOpen((n) => !n)} style={{ fontFamily: fontMono, fontSize: '9px', letterSpacing: '0.08em', padding: '3px 9px', cursor: 'pointer', border: `1px solid ${tokens.inkLine}`, color: idea.notes ? tokens.ink : tokens.inkMute }}>
{idea.notes ? '✎ NOTE' : '+ NOTE'}
)}
{notesOpen && (