Portfolio Analysis Report — 27-06-2026 19:36

Asset scope: all assets | Source: prices.csv

Overview

Assets in analysis: BTC, ETH, SOL, HYPE, GOLD, SPX, TSLA, GOOGL, JLP

Rows in cleaned dataset: 1461

Date range in cleaned dataset: 2022-06-28 → 2026-06-27

Forward-Looking Indicators (current regime snapshot — not price predictions)

These indicators describe the momentum and trend state of each asset right now, computed from the full price history. RSI above 70 = overbought momentum; below 30 = oversold. Momentum columns show actual price return over the period. "vs 50d SMA" shows how far the current price sits above or below the 50-day moving average. The Regime label summarises the combination.

Latest Price RSI-14 1M Momentum 3M Momentum vs 50d SMA Regime
BTC 60,205.00 33.8 -1.09% -22.43% -13.79% Bearish
ETH 1,578.91 39.0 0.65% -31.91% -17.16% Mixed
SOL 71.64 56.0 15.20% -16.84% -7.77% Mixed
HYPE 62.86 53.3 10.92% 51.48% 6.20% Bullish
GOLD 4,078.70 38.7 -5.96% -13.63% -7.28% Bearish
SPX 7,354.02 42.0 -0.40% 2.64% -1.33% Bearish
TSLA 379.71 28.7 -2.89% 0.91% -8.01% Oversold / Recovering
GOOGL 337.39 30.8 -8.40% -1.98% -9.79% Bearish
JLP 3.43 51.6 7.14% -12.24% -5.99% Mixed

Note: assets with fewer than 50 days of history are excluded from this table. Momentum signals in crypto have a weak positive correlation with near-term returns but are not reliable standalone predictors.

Cross-Timeframe Summary

Rows Best Tested Return Best Single Asset Lowest Vol Lowest Drawdown Best Sharpe-like
Timeframe
1 Day 2 n/a BTC n/a n/a n/a
1 Week 8 MinVar SPX MinVar MinVar Equal
1 Month 31 MaxSharpe HYPE MinVar MinVar MaxSharpe
3 Months 92 MaxSharpe HYPE MinVar MinVar MaxSharpe
6 Months 184 MaxSharpe HYPE MinVar MinVar MaxSharpe
12 Months 366 MaxSharpe GOOGL MinVar MinVar MaxSharpe
24 Months 731 MaxSharpe TSLA MinVar MinVar-C50 MaxSharpe
3 Years 1097 MaxSharpe SOL MinVar MinVar-C50 MaxSharpe
4 Years 1461 Equal GOOGL MinVar MinVar-C50 MaxSharpe

Min-Variance Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 15.53% 0.00% 0.00% 0.00% 0.00% 71.97% 0.00% 12.50% 0.00%
1 Month 0.00% 0.00% 0.00% 0.00% 5.94% 88.53% 0.00% 5.52% 0.00%
3 Months 0.00% 0.00% 0.00% 0.00% 0.00% 94.39% 0.00% 0.00% 5.61%
6 Months 0.00% 0.00% 0.00% 0.00% 4.90% 95.10% 0.00% 0.00% 0.00%
12 Months 0.00% 0.00% 0.00% 0.00% 9.30% 90.70% 0.00% 0.00% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 30.80% 67.39% 0.00% 0.00% 1.81%
3 Years 0.00% 0.00% 0.00% nan% 31.95% 64.28% 0.00% 0.00% 3.77%
4 Years 0.00% 0.00% 0.00% nan% 39.59% 60.41% 0.00% 0.00% nan%

MinVar-C50 Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 27.57% 0.00% 0.00% 0.00% 0.00% 50.00% 0.00% 22.43% 0.00%
1 Month 3.51% 0.00% 0.00% 0.00% 24.79% 50.00% 0.00% 21.70% 0.00%
3 Months 0.00% 0.00% 0.00% 0.00% 29.17% 50.00% 0.00% 3.12% 17.71%
6 Months 0.00% 0.00% 0.00% 0.00% 20.09% 50.00% 0.00% 19.41% 10.50%
12 Months 0.00% 0.00% 0.00% 0.00% 27.84% 50.00% 0.00% 14.32% 7.84%
24 Months 0.00% 0.00% 0.00% nan% 39.31% 50.00% 0.00% 4.11% 6.58%
3 Years 0.00% 0.00% 0.00% nan% 39.62% 50.00% 0.00% 2.34% 8.04%
4 Years 0.68% 0.00% 0.00% nan% 48.80% 50.00% 0.00% 0.52% nan%

MaxSharpe Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%
1 Month 0.00% 0.00% 0.00% 50.00% 0.00% 50.00% 0.00% 0.00% 0.00%
3 Months 0.00% 0.00% 0.00% 14.74% 0.00% 50.00% 0.00% 35.26% 0.00%
6 Months 0.00% 0.00% 0.00% 48.83% 0.00% 21.23% 0.00% 29.94% 0.00%
12 Months 0.00% 0.00% 0.00% 6.36% 14.70% 28.94% 0.00% 50.00% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 50.00% 19.88% 4.41% 25.70% 0.00%
3 Years 0.00% 0.00% 6.78% nan% 47.88% 20.87% 0.00% 24.47% 0.00%
4 Years 7.62% 0.00% 0.39% nan% 48.40% 27.46% 0.00% 16.13% nan%

Stable Allocation Band

Min Avg Max Times > 20% Times < 1%
BTC 0.00% 3.97% 27.57% 1 6
ETH 0.00% 0.00% 0.00% 0 8
SOL 0.00% 0.00% 0.00% 0 8
HYPE 0.00% 0.00% 0.00% 0 5
GOLD 0.00% 28.70% 48.80% 7 1
SPX 50.00% 50.00% 50.00% 8 0
TSLA 0.00% 0.00% 0.00% 0 8
GOOGL 0.52% 10.99% 22.43% 2 1
JLP 0.00% 7.24% 17.71% 0 2

1 Day

Window: 2026-06-26 → 2026-06-27 (2 rows)

Portfolio optimisation is skipped for single-day windows. Showing asset returns and single-asset stats only.

Asset Total Returns

Total Return
BTC 0.31%
ETH 0.15%
SOL -0.27%
HYPE -2.22%
GOLD 0.00%
SPX 0.00%
TSLA 0.00%
GOOGL 0.00%
JLP -0.03%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC 214.25% nan% nan 0.00% 0.31% 0.31% 0.31%
ETH 70.01% nan% nan 0.00% 0.15% 0.15% 0.15%
SOL -62.99% nan% nan 0.00% -0.27% -0.27% -0.27%
HYPE -99.97% nan% nan 0.00% -2.22% -2.22% -2.22%
GOLD 0.00% nan% nan 0.00% 0.00% 0.00% 0.00%
SPX 0.00% nan% nan 0.00% 0.00% 0.00% 0.00%
TSLA 0.00% nan% nan 0.00% 0.00% 0.00% 0.00%
GOOGL 0.00% nan% nan 0.00% 0.00% 0.00% 0.00%
JLP -11.02% nan% nan 0.00% -0.03% -0.03% -0.03%

Assets priced in BTC — 1 Day (normalised to 1.0 at each asset's first real data date · smoothed · 2 rows)

1.020 1.007 0.994 0.981 0.967 2026-06-26 2026-06-27 ETH -0.1% GOLD -0.2% SPX -0.2% TSLA -0.2% GOOGL -0.2% JLP -0.2% SOL -0.3% HYPE -1.3%

Assets priced in GOLD — 1 Day (normalised to 1.0 at each asset's first real data date · smoothed · 2 rows)

1.022 1.008 0.995 0.982 0.969 2026-06-26 2026-06-27 BTC +0.2% ETH +0.1% SPX +0.0% TSLA +0.0% GOOGL +0.0% JLP -0.0% SOL -0.1% HYPE -1.1%

Assets priced in SPX — 1 Day (normalised to 1.0 at each asset's first real data date · smoothed · 2 rows)

1.022 1.008 0.995 0.982 0.969 2026-06-26 2026-06-27 BTC +0.2% ETH +0.1% GOLD +0.0% TSLA +0.0% GOOGL +0.0% JLP -0.0% SOL -0.1% HYPE -1.1%

1 Week

Window: 2026-06-20 → 2026-06-27 (8 rows)

⚠ This window has only 8 rows. Covariance estimates are noisy — treat allocation weights as directional signals, not precise recommendations.

Claude Narrative Report

## Weekly Portfolio Analysis

This was a rough week across the board, with every asset in the red and no safe havens to speak of. Traditional equities held up relatively better, with the broad market index losing the least ground, while crypto assets bore the brunt of the selloff. Ethereum and the higher-beta altcoins like HYPE suffered the steepest declines, shedding roughly three to five times more value than defensive positions. Even gold, typically a flight-to-safety play, dropped meaningfully—suggesting this was a broad risk-off move rather than a sector-specific correction.

Among the tested portfolios, the minimum variance approach proved its worth by cutting losses nearly in half compared to equal-weight or maximum-Sharpe strategies. By heavily favoring the stability of equities while maintaining modest exposure to Bitcoin, the MinVar portfolio delivered the smallest drawdown and lowest volatility. The equal-weight and max-Sharpe portfolios performed identically—and poorly—because spreading capital evenly across such volatile assets during a synchronized decline offers no real protection. Notably, the single-asset dominance ratio below one indicates that diversified portfolios still outperformed simply holding any one asset alone.

Looking at individual holdings, Solana stands out as a relative winner among crypto despite its extreme volatility, losing only modestly while Bitcoin and Ethereum fell much harder. However, the risk-adjusted story remains unfavorable across all crypto assets, with deeply negative Sharpe ratios everywhere.

**Takeaway:** In sharp drawdown weeks like this, reducing crypto concentration and anchoring your portfolio with low-volatility traditional assets—rather than chasing diversification across multiple tokens—is what actually preserves capital.

Assets priced in BTC — 1 Week (normalised to 1.0 at each asset's first real data date · smoothed · 8 rows)

1.072 1.030 0.987 0.945 0.902 2026-06-20 2026-06-21 2026-06-22 2026-06-24 2026-06-25 2026-06-27 SPX +4.8% SOL +4.8% JLP +4.4% GOLD +3.2% TSLA +1.3% GOOGL -2.0% ETH -3.1% HYPE -3.8%

Assets priced in GOLD — 1 Week (normalised to 1.0 at each asset's first real data date · smoothed · 8 rows)

1.053 1.016 0.978 0.941 0.904 2026-06-20 2026-06-21 2026-06-22 2026-06-24 2026-06-25 2026-06-27 SPX +1.5% SOL +1.5% JLP +1.1% TSLA -1.8% BTC -3.1% GOOGL -5.1% ETH -6.1% HYPE -6.8%

Assets priced in SPX — 1 Week (normalised to 1.0 at each asset's first real data date · smoothed · 8 rows)

1.028 0.993 0.959 0.924 0.889 2026-06-20 2026-06-21 2026-06-22 2026-06-24 2026-06-25 2026-06-27 SOL -0.0% JLP -0.4% GOLD -1.5% TSLA -3.3% BTC -4.6% GOOGL -6.5% ETH -7.5% HYPE -8.2%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%
MinVar
SPX: 71.97%
BTC: 15.53%
GOOGL: 12.50%
GOLD: 0.00%
ETH: 0.00%
JLP: 0.00%
TSLA: 0.00%
SOL: 0.00%
HYPE: 0.00%
MinVar-C50
SPX: 50.00%
BTC: 27.57%
GOOGL: 22.43%
GOLD: 0.00%
JLP: 0.00%
ETH: 0.00%
HYPE: 0.00%
SOL: 0.00%
TSLA: 0.00%
MaxSharpe ▲
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%

Asset Total Returns

Total Return
BTC -6.28%
ETH -9.22%
SOL -2.09%
HYPE -11.01%
GOLD -3.44%
SPX -1.95%
TSLA -5.19%
GOOGL -8.33%
JLP -2.37%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.963 0.576 -0.007 0.405 0.196 0.606 -0.660 0.701
ETH 0.963 1.000 0.613 0.159 0.271 0.344 0.698 -0.621 0.738
SOL 0.576 0.613 1.000 0.310 0.646 0.433 0.619 -0.190 0.985
HYPE -0.007 0.159 0.310 1.000 -0.189 0.583 0.470 -0.076 0.312
GOLD 0.405 0.271 0.646 -0.189 1.000 0.296 0.453 0.014 0.610
SPX 0.196 0.344 0.433 0.583 0.296 1.000 0.858 0.182 0.444
TSLA 0.606 0.698 0.619 0.470 0.453 0.858 1.000 -0.304 0.679
GOOGL -0.660 -0.621 -0.190 -0.076 0.014 0.182 -0.304 1.000 -0.299
JLP 0.701 0.738 0.985 0.312 0.610 0.444 0.679 -0.299 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -94.64% 24.33% -3.891 -5.38% -2.45% -2.93% -5.51%
MinVar -83.71% 9.46% -8.854 -3.24% -1.25% -1.47% -3.43%
MinVar-C50 -91.26% 9.83% -9.286 -4.24% -1.35% -1.50% -4.57%
MaxSharpe -94.64% 24.33% -3.891 -5.38% -2.45% -2.93% -5.51%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC -96.48% 28.91% -3.337 -6.61% -2.49% -2.67% -6.28%
ETH -99.31% 38.95% -2.550 -9.37% -3.50% -3.54% -9.22%
SOL -61.66% 58.83% -1.048 -6.69% -2.92% -3.15% -2.09%
HYPE -99.73% 60.13% -1.659 -7.30% -5.79% -6.11% -11.01%
GOLD -83.26% 29.95% -2.780 -5.53% -2.74% -3.38% -3.44%
SPX -64.10% 10.06% -6.375 -1.95% -1.12% -1.44% -1.95%
TSLA -93.17% 46.19% -2.017 -7.39% -4.53% -5.79% -5.19%
GOOGL -98.87% 34.11% -2.899 -8.33% -4.04% -4.99% -8.33%
JLP -69.98% 33.09% -2.115 -4.50% -1.96% -2.12% -2.37%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 72.0%, BTC 15.5%, GOOGL 12.5%
  • Highest-return tested portfolio: MinVar — SPX 72.0%, BTC 15.5%, GOOGL 12.5%
  • Best risk-adjusted tested portfolio: Equal — BTC 11.1%, ETH 11.1%, SOL 11.1%, HYPE 11.1%, GOLD 11.1%, SPX 11.1%, TSLA 11.1%, GOOGL 11.1%
  • Lowest-drawdown tested portfolio: MinVar — SPX 72.0%, BTC 15.5%, GOOGL 12.5%
  • Highest-return single asset: SPX — -1.95%
  • Single-asset dominance ratio: 0.570x

1 Month

Window: 2026-05-28 → 2026-06-27 (31 rows)

Claude Narrative Report

## Monthly Portfolio Analysis

The past month delivered a brutal environment for risk assets, with nearly every major holding posting significant losses. Traditional crypto stalwarts Bitcoin and Ethereum were among the hardest hit, losing roughly a fifth of their value, while even supposedly safer assets like gold and the S&P 500 declined. The sole bright spot was HYPE, which managed a modest gain despite carrying the highest volatility in the group—a reminder that in chaotic markets, idiosyncratic winners can emerge from unexpected places.

Portfolio construction made a meaningful difference in navigating this downturn. The minimum variance strategy, which leaned heavily into the S&P 500 with small allocations to gold and Google, contained losses to under four percent while exhibiting less than half the volatility of an equal-weight approach. Meanwhile, the maximum Sharpe portfolio—split evenly between HYPE and the S&P 500—was the only strategy to eke out a positive return, though it required stomaching substantially higher volatility. The equal-weight portfolio, by contrast, simply averaged out the carnage and offered no defensive benefit.

The single-asset analysis underscores how punishing concentration risk can be during drawdowns. Holding Bitcoin alone meant absorbing a nearly twenty percent loss with a maximum drawdown pushing past nineteen percent, while Ethereum fared even worse. The data suggests that blending crypto exposure with lower-volatility traditional assets significantly dampened pain without completely sacrificing upside. **Takeaway:** When markets turn hostile, pairing crypto positions with a stable anchor like broad equities can cut your losses in half—pure crypto conviction may feel bold, but disciplined diversification is what keeps you in the game.

Assets priced in BTC — 1 Month (normalised to 1.0 at each asset's first real data date · smoothed · 31 rows)

1.334 1.226 1.117 1.008 0.900 2026-05-28 2026-06-03 2026-06-09 2026-06-15 2026-06-21 2026-06-27 HYPE +26.4% SPX +18.7% GOLD +9.8% JLP +9.5% GOOGL +6.8% TSLA +4.3% SOL +3.9% ETH -3.6%

Assets priced in GOLD — 1 Month (normalised to 1.0 at each asset's first real data date · smoothed · 31 rows)

1.232 1.122 1.012 0.902 0.792 2026-05-28 2026-06-03 2026-06-09 2026-06-15 2026-06-21 2026-06-27 HYPE +15.2% SPX +8.2% JLP -0.3% GOOGL -2.7% TSLA -5.0% SOL -5.4% BTC -8.9% ETH -12.2%

Assets priced in SPX — 1 Month (normalised to 1.0 at each asset's first real data date · smoothed · 31 rows)

1.174 1.075 0.976 0.877 0.778 2026-05-28 2026-06-03 2026-06-09 2026-06-15 2026-06-21 2026-06-27 HYPE +6.5% GOLD -7.6% JLP -7.8% GOOGL -10.1% TSLA -12.2% SOL -12.5% BTC -15.8% ETH -18.8%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%
MinVar
SPX: 88.53%
GOLD: 5.94%
GOOGL: 5.52%
BTC: 0.00%
JLP: 0.00%
TSLA: 0.00%
SOL: 0.00%
ETH: 0.00%
HYPE: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 24.79%
GOOGL: 21.70%
BTC: 3.51%
JLP: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
HYPE: 0.00%
MaxSharpe ▲
HYPE: 50.00%
SPX: 50.00%
JLP: 0.00%
SOL: 0.00%
GOLD: 0.00%
TSLA: 0.00%
GOOGL: 0.00%
BTC: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -18.13%
ETH -21.35%
SOL -12.62%
HYPE 2.05%
GOLD -9.35%
SPX -2.77%
TSLA -14.11%
GOOGL -13.47%
JLP -9.14%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.873 0.859 0.404 0.354 0.404 0.415 0.253 0.904
ETH 0.873 1.000 0.880 0.559 0.379 0.562 0.469 0.218 0.909
SOL 0.859 0.880 1.000 0.583 0.421 0.487 0.468 0.213 0.993
HYPE 0.404 0.559 0.583 1.000 0.256 0.383 0.476 0.029 0.572
GOLD 0.354 0.379 0.421 0.256 1.000 0.455 0.482 0.196 0.407
SPX 0.404 0.562 0.487 0.383 0.455 1.000 0.735 0.416 0.496
TSLA 0.415 0.469 0.468 0.476 0.482 0.735 1.000 0.053 0.487
GOOGL 0.253 0.218 0.213 0.029 0.196 0.416 0.053 1.000 0.215
JLP 0.904 0.909 0.993 0.572 0.407 0.496 0.487 0.215 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -72.39% 38.85% -1.863 -14.61% -3.40% -4.57% -10.58%
MinVar -36.46% 16.33% -2.233 -4.65% -1.60% -2.17% -3.76%
MinVar-C50 -59.41% 18.03% -3.294 -7.19% -1.86% -2.32% -7.26%
MaxSharpe 31.95% 60.65% 0.527 -16.65% -4.89% -5.82% 0.81%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC -90.39% 43.01% -2.101 -19.03% -4.30% -5.49% -18.13%
ETH -93.44% 63.05% -1.482 -22.51% -5.59% -8.96% -21.35%
SOL -75.41% 69.95% -1.078 -24.66% -6.01% -8.09% -12.62%
HYPE 141.62% 114.03% 1.242 -28.64% -8.61% -11.45% 2.05%
GOLD -68.31% 30.32% -2.253 -12.50% -3.25% -3.47% -9.35%
SPX -28.02% 16.49% -1.699 -4.50% -1.54% -2.13% -2.77%
TSLA -82.42% 47.76% -1.726 -13.92% -5.24% -6.17% -14.11%
GOOGL -81.88% 32.43% -2.525 -11.24% -3.26% -4.42% -13.47%
JLP -66.10% 41.62% -1.588 -15.53% -3.69% -5.02% -9.14%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 88.5%, GOLD 5.9%, GOOGL 5.5%
  • Highest-return tested portfolio: MaxSharpe — HYPE 50.0%, SPX 50.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — HYPE 50.0%, SPX 50.0%
  • Lowest-drawdown tested portfolio: MinVar — SPX 88.5%, GOLD 5.9%, GOOGL 5.5%
  • Highest-return single asset: HYPE — 2.05%
  • Single-asset dominance ratio: 2.518x

3 Months

Window: 2026-03-28 → 2026-06-27 (92 rows)

Claude Narrative Report

## Portfolio Analysis: Q1 2025

The past three months painted a stark picture of divergence across asset classes. Traditional equities and one standout crypto token dominated, while the major digital assets stumbled badly. HYPE delivered exceptional gains, more than doubling the return of the next best performer, while Google and the S&P 500 posted strong double-digit advances. Meanwhile, Bitcoin, Ethereum, and Solana all finished deep in the red, with ETH suffering the steepest decline of the group. Gold, often a safe haven, also retreated alongside the crypto majors—an unusual alignment that underscores just how selective this market has been.

The portfolio analysis reveals that diversification meaningfully outperformed holding any single major cryptocurrency. An equal-weight basket eked out a modest gain despite crypto's weakness, but the optimized portfolios told the real story. The minimum variance approach, concentrated heavily in the S&P 500 with a small JLP allocation, delivered solid returns with remarkably low drawdowns—under five percent peak-to-trough. The maximum Sharpe portfolio, which blended the S&P 500 with Google and a tactical HYPE position, generated the best risk-adjusted performance by a wide margin, capturing upside while keeping volatility in check.

The single-asset comparison is sobering for crypto purists. Holding Bitcoin alone meant enduring nearly thirty percent drawdowns while losing money over the quarter. Ethereum and Solana fared even worse, with volatility exceeding fifty percent and deeper losses. Only HYPE justified its risk, but its extreme volatility makes it unsuitable as a core holding.

**Takeaway:** In choppy crypto markets, blending selective digital asset exposure with stable equity positions—rather than going all-in on majors—dramatically improves your risk-adjusted returns and protects capital during drawdowns.

Assets priced in BTC — 3 Months (normalised to 1.0 at each asset's first real data date · smoothed · 92 rows)

1.893 1.612 1.330 1.049 0.767 2026-03-28 2026-04-15 2026-05-03 2026-05-21 2026-06-08 2026-06-27 HYPE +79.9% GOOGL +37.4% SPX +23.7% TSLA +14.6% JLP -0.4% GOLD -1.6% SOL -8.4% ETH -10.9%

Assets priced in GOLD — 3 Months (normalised to 1.0 at each asset's first real data date · smoothed · 92 rows)

1.923 1.641 1.358 1.076 0.794 2026-03-28 2026-04-15 2026-05-03 2026-05-21 2026-06-08 2026-06-27 HYPE +82.9% GOOGL +39.6% SPX +25.7% TSLA +16.5% BTC +1.6% JLP +1.2% SOL -6.9% ETH -9.4%

Assets priced in SPX — 3 Months (normalised to 1.0 at each asset's first real data date · smoothed · 92 rows)

1.530 1.308 1.087 0.866 0.644 2026-03-28 2026-04-15 2026-05-03 2026-05-21 2026-06-08 2026-06-27 HYPE +45.6% GOOGL +11.1% TSLA -7.3% BTC -19.1% JLP -19.5% GOLD -20.4% SOL -25.9% ETH -27.9%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%
MinVar
SPX: 94.39%
JLP: 5.61%
GOLD: 0.00%
BTC: 0.00%
GOOGL: 0.00%
SOL: 0.00%
ETH: 0.00%
TSLA: 0.00%
HYPE: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 29.17%
JLP: 17.71%
GOOGL: 3.12%
BTC: 0.00%
TSLA: 0.00%
SOL: 0.00%
ETH: 0.00%
HYPE: 0.00%
MaxSharpe ▲
SPX: 50.00%
GOOGL: 35.26%
HYPE: 14.74%
TSLA: 0.00%
JLP: 0.00%
GOLD: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -9.22%
ETH -20.77%
SOL -12.65%
HYPE 59.38%
GOLD -9.20%
SPX 15.47%
TSLA 4.94%
GOOGL 23.06%
JLP -6.20%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.900 0.822 0.484 0.281 0.344 0.268 0.213 0.892
ETH 0.900 1.000 0.829 0.525 0.306 0.400 0.324 0.205 0.890
SOL 0.822 0.829 1.000 0.547 0.269 0.299 0.293 0.074 0.987
HYPE 0.484 0.525 0.547 1.000 0.172 0.267 0.235 0.004 0.557
GOLD 0.281 0.306 0.269 0.172 1.000 0.609 0.503 0.460 0.280
SPX 0.344 0.400 0.299 0.267 0.609 1.000 0.624 0.603 0.328
TSLA 0.268 0.324 0.293 0.235 0.503 0.624 1.000 0.291 0.313
GOOGL 0.213 0.205 0.074 0.004 0.460 0.603 0.291 1.000 0.111
JLP 0.892 0.890 0.987 0.557 0.280 0.328 0.313 0.111 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 24.84% 30.86% 0.805 -14.81% -2.49% -3.49% 4.45%
MinVar 72.13% 14.51% 4.971 -4.89% -1.02% -1.67% 14.20%
MinVar-C50 19.96% 16.62% 1.201 -9.31% -1.23% -1.97% 4.29%
MaxSharpe 157.95% 23.89% 6.613 -8.13% -1.98% -2.33% 25.77%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC -27.45% 36.77% -0.747 -27.29% -2.87% -4.25% -9.22%
ETH -55.18% 51.26% -1.077 -35.37% -3.60% -5.90% -20.77%
SOL -32.71% 54.40% -0.601 -36.12% -3.50% -5.56% -12.65%
HYPE 889.78% 93.12% 9.555 -28.64% -6.77% -9.11% 59.38%
GOLD -29.99% 24.80% -1.209 -17.85% -2.68% -3.18% -9.20%
SPX 79.93% 14.62% 5.468 -4.50% -0.98% -1.63% 15.47%
TSLA 33.80% 44.45% 0.761 -15.75% -4.19% -5.42% 4.94%
GOOGL 144.75% 36.08% 4.012 -16.15% -2.42% -3.38% 23.06%
JLP -18.37% 33.01% -0.557 -23.60% -2.12% -3.40% -6.20%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 94.4%, JLP 5.6%
  • Highest-return tested portfolio: MaxSharpe — SPX 50.0%, GOOGL 35.3%, HYPE 14.7%
  • Best risk-adjusted tested portfolio: MaxSharpe — SPX 50.0%, GOOGL 35.3%, HYPE 14.7%
  • Lowest-drawdown tested portfolio: MinVar — SPX 94.4%, JLP 5.6%
  • Highest-return single asset: HYPE — 59.38%
  • Single-asset dominance ratio: 2.305x

6 Months

Window: 2025-12-26 → 2026-06-27 (184 rows)

Claude Narrative Report

## Portfolio Analysis: Six-Month Review

The past six months have been brutal for crypto holders. The major tokens—Bitcoin, Ethereum, and Solana—all delivered deep losses, with Ethereum shedding nearly half its value and Solana not far behind. Meanwhile, traditional equities held up reasonably well, with the S&P 500 and Google both posting modest gains. The standout performer was HYPE, which more than doubled, though this came with extreme volatility that few investors could stomach in practice. Gold, often touted as a safe haven, actually declined nearly ten percent, offering little refuge.

When comparing portfolio strategies, the differences are striking. An equal-weight approach across all assets still lost money and experienced significant drawdowns, dragged down by heavy crypto exposure. The minimum variance portfolio, which leaned almost entirely into the S&P 500 with a small gold allocation, delivered the steadiest ride—modest gains with the lowest volatility and shallowest drawdown. The maximum Sharpe portfolio captured much of HYPE's explosive rally by pairing it with Google and the S&P 500, generating outstanding risk-adjusted returns, though its volatility was considerably higher than the conservative options.

The single-asset data reveals a critical lesson: concentration in any major cryptocurrency would have been devastating, while HYPE's exceptional Sharpe ratio reflects a rare momentum-driven outlier rather than a repeatable strategy. The best-performing diversified portfolios succeeded by blending a high-conviction position in HYPE with stable, lower-volatility assets like equities.

**Takeaway:** If you're committed to crypto exposure, limit it to a meaningful but minority position and anchor your portfolio with traditional equities—chasing pure crypto concentration would have destroyed capital this period, while thoughtful diversification preserved and even grew it.

Assets priced in BTC — 6 Months (normalised to 1.0 at each asset's first real data date · smoothed · 184 rows)

3.719 2.918 2.117 1.316 0.516 2025-12-26 2026-01-31 2026-03-09 2026-04-14 2026-05-21 2026-06-27 HYPE +242.6% GOOGL +59.5% SPX +48.8% GOLD +29.4% TSLA +15.7% JLP +5.2% ETH -20.5% SOL -21.7%

Assets priced in GOLD — 6 Months (normalised to 1.0 at each asset's first real data date · smoothed · 184 rows)

2.884 2.262 1.641 1.019 0.398 2025-12-26 2026-01-31 2026-03-09 2026-04-14 2026-05-21 2026-06-27 HYPE +165.1% GOOGL +23.3% SPX +15.0% TSLA -10.6% JLP -18.6% BTC -22.7% ETH -38.5% SOL -39.4%

Assets priced in SPX — 6 Months (normalised to 1.0 at each asset's first real data date · smoothed · 184 rows)

2.526 1.980 1.435 0.890 0.344 2025-12-26 2026-01-31 2026-03-09 2026-04-14 2026-05-21 2026-06-27 HYPE +130.4% GOOGL +7.2% GOLD -13.0% TSLA -22.2% JLP -29.3% BTC -32.8% ETH -46.6% SOL -47.4%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%
MinVar
SPX: 95.10%
GOLD: 4.90%
GOOGL: 0.00%
JLP: 0.00%
BTC: 0.00%
TSLA: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 20.09%
GOOGL: 19.41%
JLP: 10.50%
TSLA: 0.00%
BTC: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
HYPE: 48.83%
GOOGL: 29.94%
SPX: 21.23%
GOLD: 0.00%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -31.04%
ETH -46.03%
SOL -41.37%
HYPE 143.71%
GOLD -9.94%
SPX 6.12%
TSLA -20.09%
GOOGL 7.76%
JLP -23.37%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.922 0.894 0.393 0.123 0.468 0.345 0.178 0.932
ETH 0.922 1.000 0.900 0.455 0.143 0.483 0.321 0.178 0.931
SOL 0.894 0.900 1.000 0.431 0.075 0.434 0.317 0.142 0.986
HYPE 0.393 0.455 0.431 1.000 0.121 0.244 0.150 0.063 0.451
GOLD 0.123 0.143 0.075 0.121 1.000 0.299 0.230 0.210 0.116
SPX 0.468 0.483 0.434 0.244 0.299 1.000 0.641 0.568 0.450
TSLA 0.345 0.321 0.317 0.150 0.230 0.641 1.000 0.293 0.346
GOOGL 0.178 0.178 0.142 0.063 0.210 0.568 0.293 1.000 0.145
JLP 0.932 0.931 0.986 0.451 0.116 0.450 0.346 0.145 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -9.25% 34.61% -0.267 -19.12% -2.73% -4.07% -7.57%
MinVar 12.13% 13.84% 0.876 -9.30% -1.39% -1.69% 5.40%
MinVar-C50 2.46% 16.74% 0.147 -12.82% -1.39% -1.96% 0.52%
MaxSharpe 226.30% 50.57% 4.475 -16.05% -3.61% -4.79% 69.93%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC -46.26% 48.93% -0.945 -38.39% -3.80% -5.77% -31.04%
ETH -63.85% 65.09% -0.981 -53.35% -5.00% -7.98% -46.03%
SOL -56.98% 66.42% -0.858 -57.62% -5.72% -7.81% -41.37%
HYPE 843.37% 98.44% 8.567 -28.64% -6.91% -9.16% 143.71%
GOLD -13.96% 33.99% -0.411 -24.97% -3.07% -4.59% -9.94%
SPX 13.67% 13.93% 0.981 -9.10% -1.36% -1.71% 6.12%
TSLA -30.79% 39.89% -0.772 -27.77% -3.58% -4.66% -20.09%
GOOGL 21.44% 30.39% 0.706 -20.37% -2.39% -3.16% 7.76%
JLP -36.26% 40.18% -0.903 -35.56% -3.20% -4.67% -23.37%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 95.1%, GOLD 4.9%
  • Highest-return tested portfolio: MaxSharpe — HYPE 48.8%, GOOGL 29.9%, SPX 21.2%
  • Best risk-adjusted tested portfolio: MaxSharpe — HYPE 48.8%, GOOGL 29.9%, SPX 21.2%
  • Lowest-drawdown tested portfolio: MinVar — SPX 95.1%, GOLD 4.9%
  • Highest-return single asset: HYPE — 143.71%
  • Single-asset dominance ratio: 2.055x

12 Months

Window: 2025-06-27 → 2026-06-27 (366 rows)

Claude Narrative Report

**A Brutal Year for Crypto, a Banner Year for Tech**

Over the past twelve months, the crypto majors experienced a severe downturn while traditional assets and select tech names surged. Bitcoin, Ethereum, and Solana all posted deeply negative returns, with Solana losing nearly half its value amid crushing volatility. Meanwhile, Google delivered exceptional performance, nearly doubling in value, while the S&P 500 and gold provided steady, positive returns with far less turbulence. The standout crypto exception was HYPE, which gained substantially but came with stomach-churning swings and a drawdown exceeding sixty percent at its worst point.

**Diversification Proved Its Worth**

The portfolio data tells a compelling story about risk management. An equal-weight approach across all assets barely eked out a positive return and suffered a nearly thirty-percent drawdown — dragged down by heavy crypto exposure. However, the minimum-variance strategy, which concentrated heavily in the S&P 500 with a modest gold allocation, delivered solid returns with remarkably low volatility and a shallow drawdown. The maximum-Sharpe portfolio, dominated by Google with supporting positions in equities, gold, and a small HYPE allocation, achieved the best risk-adjusted performance by a wide margin, generating strong returns while keeping drawdowns manageable.

**Concentration Risk Cuts Both Ways**

Going all-in on any single crypto asset would have been devastating, with Bitcoin holders experiencing a drawdown exceeding fifty percent and Solana holders enduring a seventy-five percent peak-to-trough decline. Even HYPE, despite its strong final return, subjected investors to a gut-wrenching sixty-four percent drawdown along the way. Google was the lone single-asset bet that delivered both high returns and a superior Sharpe ratio, but that kind of outcome is difficult to predict in advance.

**Takeaway:** Rather than concentrating in crypto during uncertain periods, consider anchoring your portfolio in lower-volatility assets like broad equities and gold, then adding small, calculated positions in high-conviction crypto plays — this approach captured most of the upside while avoiding the catastrophic drawdowns that wiped out single-asset crypto holders.

Assets priced in BTC — 12 Months (normalised to 1.0 at each asset's first real data date · smoothed · 366 rows)

3.516 2.784 2.052 1.320 0.588 2025-06-27 2025-09-08 2025-11-20 2026-02-01 2026-04-15 2026-06-27 GOOGL +227.2% HYPE +162.5% GOLD +109.0% TSLA +98.7% SPX +89.7% JLP +28.9% ETH +19.8% SOL -16.8%

Assets priced in GOLD — 12 Months (normalised to 1.0 at each asset's first real data date · smoothed · 366 rows)

1.713 1.355 0.997 0.639 0.281 2025-06-27 2025-09-08 2025-11-20 2026-02-01 2026-04-15 2026-06-27 GOOGL +56.6% HYPE +24.8% TSLA -4.9% SPX -9.4% JLP -38.2% ETH -42.4% BTC -52.0% SOL -60.0%

Assets priced in SPX — 12 Months (normalised to 1.0 at each asset's first real data date · smoothed · 366 rows)

1.890 1.495 1.101 0.706 0.312 2025-06-27 2025-09-08 2025-11-20 2026-02-01 2026-04-15 2026-06-27 GOOGL +73.1% HYPE +37.3% GOLD +10.5% TSLA +5.1% JLP -31.6% ETH -36.2% BTC -46.8% SOL -55.7%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 11.11%
ETH: 11.11%
SOL: 11.11%
HYPE: 11.11%
GOLD: 11.11%
SPX: 11.11%
TSLA: 11.11%
GOOGL: 11.11%
JLP: 11.11%
MinVar
SPX: 90.70%
GOLD: 9.30%
GOOGL: 0.00%
JLP: 0.00%
BTC: 0.00%
TSLA: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 27.84%
GOOGL: 14.32%
JLP: 7.84%
BTC: 0.00%
TSLA: 0.00%
HYPE: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOOGL: 50.00%
SPX: 28.94%
GOLD: 14.70%
HYPE: 6.36%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -43.78%
ETH -34.86%
SOL -49.62%
HYPE 71.89%
GOLD 24.59%
SPX 19.13%
TSLA 17.33%
GOOGL 89.52%
JLP -21.44%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.860 0.830 0.495 0.131 0.467 0.334 0.177 0.897
ETH 0.860 1.000 0.878 0.543 0.124 0.479 0.346 0.228 0.911
SOL 0.830 0.878 1.000 0.563 0.106 0.432 0.330 0.178 0.981
HYPE 0.495 0.543 0.563 1.000 0.116 0.279 0.203 0.091 0.565
GOLD 0.131 0.124 0.106 0.116 1.000 0.249 0.169 0.213 0.130
SPX 0.467 0.479 0.432 0.279 0.249 1.000 0.585 0.554 0.454
TSLA 0.334 0.346 0.330 0.203 0.169 0.585 1.000 0.361 0.346
GOOGL 0.177 0.228 0.178 0.091 0.213 0.554 0.361 1.000 0.181
JLP 0.897 0.911 0.981 0.565 0.130 0.454 0.346 0.181 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 12.91% 35.13% 0.368 -28.88% -2.83% -3.94% 6.16%
MinVar 20.91% 12.22% 1.711 -9.49% -1.16% -1.57% 20.01%
MinVar-C50 28.15% 14.84% 1.897 -12.48% -1.18% -1.84% 26.75%
MaxSharpe 64.08% 20.30% 3.156 -13.23% -1.49% -2.04% 60.77%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC -38.30% 42.99% -0.891 -52.13% -3.66% -5.24% -43.78%
ETH -18.38% 67.23% -0.273 -67.61% -5.27% -7.80% -34.86%
SOL -34.74% 71.78% -0.484 -74.89% -5.66% -8.25% -49.62%
HYPE 169.67% 95.86% 1.770 -64.19% -7.00% -9.31% 71.89%
GOLD 29.52% 27.69% 1.066 -24.97% -2.38% -3.83% 24.59%
SPX 20.06% 12.48% 1.607 -9.10% -1.17% -1.62% 19.13%
TSLA 29.06% 43.71% 0.665 -29.93% -3.80% -5.24% 17.33%
GOOGL 97.82% 29.58% 3.307 -20.37% -2.18% -2.84% 89.52%
JLP -15.43% 38.40% -0.402 -46.05% -3.03% -4.39% -21.44%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 90.7%, GOLD 9.3%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 28.9%, GOLD 14.7%, HYPE 6.4%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 28.9%, GOLD 14.7%, HYPE 6.4%
  • Lowest-drawdown tested portfolio: MinVar — SPX 90.7%, GOLD 9.3%
  • Highest-return single asset: GOOGL — 89.52%
  • Single-asset dominance ratio: 1.473x

24 Months

Window: 2024-06-27 → 2026-06-27 (731 rows)

Claude Narrative Report

Over the past 24 months, major cryptocurrencies have been the portfolio's anchor—dragging returns down rather than driving them up. While equities like Tesla and Alphabet roughly doubled and gold delivered strong gains, Bitcoin essentially broke even and both Ethereum and Solana lost more than half their value. This period starkly illustrates that crypto's volatility cuts both ways, and during this window, it cut deep.

The portfolio analysis reveals a compelling case for diversification away from crypto-heavy allocations. The minimum variance portfolio, dominated by broad equities and gold with only trace crypto exposure, delivered nearly 48% returns with volatility less than one-fifth that of Solana. Meanwhile, the maximum Sharpe portfolio—which excluded crypto entirely in favor of gold, tech stocks, and the S&P 500—generated returns approaching gold's standalone performance but with far better risk-adjusted efficiency. Even the simple equal-weight approach outperformed a Bitcoin-only allocation by a wide margin while experiencing a much shallower drawdown.

What stands out most is that during this stretch, traditional assets weren't just safer—they were more rewarding. Gold in particular delivered equity-like returns with bond-like stability, while the major cryptocurrencies offered neither growth nor protection. The optimized portfolios found no reason to include meaningful crypto exposure because the risk simply wasn't being compensated.

**Takeaway:** If you're a crypto investor, this data argues strongly for treating digital assets as a small satellite position rather than a portfolio core—allocating the bulk of your capital to diversified traditional assets and limiting crypto to what you can afford to see cut in half.

Assets priced in BTC — 24 Months (normalised to 1.0 at each asset's first real data date · smoothed · 731 rows)

1.899 1.499 1.100 0.700 0.301 2024-06-27 2024-11-20 2025-04-15 2025-09-08 2026-02-01 2026-06-27 TSLA +73.2% GOLD +68.1% GOOGL +66.9% SPX +14.0% JLP +9.6% ETH -48.8% SOL -53.6%

Assets priced in GOLD — 24 Months (normalised to 1.0 at each asset's first real data date · smoothed · 731 rows)

1.549 1.201 0.854 0.506 0.158 2024-06-27 2024-11-20 2025-04-15 2025-09-08 2026-02-01 2026-06-27 TSLA +3.1% GOOGL -0.4% SPX -32.2% JLP -34.7% BTC -40.3% ETH -69.4% SOL -72.3%

Assets priced in SPX — 24 Months (normalised to 1.0 at each asset's first real data date · smoothed · 731 rows)

1.901 1.495 1.088 0.682 0.276 2024-06-27 2024-11-20 2025-04-15 2025-09-08 2026-02-01 2026-06-27 TSLA +52.1% GOLD +48.5% GOOGL +46.7% JLP -3.1% BTC -11.3% ETH -54.4% SOL -58.8%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 12.50%
ETH: 12.50%
SOL: 12.50%
GOLD: 12.50%
SPX: 12.50%
TSLA: 12.50%
GOOGL: 12.50%
JLP: 12.50%
MinVar
SPX: 67.39%
GOLD: 30.80%
JLP: 1.81%
GOOGL: 0.00%
BTC: 0.00%
SOL: 0.00%
TSLA: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 39.31%
JLP: 6.58%
GOOGL: 4.11%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 50.00%
GOOGL: 25.70%
SPX: 19.88%
TSLA: 4.41%
JLP: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -2.27%
ETH -54.17%
SOL -52.06%
GOLD 75.47%
SPX 34.13%
TSLA 92.34%
GOOGL 83.37%
JLP 17.11%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.829 0.796 0.085 0.398 0.350 0.259 0.846
ETH 0.829 1.000 0.796 0.057 0.430 0.369 0.293 0.849
SOL 0.796 0.796 1.000 0.050 0.357 0.315 0.226 0.955
GOLD 0.085 0.057 0.050 1.000 0.127 0.060 0.127 0.058
SPX 0.398 0.430 0.357 0.127 1.000 0.643 0.608 0.379
TSLA 0.350 0.369 0.315 0.060 0.643 1.000 0.466 0.328
GOOGL 0.259 0.293 0.226 0.127 0.608 0.466 1.000 0.242
JLP 0.846 0.849 0.955 0.058 0.379 0.328 0.242 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 18.95% 34.40% 0.551 -33.39% -2.65% -3.87% 25.78%
MinVar 22.88% 14.29% 1.601 -12.91% -1.13% -1.82% 47.95%
MinVar-C50 25.37% 14.73% 1.723 -12.07% -1.16% -1.87% 53.81%
MaxSharpe 34.84% 17.85% 1.952 -14.73% -1.42% -2.24% 76.13%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC 10.16% 46.62% 0.218 -52.13% -3.69% -5.26% -2.27%
ETH -13.14% 70.86% -0.185 -67.61% -5.57% -8.18% -54.17%
SOL -4.84% 79.91% -0.061 -76.25% -6.40% -8.78% -52.06%
GOLD 36.20% 23.48% 1.542 -24.97% -1.85% -3.20% 75.47%
SPX 17.40% 16.56% 1.051 -18.90% -1.38% -2.12% 34.13%
TSLA 66.53% 60.96% 1.091 -53.77% -4.72% -6.92% 92.34%
GOOGL 41.93% 30.80% 1.362 -29.81% -2.38% -3.61% 83.37%
JLP 16.42% 38.29% 0.429 -46.05% -2.96% -4.28% 17.11%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 67.4%, GOLD 30.8%, JLP 1.8%
  • Highest-return tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 25.7%, SPX 19.9%, TSLA 4.4%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 25.7%, SPX 19.9%, TSLA 4.4%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 39.3%, JLP 6.6%, GOOGL 4.1%
  • Highest-return single asset: TSLA — 92.34%
  • Single-asset dominance ratio: 1.213x

3 Years

Window: 2023-06-27 → 2026-06-27 (1097 rows)

Claude Narrative Report

## Portfolio Analysis: Three-Year Performance Review

Over the past three years, crypto markets delivered wildly divergent outcomes. Solana emerged as the standout performer, generating returns more than three times greater than Bitcoin, which itself nearly doubled. Ethereum, meanwhile, finished in negative territory—a stark reminder that not all major cryptocurrencies move in lockstep. Among traditional assets, Alphabet significantly outpaced the broader market index, while gold delivered steady, substantial gains that exceeded Bitcoin's return with far less turbulence.

The portfolio comparisons reveal a compelling case for diversification over concentration. While Solana's raw returns were unmatched, holding it alone meant enduring drawdowns exceeding three-quarters of portfolio value and volatility roughly five times higher than the optimized portfolios. The maximum Sharpe ratio portfolio, which leaned heavily into gold and traditional equities with only modest crypto exposure, delivered roughly half of Solana's return but with drastically superior risk-adjusted performance—its Sharpe ratio of 2.3 meaningfully exceeded even Solana's 1.55. The minimum variance approaches sacrificed some upside but kept drawdowns to around twelve percent, a fraction of what single-asset crypto holders experienced.

What stands out is how the best-performing optimized portfolios allocated capital: gold anchored nearly half the maximum Sharpe portfolio, with equities comprising most of the remainder and Solana representing less than seven percent. This construction captured meaningful crypto upside while traditional assets provided ballast during volatile stretches.

**Takeaway:** Rather than concentrating in any single cryptocurrency—even a top performer—crypto investors should consider anchoring portfolios with stable assets like gold and broad equities, then adding selective crypto exposure; this approach historically delivered stronger risk-adjusted returns and far shallower drawdowns than going all-in on digital assets alone.

Assets priced in BTC — 3 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1097 rows · dotted = backfilled prefix: JLP)

4.881 3.657 2.432 1.208 -0.016 2023-06-27 2024-02-01 2024-09-07 2025-04-14 2025-11-19 2026-06-27 SOL +115.4% GOOGL +25.6% JLP +24.4% (from 2023-12-20) GOLD +6.5% SPX -29.6% TSLA -30.9% ETH -52.9%

Assets priced in GOLD — 3 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1097 rows · dotted = backfilled prefix: JLP)

8.630 6.397 4.165 1.933 -0.300 2023-06-27 2024-02-01 2024-09-07 2025-04-14 2025-11-19 2026-06-27 SOL +103.3% GOOGL +19.1% BTC -5.3% JLP -12.2% (from 2023-12-20) SPX -33.6% TSLA -34.8% ETH -55.5%

Assets priced in SPX — 3 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1097 rows · dotted = backfilled prefix: JLP)

8.826 6.596 4.367 2.138 -0.091 2023-06-27 2024-02-01 2024-09-07 2025-04-14 2025-11-19 2026-06-27 SOL +209.0% GOOGL +78.5% GOLD +52.1% BTC +43.2% JLP +34.2% (from 2023-12-20) TSLA -1.6% ETH -32.4%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 12.50%
ETH: 12.50%
SOL: 12.50%
GOLD: 12.50%
SPX: 12.50%
TSLA: 12.50%
GOOGL: 12.50%
JLP: 12.50%
MinVar
SPX: 64.28%
GOLD: 31.95%
JLP: 3.77%
GOOGL: 0.00%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 39.62%
JLP: 8.04%
GOOGL: 2.34%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 47.88%
GOOGL: 24.47%
SPX: 20.87%
SOL: 6.78%
JLP: 0.00%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 96.18%
ETH -16.45%
SOL 331.06%
GOLD 113.10%
SPX 67.96%
TSLA 51.76%
GOOGL 187.65%
JLP 85.03%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.810 0.734 0.073 0.334 0.277 0.185 0.729
ETH 0.810 1.000 0.715 0.070 0.376 0.292 0.236 0.771
SOL 0.734 0.715 1.000 0.036 0.302 0.231 0.194 0.783
GOLD 0.073 0.070 0.036 1.000 0.130 0.054 0.106 0.063
SPX 0.334 0.376 0.302 0.130 1.000 0.592 0.588 0.344
TSLA 0.277 0.292 0.231 0.054 0.592 1.000 0.382 0.276
GOOGL 0.185 0.236 0.194 0.106 0.588 0.382 1.000 0.197
JLP 0.729 0.771 0.783 0.063 0.344 0.276 0.197 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 40.80% 31.61% 1.291 -33.39% -2.51% -3.57% 140.68%
MinVar 24.02% 12.78% 1.880 -12.66% -0.95% -1.59% 86.27%
MinVar-C50 25.90% 13.06% 1.983 -12.08% -0.99% -1.64% 94.66%
MaxSharpe 38.11% 16.55% 2.302 -15.46% -1.32% -2.03% 153.06%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC 39.56% 46.81% 0.845 -52.13% -3.68% -5.32% 96.18%
ETH 16.60% 65.67% 0.253 -67.61% -5.19% -7.51% -16.45%
SOL 130.66% 84.22% 1.551 -76.25% -6.17% -8.61% 331.06%
GOLD 31.44% 20.62% 1.525 -24.97% -1.52% -2.78% 113.10%
SPX 20.18% 14.97% 1.348 -18.90% -1.23% -1.89% 67.96%
TSLA 35.30% 57.56% 0.613 -53.77% -4.43% -6.59% 51.76%
GOOGL 48.58% 29.78% 1.631 -29.81% -2.29% -3.52% 187.65%
JLP 29.56% 32.94% 0.897 -46.05% -2.61% -3.82% 85.03%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 64.3%, GOLD 32.0%, JLP 3.8%
  • Highest-return tested portfolio: MaxSharpe — GOLD 47.9%, GOOGL 24.5%, SPX 20.9%, SOL 6.8%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 47.9%, GOOGL 24.5%, SPX 20.9%, SOL 6.8%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 39.6%, JLP 8.0%, GOOGL 2.3%
  • Highest-return single asset: SOL — 331.06%
  • Single-asset dominance ratio: 2.163x

4 Years

Window: 2022-06-28 → 2026-06-27 (1461 rows)

Claude Narrative Report

Over the past four years, the crypto assets in this dataset delivered a tale of two extremes. Bitcoin nearly tripled in value and matched the best-performing traditional stock, but it came with gut-wrenching volatility and a drawdown that cut portfolios in half at its worst. Ethereum and Solana fared far worse on a risk-adjusted basis—both endured catastrophic drawdowns exceeding sixty percent while delivering returns that lagged gold and even the broad market. For a crypto investor, this period was a stark reminder that headline returns mean little if you can't stomach the ride down.

The portfolio analysis reveals something counterintuitive: simply spreading money equally across all seven assets captured nearly all of Bitcoin's upside while cutting volatility by almost a third. However, the smarter approach was the maximum Sharpe portfolio, which leaned heavily into gold and traditional equities while keeping only a modest Bitcoin allocation and virtually no exposure to altcoins. This blend delivered returns fifty percent higher than the S&P 500 with comparable volatility and a fraction of the drawdown risk that pure crypto holders experienced. The minimum variance portfolios, which excluded crypto almost entirely, offered the smoothest ride with the shallowest losses during downturns.

The single-asset dominance ratio of just over one tells the critical story: no individual holding meaningfully outperformed a well-constructed diversified portfolio. Google matched Bitcoin's return with far less pain, and gold quietly outpaced three of the four crypto assets while letting investors sleep at night. The practical takeaway is clear—if you want crypto exposure, size it small within a diversified portfolio rather than concentrating; a five-to-ten percent Bitcoin allocation captured meaningful upside in the optimized portfolio while letting traditional assets do the heavy lifting on risk management.

Assets priced in BTC — 4 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1461 rows)

1.466 1.146 0.826 0.507 0.187 2022-06-28 2023-04-16 2024-02-02 2024-11-20 2025-09-08 2026-06-27 GOOGL -16.8% GOLD -29.0% SOL -29.5% ETH -46.9% SPX -49.3% TSLA -52.0%

Assets priced in GOLD — 4 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1461 rows)

3.819 2.929 2.039 1.149 0.258 2022-06-28 2023-04-16 2024-02-02 2024-11-20 2025-09-08 2026-06-27 BTC +43.5% GOOGL +18.2% SOL +2.0% ETH -23.3% SPX -28.2% TSLA -31.9%

Assets priced in SPX — 4 Years (normalised to 1.0 at each asset's first real data date · smoothed · 1461 rows)

3.585 2.752 1.920 1.087 0.255 2022-06-28 2023-04-16 2024-02-02 2024-11-20 2025-09-08 2026-06-27 BTC +100.5% GOOGL +64.0% SOL +43.0% GOLD +40.4% ETH +7.5% TSLA -4.9%

Allocation Model Guide

Equal: splits capital evenly across all selected assets. This is the neutral benchmark.

MinVar: the unconstrained minimum-variance portfolio. It seeks the lowest historical variance and is allowed to put 100% into one asset if that appears safest.

MinVar-C50: also a minimum-variance portfolio, but no asset may exceed 50%. This forces more diversification and is usually more practical.

MaxSharpe: the offensive portfolio. Maximises return per unit of risk (Sharpe ratio), capped at 50% per asset. Where MinVar and MinVar-C50 ask "how do I lose least?", MaxSharpe asks "how do I earn most efficiently?"

How to read this: when MaxSharpe and MinVar-C50 agree on weights, the signal is strong — the market is rewarding diversification. When they diverge sharply, the market is in a momentum-driven regime favouring concentration.

Exact allocations for this timeframe

Equal
BTC: 14.29%
ETH: 14.29%
SOL: 14.29%
GOLD: 14.29%
SPX: 14.29%
TSLA: 14.29%
GOOGL: 14.29%
MinVar
SPX: 60.41%
GOLD: 39.59%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 48.80%
BTC: 0.68%
GOOGL: 0.52%
ETH: 0.00%
TSLA: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 48.40%
SPX: 27.46%
GOOGL: 16.13%
BTC: 7.62%
SOL: 0.39%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 196.86%
ETH 37.95%
SOL 102.79%
GOLD 124.41%
SPX 92.44%
TSLA 63.20%
GOOGL 203.89%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL
BTC 1.000 0.825 0.743 0.106 0.361 0.279 0.243
ETH 0.825 1.000 0.729 0.092 0.382 0.286 0.268
SOL 0.743 0.729 1.000 0.067 0.315 0.232 0.232
GOLD 0.106 0.092 0.067 1.000 0.151 0.044 0.119
SPX 0.361 0.382 0.315 0.151 1.000 0.569 0.642
TSLA 0.279 0.286 0.232 0.044 0.569 1.000 0.382
GOOGL 0.243 0.268 0.232 0.119 0.642 0.382 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 38.85% 34.03% 1.142 -39.86% -2.58% -3.86% 195.11%
MinVar 21.43% 13.29% 1.613 -13.30% -1.01% -1.66% 109.91%
MinVar-C50 22.20% 13.50% 1.644 -12.66% -1.06% -1.70% 115.01%
MaxSharpe 27.14% 15.24% 1.781 -14.77% -1.24% -1.89% 149.46%

Single-Asset Comparison

This table answers the question: "What if I held 100% of just one asset?"

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
BTC 47.41% 48.28% 0.982 -52.13% -3.65% -5.51% 196.86%
ETH 35.33% 66.92% 0.528 -67.61% -5.15% -7.78% 37.95%
SOL 80.62% 90.90% 0.887 -79.24% -6.52% -9.72% 102.79%
GOLD 24.72% 19.34% 1.278 -24.97% -1.49% -2.53% 124.41%
SPX 19.32% 16.17% 1.195 -18.90% -1.35% -1.98% 92.44%
TSLA 33.72% 58.24% 0.579 -65.05% -4.78% -6.96% 63.20%
GOOGL 38.75% 31.57% 1.227 -31.66% -2.41% -3.76% 203.89%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 60.4%, GOLD 39.6%
  • Highest-return tested portfolio: Equal — BTC 14.3%, ETH 14.3%, SOL 14.3%, GOLD 14.3%, SPX 14.3%, TSLA 14.3%, GOOGL 14.3%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 48.4%, SPX 27.5%, GOOGL 16.1%, BTC 7.6%, SOL 0.4%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 48.8%, BTC 0.7%, GOOGL 0.5%
  • Highest-return single asset: GOOGL — 203.89%
  • Single-asset dominance ratio: 1.045x