# HOLDINGS_CLEAN Sunday Paste-Block
> **What this is:** Ready-to-paste rows for the MIS `HOLDINGS_CLEAN` tab. Sourced from Sam's broker screenshots May 14 2026 ~4:00 PM ET.
> **Cadence:** Run Sunday PM before MIS Week-Ahead fires (~6:05 PM ET).
> **Effort:** 5 minutes. Open MIS sheet → HOLDINGS_CLEAN tab → paste below.
> **Generated:** Thursday, May 14 2026 · 4:34 PM EDT (NY)

---

## ⚠ Before pasting — verify these in MIS sheet

1. **Confirm column schema** matches what's pasted below. Email format implies columns are: `Ticker | Qty | AvgCost | Account` (and possibly `EntryDate`). If actual sheet has different columns, reorder before paste.
2. **Confirm tickers are in MIS Tickers universe.** SCHG / SGOV / SCHZ may not be tracked. Add to Tickers tab first if missing (Sam: these are bond/cash-equivalent ETFs, optional to add but if you want them on dashboards they need to exist in Tickers).
3. **Decide consolidation policy.** Two options:
   - **Per-lot** (one row per ticker+account): preserves cost-basis truth, lets MIS see the −35% ORCL lot separately
   - **Consolidated** (one row per ticker, weighted avg): matches MIS's current style but hides the broken lots
   - **Recommended: Per-lot.** ORCL needs to be two rows so the broken lot generates a REDUCE/EXIT signal once that logic is wired.

---

## ROWS TO PASTE (per-lot format — 19 rows, 4 accounts)

```
Ticker  | Qty     | AvgCost  | Account                      | Notes
SPY     | 10.000  | 647.63   | Fidelity Invest n Save 0600  | already in MIS (consolidated)
SPY     | 0.954   | 682.69   | Fidelity Joint Brok 5692     | already in MIS (consolidated)
META    | 10.351  | 573.26   | Fidelity Invest n Save 0600  | UPDATE: MIS currently shows 8.25 — wrong
META    | 0.455   | 666.20   | Fidelity Joint Brok 5692     | ADD: MIS lost this lot between Mon and Thu
ASML    | 4.007   | 1309.89  | Fidelity Invest n Save 0600  | already in MIS
ABBV    | 17.000  | 208.75   | Fidelity Invest n Save 0600  | ADD: MIS doesn't see this; #2 position $3.6K
COST    | 2.003   | 903.28   | Fidelity Invest n Save 0600  | ADD: MIS doesn't see; MIS recommended ADD today (oops)
KO      | 6.086   | 68.43    | Fidelity Invest n Save 0600  | ADD: MIS doesn't see; MIS recommended ADD today (oops)
ORCL    | 0.847   | 301.07   | Fidelity Invest n Save 0600  | ADD: this is the −35% loser lot, currently invisible
ORCL    | 1.267   | 205.72   | Fidelity Joint Brok 5692     | already in MIS (this is the lot it sees)
GOOG    | 0.087   | 319.77   | Fidelity Invest n Save 0600  | ADD: sliver, optional
SCHG    | 6.169   | 32.42    | Fidelity Joint Brok 5692     | ADD: Schwab Large-Cap Growth ETF (verify in Tickers universe)
SCHZ    | 21.376  | 23.39    | Fidelity Joint Brok 5692     | ADD: Schwab US Agg Bond ETF (verify in Tickers universe)
SGOV    | 3.000   | 100.57   | Fidelity Joint Brok 5692     | ADD: iShares 0-3M T-bill ETF (verify in Tickers universe)
EQIX    | 0.406   | 984.51   | Fidelity Joint Brok 5692     | already in MIS
AAPL    | 1.338   | 277.56   | Fidelity Joint Brok 5692     | already in MIS
LLY     | 0.781   | 967.57   | Fidelity Joint Brok 5692     | already in MIS
AMZN    | 1.190   | 210.46   | Fidelity Joint Brok 5692     | already in MIS
BA      | 2.000   | 238.85   | Schwab ZT Acct               | ADD: cost basis computed from G/L (−$18.34/−3.84% on $459.36)
UNG     | 24.000  | 11.07    | Schwab ZT Acct               | ADD: cost basis computed from G/L (+$2.28/+0.86% on $267.84)
SLV     | 7.000   | 76.70    | Schwab ZT Acct               | ADD: cost basis computed from G/L (−$9.48/−1.77% on $527.45)
ABNB    | 1.000   | 141.83   | Schwab SWPF                  | ADD: cost basis computed from G/L (−$7.76/−5.47% on $134.07)
AFRM    | 15.000  | 50.78    | Schwab 898                   | already in MIS (verify account ending matches ZT or SWPF or third)
DAL     | 3.000   | 63.76    | Schwab 898                   | already in MIS
```

> **22 rows total** (per-lot). Of these: **9 are NEW additions**, **2 are corrections** (META qty + ORCL lot split), **11 are already in MIS** (re-paste fine, or leave them and just add the missing ones).

---

## Cash positions (separate — not equity holdings, but worth tracking)

| Account | Cash |
|---|---|
| Fidelity Joint Brok ****5692 | $188.41 (held in MM) |
| Schwab ZT Acct | $36.07 |
| Schwab SWPF | $8.17 |
| **Total dry powder** | **$232.65** |

> **Pending activity in Fidelity Invest n Save: −$10,934.76** — outflow being processed. Verify what this is (Zelle out? Funding Joint? Bank transfer? William Penn $596 payment? Other?). If it's a real outflow, the position values won't drop — that money is leaving the account, not being deployed.

---

## Computed totals for sanity check

| Account | Mkt Value | Position $ sum | Cash | Pending |
|---|---|---|---|---|
| Fidelity Invest n Save | $15,662.71 | $26,597.47 (positions) | — | −$10,934.76 (pending out) |
| Fidelity Joint Brok | $4,382.54 | $4,194.13 | $188.41 | — |
| Schwab ZT Acct | $1,290.65 | $1,254.65 | $36.07 | — |
| Schwab SWPF | $142.24 | $134.07 | $8.17 | — |
| **Grand total** | **$21,478.14** | **$32,180.32** | **$232.65** | **−$10,934.76** |

> Math check: $26,597.47 + $188.41 − $10,934.76 = $15,851.12. Fidelity Invest n Save shows $15,662.71. Difference of $188.41 — that's the cash held in MM in the Joint screenshot. Likely a quirk of how "Account total" is computed when "Pending activity" includes cash routing. **Verify with Sam.**

---

## After paste — confirm MIS is now seeing it

Run a one-off Morning Brief manually (or wait for tomorrow's 9:47 AM fire). Look at the `--- 💼 YOUR HOLDINGS (live) ---` section. It should now show 22 rows instead of 10. Specifically:

- ABBV with entry $208.75 ✓
- COST with entry $903.28 ✓ (and COST should be DROPPED from the ADD list since you hold it — IF the PORTFOLIO_OVERLAP gate is wired; it isn't yet, see Issue #N)
- ORCL appearing twice (or as a weighted avg around $244, depending on consolidation rule)
- META showing qty 10.806 instead of 8.25

If MIS still shows 10 rows, the paste didn't take or the column schema didn't match. Re-verify before next session.

---

## Source trail
- This file: `/home/user/hookstreet-workspace/outputs/2026-05-14_16-34_action_holdings-clean-paste-block.md`
- Sourced from: Sam's 4 broker screenshots (May 14 2026 3:58-4:05 PM ET, in chat with cloud-Claude)
- Companion: `outputs/2026-05-14_16-34_handoff_mis-holdings-session.md` (full session handoff)
- Target sheet: MIS sheet ID `1cosuFrU_EJRAprVMm-FEpmddSUTVQWhlI0tHpS1w2S4` → `HOLDINGS_CLEAN` tab