Sprint 2 — vW2 — What Must You Do
Your team formed today. This is what happens between now and next Monday, and what you'll present when you come back.
The Sprint Goal
This is deliberate. You'll feel exactly where the manual work gets repetitive and painful — that feeling is the reason automation gets introduced next, and it'll make far more sense once you've felt the problem it solves.
The Backlog — Four Things, By Hand
Track the weekly OHLC (open/high/low/close) for every one of these — not a subset:
- SPX (S&P 500) and NDX (Nasdaq 100)
- 10-Year Treasury Yield
- Gold and Bitcoin
- All 11 sector ETFs: Technology (XLK), Financials (XLF), Energy (XLE), Health Care (XLV), Consumer Discretionary (XLY), Consumer Staples (XLP), Industrials (XLI), Materials (XLB), Utilities (XLU), Real Estate (XLRE), Communication Services (XLC)
Where to get this data — step by step:
- Go to finance.yahoo.com — free, no account needed.
- Type the ticker into the search bar at the top (e.g.
^GSPCfor SPX,^NDXfor NDX,^TNXfor the 10-year yield,GC=Ffor gold,BTC-USDfor Bitcoin, or the sector ETF ticker directly, e.g.XLK). - Click the correct result to open that instrument's page.
- Click the "Historical Data" tab (near the top of the page, next to "Chart").
- Set the date range to this week, then read off the Open, High, Low, and Close columns for each trading day.
- Repeat for every ticker in the list above. Sixteen lookups total (5 index/asset tickers + 11 sector ETFs) — this is the actual manual pain the task is designed to make you feel.
Pick three of the sector ETFs you already pulled OHLC for in Task 1. For each, calculate its weekly % change (Friday close vs. last Friday's close), then compare that against SPX's weekly % change — the number you also already have. A sector "beat the market" if its % change is higher than SPX's, and "lagged" if lower.
Find three pieces of macroeconomic news or data released this week (Fed commentary, inflation data, jobs numbers, anything market-relevant) and note what each was and how markets reacted.
Using the Almanac Agent guide, find two seasonal or calendar-driven patterns relevant to this week (a monthly pattern, a specific day/week pattern, a sector seasonality window, an upcoming event). This is likely your first time reading an Almanac — the guide teaches you how.
Then: Write It Up and Present
Presentation Order — Monday 21 Sep
reports/vW2.md file, your slides — needs to be committed and ready by Sunday 20 Sep. Monday is presentation day, not build day. Nothing gets assembled live in class.