Guide
How to Calculate Portfolio Drift (and Rebalance Without Spreadsheets)
The complete guide to understanding drift, risk, and how to rebalance without the spreadsheet headache.
What you’ll learn
How to calculate drift, why it matters, and how to use new cash to rebalance without selling.
Who this is for
DIY investors using spreadsheets, eyeballing allocations, or manually tracking portfolios.
Why it matters
Drift quietly changes your risk over time, especially after strong market moves.
Most people think their portfolio is balanced.
It usually isn’t.
You set a 60/40 split. Maybe you checked it once. Then markets moved, and now... who knows.
That quiet shift is called portfolio drift - and it’s one of the most overlooked risks in investing.
What Is Portfolio Drift?
Portfolio drift is the difference between your target asset allocation and your actual allocation.
- Target: 60% stocks / 40% bonds
- Actual: 70% stocks / 30% bonds
You didn’t decide to take more risk. It just happened.
Markets move. Some assets outperform others. Over time, your portfolio drifts away from your original plan.
Why Portfolio Drift Actually Matters
This isn’t just a technical detail. It changes your risk - sometimes a lot.
Let’s say you have a $100,000 portfolio:
| Allocation | Target | Actual |
|---|---|---|
| Stocks | 60% ($60,000) | 70% ($70,000) |
| Bonds | 40% ($40,000) | 30% ($30,000) |
Key takeaway
+10% overweight
+$10,000 above target
Why this matters
Drift doesn’t just change your numbers - it changes your exposure.
You’re now taking significantly more equity risk than you planned.
If your 60/40 drifts to 75/25 during a strong market, it feels great... until it doesn’t.
You’re not just “winning” - you’re now taking more downside risk when the market corrects.
Most investors only notice this after the drop, not before it.
How to Calculate Portfolio Drift (Step-by-Step)
You don’t need anything complicated. Just three numbers:
Drift formula
Drift = Actual% - Target%
Rebalance Amount = (Total Portfolio × Target%) - Current Value
- Total portfolio value
- Target allocation
- Current allocation
Step 1 - Calculate Target Value
Take your total portfolio and multiply by your target percentage.
- Portfolio: $100,000
- Target stocks: 60%
Target stock value = $60,000
Step 2 - Find Current Value
Let’s say your current stock value is $70,000.
Step 3 - Calculate the Difference
- Difference = $70,000 - $60,000 = +$10,000
- Drift = +10%
Positive = overweight
Negative = underweight
The Problem: This Gets Messy Fast
This works fine with 2 assets.
But what if you have:
- multiple ETFs
- ongoing contributions
- dividends
- different accounts
Now you’re doing:
- multiple calculations
- constant updates
- fixing broken spreadsheets
This is where most people give up.
The Spreadsheet Problem
A lot of investors try to solve this with Excel.
It works... until it doesn’t.
- formulas break
- adding new cash throws everything off
- updates get skipped
- it becomes too annoying
So what happens?
You stop tracking drift.
And your portfolio quietly moves further away from your plan.
A Simpler Way to Track Portfolio Drift
Instead of rebuilding calculations every time, you just need:
- your current portfolio values
- your target allocation
From there, the only thing that matters is how far off you are - in % and dollars.
That’s it.
Most tools want you to connect your accounts and sync everything automatically.
That sounds convenient - but it also means giving access to your financial data and relying on syncing.
Alignfolio takes a different approach.
You enter your numbers manually.
It takes a minute, but you stay connected to your portfolio and avoid noise, syncing errors, and security trade-offs.
Privacy first
We don’t ask for your bank login credentials. Your portfolio data stays manual, simple, and under your control.
Real Example (What Most People Miss)
Let’s say you have:
- US Equity: 60% target
- International: 30% target
- Bonds: 10% target
Portfolio value: $100,000
After a strong market run:
- US Equity: $72,000
- International: $20,000
- Bonds: $8,000
Now:
- US Equity → +12% overweight (+$12,000)
- International → -10% underweight (-$10,000)
- Bonds → -2% underweight (-$2,000)
This is no longer a balanced portfolio.
It’s a much more aggressive one.
And most people don’t notice this shift.
After Rebalancing Using $10,000 of New Cash
| Allocation | Target | Before | After |
|---|---|---|---|
| US Equity | 60% | 72% ($72,000) | 65% ($72,000) |
| International | 30% | 20% ($20,000) | 25% ($28,000) |
| Bonds | 10% | 8% ($8,000) | 10% ($10,000) |
You didn’t sell anything.
You just used new cash to move back toward your target.
See how your own portfolio looks with drift calculated automatically
Use the demo dashboard to see drift in percentages and dollars without building or maintaining a spreadsheet.
When Should You Rebalance Your Portfolio?
There’s no perfect rule, but these work well:
Threshold-based
- 3% → small drift
- 5-7% → meaningful drift
- 7%+ → significant drift
Time-based
- quarterly
- semi-annually
What If You Have New Cash to Invest?
This is where most investors get stuck.
You don’t always need to sell to rebalance a portfolio.
Often, the simplest approach is using new cash correctly.
Case 1 - Your Portfolio Is Unbalanced
- US Equity → +$12,000 overweight
- International → -$10,000 underweight
- Bonds → -$2,000 underweight
You have $10,000 to invest.
Rule: Don’t add to what’s already overweight.
Instead:
- $8,000 → International
- $2,000 → Bonds
You move closer to your target without selling anything.
Case 2 - Your Portfolio Is Balanced
Everything is aligned.
Just invest according to your target allocation:
- $6,000 → US Equity
- $3,000 → International
- $1,000 → Bonds
Case 3 - Small Drift
- US Equity → +3%
- International → -2%
- Bonds → -1%
No need to sell.
Direct new cash to underweight assets.
Why This Approach Works
Experienced investors usually:
- avoid unnecessary selling
- rebalance with new contributions
- keep the process simple
- potentially reduce taxes by avoiding capital gains from selling winners
It’s easier and often more tax-efficient.
The Missing Piece for Most Investors
Most tools overcomplicate rebalancing.
They tell you what to sell.
What people actually want
“I have $2,000. What should I buy?”
Alignfolio answers this in seconds, not hours.
Common Mistakes Investors Make
“It’s probably close enough”
It usually isn’t.
Only looking at percentages
Dollars matter more than people think.
Overcomplicating it
You don’t need complex tools.
Ignoring drift during strong markets
This is when risk quietly increases.
The Goal Isn’t Perfection
You don’t need perfect alignment.
You need:
- awareness
- a simple system
- consistency
Skip the Spreadsheet
If you’re:
- using Excel
- guessing allocations
- not tracking drift
There’s a simpler way.
View the demo dashboard and see exactly how your portfolio looks with drift calculated automatically
No account syncing. No spreadsheet maintenance. Just a clear view of what is overweight, underweight, and off target.
Frequently Asked Questions About Portfolio Drift
What is portfolio drift?
Portfolio drift is the difference between your target allocation and your current allocation caused by market movements over time.
How do you rebalance a portfolio?
You can rebalance by selling overweight assets and buying underweight ones, or by directing new cash into underweight assets.
Can you rebalance a portfolio without selling?
Yes. Many investors rebalance by investing new cash into underweight assets instead of selling existing holdings.
How often should you rebalance a portfolio?
Most investors rebalance quarterly, annually, or when allocations drift more than 5-7% from target.
Still have questions? See our FAQ.
Final Thought
Portfolio drift is quiet.
It slowly changes your risk without you noticing.
Most investors ignore it.
The ones who track it have a real advantage.