The Portfolio DCA Builder: A Guide to Multi-Asset Backtesting

"Don't put all your eggs in one basket" is the oldest piece of finance advice in existence. It's also, in practice, one of the most ignored. Most retail DCA investors run a single-asset strategy — just Bitcoin, or just the S&P 500, or just a single growth stock — and accept whatever volatility that asset happens to deliver. The math says they're leaving something on the table.

That "something" has a name. It's the diversification dividend: when you hold assets that aren't perfectly correlated, the volatility of the combined portfolio is less than the weighted average of the individual volatilities. Returns are weighted averages. Risk is not. This is one of the few genuinely free lunches in investing, and it shows up clearly in historical data once you actually run the numbers.

The Portfolio DCA Builder is built for exactly that — running the numbers. It lets you define an allocation across up to 18 supported assets, A/B test it against alternative mixes on the same date range, and see what the diversification math has actually delivered across the available history. This post walks through how it works, a few worked scenarios, and the traps to watch for when you start reading the output.

What the calculator does

The Portfolio DCA Builder takes a list of asset rows. Each row has an asset picker — choose from 7 cryptocurrencies, 9 stocks and ETFs (AAPL, MSFT, NVDA, TSLA, GOOGL, AMZN, META, SPY, QQQ), and 2 commodities (Gold, Silver) — plus a weight percentage. Add as many rows as you want. Remove any you don't. The only hard rule is that the weights have to sum to 100%.

On top of that, you set three more inputs: a total per-period contribution (this is the combined amount across the whole portfolio, not per asset), a frequency (weekly, biweekly, monthly), and a start and end date.

Every period, the calculator splits your contribution according to the weights and buys each asset at its historical price on that date. So a $500/month contribution at 60% SPY and 40% BTC means $300 buys SPY and $200 buys BTC, every month, mechanically.

The output has two parts. First, a per-asset breakdown showing each sleeve's allocation, total invested, current value, and return percentage. Second, the combined portfolio totals — total invested across all sleeves, combined value, combined return — and a stacked timeline chart showing the portfolio value alongside cumulative invested over the entire period.

That's the whole tool. Simple inputs, but they unlock surprisingly rich analysis.

A worked example: 80/10/10 portfolio

Let's run a concrete scenario. Suppose you've been mostly an index investor but have wanted some exposure to gold and Bitcoin without going all-in on either. You set up:

• 80% SPY
• 10% Gold
• 10% BTC
• $500/month
• January 2017 through today

The total invested across that period works out to roughly $56,000 ($500 × 12 months × about 9.4 years). What's interesting is how the per-asset breakdown lands.

The SPY sleeve gets the lion's share of contributions — about $45,000 of the $56K. Over that span, SPY went through the 2020 COVID crash and recovery, plus the 2022 drawdown, but trended significantly higher overall. The Gold sleeve, around $5,600 invested, returned a solid but unspectacular result over the same period.

The BTC sleeve is the surprise. Despite being only 10% of the contribution — about $5,600 invested over the period — it likely accounts for a disproportionate share of the final portfolio value. Bitcoin's compound return from 2017 forward, even accounting for the multiple 70%+ drawdowns along the way, was high enough that a small sleeve becomes a large piece of the ending pie.

That single observation is one of the most useful things the Portfolio Builder surfaces. When you DCA into a high-return, high-volatility asset as a small weight inside a diversified portfolio, you get a lot of the upside with a fraction of the heart attacks. The per-asset table makes the contribution attribution obvious — you can see exactly how much each sleeve contributed to the final number.

The diversification dividend

Now let's do the comparison that really shows what diversification buys you. Run three different portfolios on the same dates — say, $500/month from January 2017 forward:

Portfolio A: 100% SPY. Moderate return. Drawdowns in the 20-35% range. Smooth-ish ride by historical standards.

Portfolio B: 100% BTC. Much higher return. Drawdowns exceeding 70% multiple times. Several years where the portfolio sat well below its previous high.

Portfolio C: 60% SPY / 20% Gold / 20% BTC. Return that lands meaningfully closer to Portfolio B than Portfolio A. Drawdowns that look much more like Portfolio A. The peak-to-trough declines never approach the BTC-only line.

That third portfolio is the diversification dividend made concrete. You're getting most of the return of a high-Bitcoin allocation while bearing much more of the risk profile of an index portfolio.

This isn't a guarantee. Correlations shift, especially in crises (more on that later). But across the available history, the pattern shows up consistently: a mix of imperfectly correlated, positive-expected-return assets beats any single one of them on a risk-adjusted basis.

What one asset looks like

Before going further, it helps to picture the single-asset DCA experience that most people are actually running today:

That waveform — the slow climb, the dips, the recoveries — is what every individual sleeve in a portfolio looks like on its own. Now imagine you held three of these at once, with different waveforms that don't peak and trough at the same times. The chart you see in the Portfolio Builder is the sum of those three different waves. The peaks of one fill in the troughs of another. The combined line is smoother than any one of its components.

That visual intuition is the whole game. Diversification isn't about giving up returns to lower risk. It's about choosing assets whose squiggles cancel each other out at the right moments.

The forward-fill timeline merge

A boring but important implementation detail: the Portfolio Builder uses forward-fill on each asset's price history before summing portfolio values.

Why does that matter? Different assets trade on different calendars. Bitcoin and other crypto trade 24/7 — there's a price for every single day of the year. Equities and ETFs trade only on US market days; there's no SPY price on Saturday. Commodities have their own calendars too.

If you naively summed per-asset portfolio values only on dates where all selected assets traded, two ugly things happen. First, you lose data on weekends — the chart drops chunks of detail on the crypto side. Second, if you instead summed across the union of dates without filling gaps, the portfolio chart would collapse to near-zero on every weekend (because SPY's contribution is missing).

The fix is forward-fill: on a Saturday, SPY's last known value (Friday's close) carries forward. On a holiday, the previous trading day's value carries forward. This is the standard treatment in any serious portfolio analytics package, and it's what makes the stacked timeline chart actually readable. The combined value line stays continuous across the whole period regardless of which assets you mixed in.

You don't have to think about this when using the tool, but it's worth knowing that the calculator is doing it correctly. Some quick spreadsheet portfolio backtests get this wrong.

The common-window trap

Here's a pitfall worth flagging clearly. The backtest uses the intersection of available data across all selected assets. The start date is effectively max(start_date of each asset).

What does that mean in practice? Bitcoin price data in the calculator goes back to roughly 2014. SPY goes back further. Gold goes back further still. So a BTC + SPY + Gold portfolio can be backtested over the full BTC history.

But suppose you add Solana to that portfolio. Solana's price history starts in 2020. Now the common window shrinks to 2020 onwards. The 2014–2019 stretch of Bitcoin data — including the early massive returns — is no longer in your backtest, even though the BTC sleeve is still there.

This is a feature, not a bug. It's the correct apples-to-apples treatment: every asset in the portfolio must have a price on the start date, otherwise the combined return is meaningless. But it can quietly cut off the most interesting parts of an older asset's history. If you want to evaluate a long-history portfolio, build it from long-history assets first, and only add newer ones after you've understood the long-window result.

Static weights, no rebalancing

The calculator is doing unmanaged static-weight DCA. Each period, your new contribution gets split according to the original weights. But the calculator does not rebalance the existing positions.

This means that over a long run, the actual allocation of the portfolio drifts. If you start with 50% SPY and 50% BTC, and BTC runs 5× while SPY runs 2×, by the end of the period the portfolio is something like 85% BTC and 15% SPY. The displayed combined return is mathematically correct — it accurately reflects the total dollars in vs. the total dollars out. But the risk profile of the portfolio at the end is very different from the risk profile at the start.

In real life, this is what rebalancing addresses. The common approaches are calendar-based (rebalance once a year, regardless of drift) or band-based (rebalance whenever any sleeve drifts more than 5 percentage points from its target). Both keep the portfolio's risk profile closer to your original intent.

The Portfolio Builder doesn't model either approach. The numbers it shows are what you'd get with a pure new-contribution-allocation strategy. That's a clean baseline and it's exactly what some investors do, but be aware that adding rebalancing in real life will change the long-run outcome — sometimes for better (if it forces you to sell into rallies and buy into drawdowns), sometimes for worse (if it prevents you from riding a long winner to its full extent).

Sample portfolios to try

A few templates to drop into the calculator and run yourself:

The Boring 90/10. 90% SPY, 10% BTC. For the index investor who wants crypto exposure without selling the farm. The BTC sleeve is small enough that a 70% drawdown is survivable, but big enough that the upside actually moves the needle on the combined portfolio.

The Three-Fund Classic. 60% SPY, 30% QQQ, 10% Gold. US-equity-tilted with a tech overweight and an inflation hedge. No crypto. A reasonable starting point for someone who wants diversification without going beyond traditional asset classes.

The Crypto Basket. 50% BTC, 30% ETH, 20% SOL. Concentrated crypto with weighting that reflects market cap order. Higher volatility than any of the equity-heavy options. The diversification within crypto helps somewhat, but the assets are correlated enough that a crypto winter will still hurt all three.

The Inflation-Resistant Mix. 50% SPY, 25% Gold, 25% BTC. Built around the thesis that equities, gold, and Bitcoin each respond differently to inflation regimes, so holding all three should weather most macro outcomes better than any one alone.

The Mag-7-Lite. 40% SPY, 15% AAPL, 15% MSFT, 15% NVDA, 15% GOOGL. A way to overweight specific high-conviction names without leaving the index entirely. Useful for sanity-checking single-stock conviction against a benchmark.

For each of these, try running them over multiple time windows — the past 5 years, the past 10 years, since 2014 where the data allows. The relative ordering of returns changes meaningfully depending on which era you pick. That's a healthy reminder that backtested results are dependent on the chosen window.

What the calculator can't tell you

The Portfolio Builder is a backtest. That's it. It does several things it cannot do:

It cannot tell you the optimal weights. "Optimal" depends entirely on your risk tolerance, your time horizon, and your existing assets. The math can show you the trade-offs; only you can decide which trade-off you want.

It cannot tell you when to rebalance. The tool models a static-weight contribution policy. Whether to rebalance, on what schedule, and to what bands is a separate decision the tool doesn't simulate.

It cannot account for taxes. Rebalancing in a taxable account triggers capital gains. DCA in a taxable account creates a lot of small cost-basis lots. Tax treatment can significantly change the after-tax return, especially for short holding periods. The calculator's output is pre-tax.

It cannot predict future correlations. The reason diversification works is that historical correlations between asset classes have been low. In a sufficiently severe crisis, correlations have a habit of converging toward 1 — everything sells off together. The historical diversification dividend is real; whether it'll be as large in the next crisis is unknowable.

Treat the calculator the way a flight simulator treats real weather: useful for practicing the controls, not a substitute for checking the actual forecast.

A practical workflow

Here's a sensible way to use the tool:

1. Pick a date range that covers a full market cycle. A minimum of 10 years if possible — long enough to include at least one major drawdown. Shorter windows can flatter or punish any specific asset.

2. A/B test three or four allocations. Start with one extreme (e.g. 100% in your favorite asset), one defensive mix (e.g. 80% index, 20% diversifiers), and one balanced mix. Note the combined return and the shape of the value chart for each.

3. Pay attention to the worst drawdown shown. Trace the value chart's biggest peak-to-trough fall. That's what you'd have actually experienced. Ask yourself honestly whether you would have kept contributing through it.

4. Pick the one you can live with. Not the one with the highest return. Not the one with the lowest volatility. The one where you can imagine yourself still contributing during the worst chart segment.

The whole point of a backtest is to confront yourself with what the strategy would have felt like in the rough years. If you can stomach the rough years on paper, you have a much better chance of stomaching them in practice. If you can't, you've learned something valuable: that portfolio is not for you, no matter what the return number says.

Where to go from here

The Portfolio DCA Builder is the main tool, but it's not the only one. For deeper single-asset analysis — including breakdowns the portfolio tool doesn't show — you may also want:

• The crypto DCA calculator for detailed single-coin backtests
• The stocks and ETFs calculator for individual equity strategies
• The commodities calculator for gold and silver baselines
• The method overview for how the underlying calculations work

A reasonable workflow is to use the single-asset calculators to understand each sleeve's standalone behavior, then bring them together in the Portfolio Builder to see how the combination behaves. The single-asset tools show you the squiggles; the portfolio tool shows you what summing the squiggles looks like.

If you're ready to start DCA-ing into a multi-asset portfolio for real, you'll need an account that supports recurring buys across the asset classes you've chosen. For the crypto sleeve, that typically means a major exchange with automated recurring purchase support.

Diversification, like DCA itself, is one of the few investment ideas that's both well-supported by decades of math and routinely under-applied by retail investors. The Portfolio Builder doesn't tell you what the right portfolio is. It tells you, with real numbers on real historical prices, what each candidate portfolio would have looked like to live through. That's the question worth asking before you commit your next monthly contribution.