Baby Steps: Test 3PM Email + Test PWA Endpoint

🧪 Baby Steps — Test the New 3PM Email + Test the PWA

Generated: Wed May 6 2026 · 6:44 PM EDT (NY) · Session 26 close · Code pushed to V11 ✓

Repo: zee78900/MIS @ 7996607 · Workspace: zee78900/hookstreet-workspace @ 1ce3cc8 · clasp pushed to V11 6:44 PM

Step 1. Open V11 sheet:
https://docs.google.com/spreadsheets/d/1HEmRevZZZmpXEnjkkwxIw0VetEjFVe5ZxVYzu4hgo2c/edit

Step 2. Click the Control tab at the bottom. Find the row where column A says LAST_POWER_HOUR_DATE. Delete the value in column B (just clear the cell). This unblocks the manual fire — otherwise it'll skip "already sent today."

Step 3. Top menu: Extensions → Apps Script. New tab opens.

Step 4. In the script editor, top toolbar has a function dropdown. Click it → choose misSendPowerHour300 → click ▶ Run.

First run may ask permission ("This app isn't verified") → click "Advanced" → "Go to (unsafe)" → "Allow." That's normal for your own scripts.

Step 5. Wait ~30 seconds. Look at the bottom panel ("Execution log") — should show "Execution completed."

Step 6. Open Gmail / Outlook iOS / wherever you read it. New email from yourself: "🚀 3:00 PM MIS Power Hour". Open it.

What's new (the 4 things to look for):

💼 YOUR HOLDINGS (LIVE) card grid — sits right under the dark blue regime header (above Macro Pulse). 4 cards per row, each showing ticker / current price / colored ↑ or ↓ today % / entry$ + qty in grey.
↑↓ Direction arrows on every Lean In / Watch / Starter row — leads each line.
📊 Holdings sorted by |P&L%| desc — biggest movers first, not alphabetical.
🚫 Phantom filter — only kicks in if you also do §1.5 below. Without it, AVGO/COST/VOO/PYPL/SCHZ/KO will still show.

Step 1.5 (optional, makes phantoms disappear — 5 min):
Open C:\Users\ztrei\OneDrive\2. Hook Street\05. 2026 BH\MIS\data\Trade_Planner_Replacement.csv in Notepad → Ctrl+A → Ctrl+C.
In V11 sheet → right-click any tab → "Insert sheet" → name it exactly Trade_Log_Imported → click cell A1 → Ctrl+V.
Then redo §1 (clear LAST_POWER_HOUR_DATE → run again). This time only the 13 real positions show; phantoms gone.

The PWA reads from 4 sheets: Monthly Obligations v1 (just flipped from v2), Command Center, MIS V11, Quick Capture. To test that it's actually wired up before you have an iPad in hand, deploy the Apps Script as a Web App and hit the endpoints in your browser.

Step 1. Open the PWA Apps Script. Go to script.google.com/home.

Step 2. If a project named Hook Street OS API (or similar) already exists, click it. If not — that means the kickoff hasn't been deployed yet. Stop here and ping me — we need to first push ~hookstreet-workspace/Code.gs to a fresh Apps Script project. (~10 min one-time.)

Step 3. Top right: Deploy → New deployment → Web app. Description: "Test v1." Execute as: Me. Who has access: Anyone with the link (we'll lock down later via API key). Click Deploy.

Step 4. Copy the Web App URL. Looks like
https://script.google.com/macros/s/AKfyc...../exec

Step 5. In your browser, paste the URL with ?route=health&key=CHANGE_THIS_TO_A_LONG_RANDOM_STRING appended. Should return:
{"status":"ok","timestamp":"..."}
That's the heartbeat — proves the endpoint is alive.

Step 6. Now test the v1 obligations read:
[your-url]?route=obligations&days=14&key=CHANGE_THIS_TO_A_LONG_RANDOM_STRING
Should return JSON with the next 14 days of obligations from v1 (the canonical sheet). If it returns the v2 obligations (or an empty array), the sheet flip didn't take — let me know.

Important: the API key is currently the literal string CHANGE_THIS_TO_A_LONG_RANDOM_STRING. Before deploying for real, we change that to something private. For test-only it's fine.

The frontend is ~hookstreet-workspace/hookstreet-os-app.html. To open it on iPad:

Option A (quickest, 3 min) — drop on Netlify
1. Drag hookstreet-os-app.html into app.netlify.com/drop.
2. Netlify hands you a URL like https://random-name.netlify.app.
3. On iPad, open that URL in Safari → tap Share → "Add to Home Screen." Now it's an icon. Behaves like an app.
4. The HTML asks for the API URL + key on first load. Paste the URL from §2 Step 4 + the API key.

Option B (cleaner, ~10 min) — host on GitHub Pages on a subpath of zee78900.github.io
That'd put it at zee78900.github.io/hookstreet-os/. Walk through next session if you want.

Heads-up: the PWA expects the API key to be passed in every request. The default in Code.gs is the literal placeholder. Before wider use we change it to something private + verify CORS is permissive.