How to Set Quarterly Rebalancing Rules in Your Sheet So Winners Do Not Eat Your Whole Portfolio
Most retail rebalancing decisions fail because they are made in the moment, on a single hot streak, and never written down. A position that grew from 4 percent to 18 percent feels earned the first time and reckless the third. The fix is a one-time setup in your spreadsheet that runs the same rebalancing rules every quarter.
Most retail rebalancing decisions fail because they are made in the moment, on a single hot streak, and never written down. A position that grew from 4 percent to 18 percent feels earned the first time and reckless the third. Without a written rule, your rebalancing changes with how the winner has been performing, with how the news cycle sounds, and with how much you slept the night before. The fix is a one-time setup that runs the same rebalancing rules every quarter, regardless of how the winners feel that month.
The sizing rule sets the ceiling. Rebalancing enforces it.
On Wednesday we walked through a buy-the-dip trigger — the rule that fires when a name you already own drops a fixed percent from its 30-day high. On Thursday we walked through a stop-loss trigger — the rule that fires when a name you already own drops a fixed percent from your entry cost. On Friday we walked through a position-sizing rule — the rule that caps how big any single name can become when you buy it. Today the rebalancing rule closes the loop.
Sizing is the ceiling at the buy. Rebalancing is the ceiling at the quarterly review. The two rules work as a pair: a portfolio with sizing but no rebalancing still drifts into a single name dominating the book, because the winners keep winning and the losers keep losing. The drift is invisible day-to-day and obvious at the end of the quarter. The rebalancing rule fires once a quarter and brings every position back inside the target band, regardless of how the winners feel that month.
The rebalancing model
Every row in your sheet represents one open position. The rebalancing cell in that row tells you whether the position is at target, above target (trim), or below target (add). The rule has to be a single formula that returns one of three states, because a rule that requires you to interpret anything is a rule you will not run consistently.
=IFS( IVS_BROKERAGE("value","AAPL") / IVS_BROKERAGE("value","ALL") > 0.06, "TRIM — sell back to 4% target", IVS_BROKERAGE("value","AAPL") / IVS_BROKERAGE("value","ALL") < 0.02, "ADD — buy up to 4% target", TRUE, "OK — within band" )Read it left to right. If the position is more than 6 percent of your total portfolio, the cell prints TRIM — sell back to 4% target. If the position is less than 2 percent of total, the cell prints ADD — buy up to 4% target. Otherwise it prints OK — within band. The rule fires on the same condition every quarter. There is no judgment for you to apply on the day.
Four rules that make a rebalancing rule work
Rule 1: rebalance on a fixed calendar date, not on a market event. The mistake most retail investors make is rebalancing after a sharp move. That ties rebalancing to the news cycle and turns the rule into a mood-driven decision. Pick a fixed date — the first Monday of each calendar quarter is the most common choice — and rebalance every position on that date, regardless of what the market did the week before. The calendar removes the emotion.
Rule 2: target band is 4 percent plus or minus 2 percent, per name. The band matters more than the center. A 4 percent target with a 2 percent band means positions between 2 and 6 percent trigger nothing. Positions above 6 percent trigger a trim. Positions below 2 percent trigger an add. The band gives winners room to run without drifting into the position-sizing ceiling, and gives losers room to recover without missing the add-back signal.
Rule 3: rebalance with a market-on-open order, not intraday. The hardest part of any rebalancing rule is the gap between seeing the trigger fire and pressing the trade. The natural temptation is to wait for confirmation that the winner has stopped running, which is the same as waiting for the price to drop before you trim. The rule closes that gap by executing at the next session open, the same way the stop-loss rule closes the panic-execution gap. Slippage is small. The avoided regret is large.
Rule 4: rebalance the additions and trims on the same day, not separately. The mistake most retail investors make is trimming winners into cash, then waiting to add to losers over the following days. The cash sits idle. The winners run further. The losers drift further. The next rebalancing date arrives with the portfolio more concentrated than before. The rule closes that gap by ordering both halves of the rebalance on the same market-on-open, so the cash from the trim funds the add without sitting idle for a single day.
What this changes
The first time the rebalancing rule fires, you feel the friction. You hold a position that is 7 percent of your portfolio and the cell prints TRIM. You sell the excess at the next session open. The spreadsheet logs the trade and the target row is reset to 4.0 percent. The next time the rule fires, you feel less. The third time, you feel almost nothing. You execute because the rule says to, and the math does the work that the conviction used to do.
That is the whole point. Rebalancing removes the fourth-largest source of retail investing error: letting winners run until they dominate the portfolio. The buy-dip rule from Wednesday handles the first source. The stop-loss rule from Thursday handles the second. The sizing rule from Friday handles the third. Together with the rebalancing rule from today, you have a complete loop. Build the four rules once. Run them forever. The spreadsheet stays out of the news cycle so you can.
InvestSheet syncs Fidelity, Schwab, Robinhood, Vanguard, and other major brokerages into a single Google Sheet with live formulas for value, price, and current allocation across every account. The buy-dip trigger, the stop-loss trigger, the sizing rule, and the quarterly rebalancing rule all run on the same row. Set up all four rules in 30 minutes today and let the spreadsheet run the portfolio.
Frequently asked questions
What is the difference between rebalancing and the position-sizing rule from yesterday?
Position sizing (Aug 1) is the rule you apply before the trade — it caps how big any single name can become when you buy it. Rebalancing is the rule you apply every quarter — it brings the position back to the cap when the winners drift past it. The two rules work as a pair: sizing sets the ceiling at the buy, rebalancing enforces the ceiling at the quarterly review. A portfolio with sizing but no rebalancing will still drift into a single name dominating the book.
How often should I rebalance a retail portfolio?
Quarterly is the right cadence for most retail portfolios with 8 to 40 individual names. Monthly rebalancing adds transaction costs and tax friction without improving outcomes. Annual rebalancing lets winners drift too far before the correction. The first Monday of each calendar quarter (Jan, Apr, Jul, Oct) is the most common choice because the date is easy to remember and it coincides with mutual fund distribution cycles.
What is the difference between rebalancing and the buy-the-dip trigger?
A buy-dip trigger fires when an existing position drops a fixed percent from its 30-day high and tells you to add to it. Rebalancing fires when an existing position grows above its target band and tells you to trim. The two rules operate at opposite ends of the same band — buy-dip adds on weakness, rebalancing trims on strength. Together they enforce a target band per position without you having to make either decision in the moment.
See your full portfolio across every brokerage in one Google Sheet
InvestSheet syncs Fidelity, Schwab, Robinhood, Vanguard, and other brokerages into a single Google Sheet with live formulas for value, price, and current allocation across every account. The buy-dip trigger, the stop-loss trigger, the sizing rule, and the quarterly rebalancing rule all run on the same row. Free 14-day trial with card upfront, no contract.
See pricing