Q3 2026 Portfolio Tactics — 5 Setups to Run in Your Sheet on the First Monday of the Quarter

The first Monday of any quarter is when three calendars collide — earnings pre-announce dates, dividend ex-dates, and pension rebalancing flows. Investors who do a 20-minute setup pass on this date tend to spend less time in panic rebuilds by late September. Here is the same five-step checklist we run on the first Monday of every quarter, built around the formulas you already have in your InvestSheet.

1. Snapshot your full portfolio across every brokerage

The single biggest blind spot in any DIY portfolio is the gap between what you think you own and what you actually own across Fidelity, Schwab, Robinhood, Vanguard, your 401(k), and your HSA. The first setup step is to refresh all synced brokerages and pull the total portfolio value into a single cell:

=IVS_BROKERAGE("value")

That returns one number — your full net worth across every connected account, refreshed this morning. Pair it with:

=IVS_BROKERAGE("gainLoss")

The delta between those two cells is your unrealized gain. Whatever it is — positive, negative, or somewhere in between — that is your starting point for every other decision this quarter.

2. Identify mid-cap exposure and the rotation question

Through the first half of 2026, the S&P 500 returned roughly 33 percent from the March low. The Russell 2000 and the S&P MidCap 400 returned closer to 14 percent over the same window. When large-cap leadership gets this concentrated, mid-caps historically take the leadership baton for the next two to three quarters. Q3 is the typical rotation window.

The right question is not whether mid-caps will catch up. It is: do you already own any, and at what cost basis? Add an IVS_BROKERAGE call for any mid-cap ETF you hold — IJH, VO, MDY:

=IVS_BROKERAGE("costBasis", "IJH")

Compare that to the current value with =IVS_BROKERAGE("value", "IJH"). If the cost basis is higher than the value, the rotation trade is already in your favor — you can add to a position that is under water without taking new risk.

3. Audit overlap inside your "diversified" funds

The S&P 500 top ten names now account for more than 40 percent of the index by weight, and every one of them is a technology or AI-focused company. The Vanguard S&P 500 ETF (VOO) holds 39 percent in technology. The total market ETF holds 42 percent. When three of your "diversified" funds all hold the same ten names, you do not have three positions — you have one position, multiplied. The fix is to expose it.

Run =IVS_BROKERAGE("value") to get the total, then for each large-cap fund you hold, get the dollar value of any single top-ten name across every account. A good rule of thumb: any underlying ticker that ends up above 5 percent of your full net worth is concentrated, regardless of which fund delivered it.

4. Pull the ex-dividend calendar through August

Three-week window starting in early August: a long list of large-cap names go ex-dividend. Capture requires owning the stock one day before the ex-date. The mistake most retail investors make is selling between the record date and the payable date and accidentally handing the dividend back.

Pull your full holdings list, sort by ex-date, and mark which positions are still long the day before each ex-date. Anything you sold between record date and ex-date in past years is a fixable tax-drag pattern, not a market call.

5. Lock your cost basis before earnings season opens

Earnings season opens in three weeks with the big banks. By the second week of August, fourteen percent of the S&P 500 by weight will have reported. Any position you are ambiguous about — held at a cost you cannot recall, with a stop you have not set — is a position that will get panicked during the first reaction print.

Export your cost basis today with =IVS_BROKERAGE("costBasis"). Lock it in a separate sheet. The point is not to have a model — it is to have the number you would type into a panic email to your own future self.

The whole checklist runs in twenty minutes

That is the whole Q3 setup. Five steps, all of them built on top of formulas you already have, all of them running against the same Google Sheet you already use. The payoff is not that the rest of the quarter becomes effortless — it is that the next time the market gives you a 2 percent down day, you are starting from a known position list rather than rediscovering your own portfolio.

InvestSheet syncs Fidelity, Schwab, Robinhood, Vanguard, and other major brokerages into a single Google Sheet, with built-in cost basis, gain/loss, and ex-dividend tracking that makes this checklist a 20-minute Monday ritual rather than a Saturday rebuild.

Frequently asked questions

See your full portfolio in one Google Sheet

InvestSheet syncs Fidelity, Schwab, Robinhood, Vanguard, and other brokerages into a single Google Sheet with live formulas for value, cost basis, gain or loss, and ex-dividend tracking across every account. Free 14-day trial with card upfront, no contract.