Explainer
How to read the weekly levels sheet
By AP's Morning Brief · Editor: AP Dult · October 26, 2026
The free levels sheet is a one-page reference for three funds: SPY (an S&P 500 ETF), QQQ (a Nasdaq-100 ETF) and TQQQ (a fund that targets 3x the daily move of the Nasdaq-100). It records where each traded last week, so you have reference points ready before Monday's open. It doesn't predict where they'll go.
The columns
| Column | What it is |
|---|---|
| Prior-week high | The highest price the fund traded at during the previous Monday-to-Friday week. |
| Prior-week low | The lowest price it traded at during that week. |
| Fri close | The official closing price on the last trading day of that week. |
| Wk/wk % | The week-over-week change: (Fri close ÷ the previous Friday's close − 1) × 100. |
| Mon open / pre-market | Monday's opening price or, if the sheet goes out before the open, the latest pre-market quote, with the time it was taken. |
| Source | Where each number came from, so you can check it yourself. |
| Pulled (CST) | The time the data was collected, in Central Standard Time. Prices move; a number is only as current as its pull time. |
Rates and the calendar
The sheet also lists the U.S. 10-year Treasury yield from FRED series DGS10 ("Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity, Quoted on an Investment Basis"), the federal funds target range from the Federal Reserve, and the week's scheduled events with times in CST. DGS10 is a daily series, so it reflects the most recent business day FRED has published, not a live quote.
The rules we follow
- No targets or forecasts. The sheet records past prices only.
- "n/a" beats a guess. If a figure can't be sourced, it's marked n/a rather than estimated.
- Every number has a source and a time.
How readers use reference levels
Many traders watch a prior week's high, low and close because other market participants watch them too. A price moving back toward one of those levels is a fact you can see; what happens next is not something the sheet tells you. Using a level as a plan, for example knowing in advance where you'd exit, is different from treating it as a prediction.
TQQQ's levels move about three times as much as QQQ's on a given day, by design. Read leveraged ETF decay, explained before comparing them over a whole week.