Portfolio Analysis Report — 06-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-07 → 2026-06-06

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,694.00 5.5 -22.32% -9.80% -20.19% Oversold / Recovering
ETH 1,559.74 4.2 -28.44% -24.48% -28.22% Oversold / Recovering
SOL 62.10 2.5 -28.24% -23.15% -26.50% Oversold / Recovering
HYPE 58.98 50.3 40.93% 61.46% 18.64% Bullish
GOLD 4,337.10 32.2 -4.80% -6.76% -5.75% Bearish
SPX 7,383.74 39.4 -0.33% 12.17% 0.36% Mixed
TSLA 391.00 28.9 -7.40% 8.43% -4.65% Oversold / Recovering
GOOGL 368.53 36.9 -7.12% 24.60% -2.01% Bearish
JLP 3.20 2.2 -18.39% -12.48% -17.02% Oversold / Recovering

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 GOLD 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 MaxSharpe GOOGL MinVar MinVar-C50 MaxSharpe

Min-Variance Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 0.00% 0.00% 0.00% 2.72% 0.00% 81.06% 0.00% 16.22% 0.00%
1 Month 0.00% 0.00% 0.00% 0.00% 0.00% 93.90% 0.00% 6.10% 0.00%
3 Months 0.00% 0.00% 0.00% 0.00% 4.39% 91.14% 0.00% 0.00% 4.47%
6 Months 0.00% 0.00% 0.00% 0.00% 5.39% 94.61% 0.00% 0.00% 0.00%
12 Months 0.00% 0.00% 0.00% 0.00% 10.52% 89.48% 0.00% 0.00% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 31.32% 66.69% 0.00% 0.00% 2.00%
3 Years 0.00% 0.00% 0.00% nan% 32.85% 63.01% 0.00% 0.00% 4.14%
4 Years 0.00% 0.00% 0.00% nan% 41.93% 58.07% 0.00% 0.00% nan%

MinVar-C50 Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 0.00% 0.00% 0.00% 4.75% 24.96% 50.00% 0.00% 20.29% 0.00%
1 Month 0.00% 0.00% 0.00% 0.00% 35.42% 50.00% 0.00% 14.15% 0.43%
3 Months 0.00% 0.00% 0.00% 0.00% 28.38% 50.00% 0.00% 1.21% 20.42%
6 Months 0.00% 0.00% 0.00% 0.00% 21.27% 50.00% 0.86% 17.71% 10.16%
12 Months 0.00% 0.00% 0.00% 0.00% 29.05% 50.00% 0.00% 13.56% 7.39%
24 Months 0.00% 0.00% 0.00% nan% 39.63% 50.00% 0.00% 3.78% 6.59%
3 Years 0.00% 0.00% 0.00% nan% 40.08% 50.00% 0.00% 1.78% 8.14%
4 Years 0.01% 0.00% 0.00% nan% 49.99% 50.00% 0.00% 0.00% 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% 29.71% 0.00% 20.29% 0.00% 50.00% 0.00%
6 Months 0.00% 0.00% 0.00% 25.47% 0.00% 34.31% 0.00% 40.23% 0.00%
12 Months 0.00% 0.00% 0.00% 4.96% 16.42% 28.62% 0.00% 50.00% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 50.00% 13.26% 4.98% 31.76% 0.00%
3 Years 1.15% 0.00% 4.19% nan% 47.56% 25.55% 0.00% 21.55% 0.00%
4 Years 0.58% 0.00% 2.50% nan% 50.00% 24.75% 0.00% 22.17% nan%

Stable Allocation Band

Min Avg Max Times > 20% Times < 1%
BTC 0.00% 0.00% 0.01% 0 8
ETH 0.00% 0.00% 0.00% 0 8
SOL 0.00% 0.00% 0.00% 0 8
HYPE 0.00% 0.95% 4.75% 0 4
GOLD 21.27% 33.60% 49.99% 8 0
SPX 50.00% 50.00% 50.00% 8 0
TSLA 0.00% 0.11% 0.86% 0 8
GOOGL 0.00% 9.06% 20.29% 1 1
JLP 0.00% 7.59% 20.42% 1 2

1 Day

Window: 2026-06-05 → 2026-06-06 (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.38%
ETH -1.34%
SOL -2.18%
HYPE -1.02%
GOLD 0.00%
SPX 0.00%
TSLA 0.00%
GOOGL 0.00%
JLP -1.00%

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 -74.65% nan% nan 0.00% -0.38% -0.38% -0.38%
ETH -99.26% nan% nan 0.00% -1.34% -1.34% -1.34%
SOL -99.97% nan% nan 0.00% -2.18% -2.18% -2.18%
HYPE -97.59% nan% nan 0.00% -1.02% -1.02% -1.02%
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 -97.47% nan% nan 0.00% -1.00% -1.00% -1.00%

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

1.022 1.009 0.996 0.984 0.971 2026-06-05 2026-06-06 GOLD +0.2% SPX +0.2% TSLA +0.2% GOOGL +0.2% JLP -0.3% HYPE -0.3% ETH -0.5% SOL -0.9%

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

1.020 1.007 0.995 0.982 0.969 2026-06-05 2026-06-06 SPX +0.0% TSLA +0.0% GOOGL +0.0% BTC -0.2% JLP -0.5% HYPE -0.5% ETH -0.7% SOL -1.1%

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

1.020 1.007 0.995 0.982 0.969 2026-06-05 2026-06-06 GOLD +0.0% TSLA +0.0% GOOGL +0.0% BTC -0.2% JLP -0.5% HYPE -0.5% ETH -0.7% SOL -1.1%

1 Week

Window: 2026-05-30 → 2026-06-06 (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

The past week delivered a broad market selloff, but the pain was distributed unevenly across asset classes. Traditional equities held up relatively well, with the S&P 500 and Google experiencing only modest single-digit declines. Cryptocurrencies, however, bore the brunt of the downturn, with Solana and Ethereum each shedding roughly a quarter of their value, while Bitcoin lost nearly a fifth. Even gold, typically a defensive haven, slipped meaningfully, suggesting this was a risk-off environment where few places offered genuine shelter.

Portfolio construction made a substantial difference in limiting damage. The minimum-variance strategy, which leaned heavily into the S&P 500 with small allocations to Google and a tiny slice of HYPE, lost only about three percent—far less painful than an equal-weight approach or a single-asset crypto bet. This defensive posture came with lower volatility and a shallower drawdown, demonstrating that tilting toward less volatile traditional assets cushioned the blow effectively. Meanwhile, pure crypto portfolios suffered double-digit losses and exhibited dramatically higher volatility, offering the worst risk-adjusted outcomes of the group.

The data reinforces a familiar lesson during turbulent stretches: concentrated crypto exposure amplifies both upside potential and downside risk, and last week showcased the latter in full. When correlations rise and everything sells off together, diversification into lower-volatility traditional assets provides meaningful protection. **Practical takeaway:** In weeks like this, having a substantial anchor in traditional equities—rather than going all-in on digital assets—can cut your losses by more than two-thirds while you wait for clearer skies.

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

1.221 1.140 1.058 0.977 0.895 2026-05-30 2026-05-31 2026-06-01 2026-06-03 2026-06-04 2026-06-06 SPX +18.1% GOOGL +17.5% GOLD +15.3% TSLA +8.8% HYPE +5.4% JLP +2.9% ETH -5.7% SOL -7.7%

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

1.109 1.024 0.940 0.856 0.772 2026-05-30 2026-05-31 2026-06-01 2026-06-03 2026-06-04 2026-06-06 SPX +2.4% GOOGL +1.9% TSLA -5.7% HYPE -8.6% JLP -10.8% BTC -13.3% ETH -18.2% SOL -20.0%

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

1.093 1.008 0.923 0.838 0.753 2026-05-30 2026-05-31 2026-06-01 2026-06-03 2026-06-04 2026-06-06 GOOGL -0.5% GOLD -2.4% TSLA -7.9% HYPE -10.8% JLP -12.9% BTC -15.4% ETH -20.2% SOL -21.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: 81.06%
GOOGL: 16.22%
HYPE: 2.72%
GOLD: 0.00%
JLP: 0.00%
BTC: 0.00%
TSLA: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 24.96%
GOOGL: 20.29%
HYPE: 4.75%
JLP: 0.00%
TSLA: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 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 -17.71%
ETH -22.76%
SOL -24.77%
HYPE -13.54%
GOLD -4.90%
SPX -2.59%
TSLA -10.28%
GOOGL -3.11%
JLP -15.57%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.675 0.770 0.008 0.418 0.386 0.076 0.801 0.845
ETH 0.675 1.000 0.913 0.469 0.429 0.756 0.316 0.407 0.925
SOL 0.770 0.913 1.000 0.570 0.177 0.471 0.076 0.437 0.988
HYPE 0.008 0.469 0.570 1.000 -0.187 0.081 0.209 -0.372 0.473
GOLD 0.418 0.429 0.177 -0.187 1.000 0.793 0.835 0.311 0.298
SPX 0.386 0.756 0.471 0.081 0.793 1.000 0.630 0.196 0.531
TSLA 0.076 0.316 0.076 0.209 0.835 0.630 1.000 -0.128 0.147
GOOGL 0.801 0.407 0.437 -0.372 0.311 0.196 -0.128 1.000 0.522
JLP 0.845 0.925 0.988 0.473 0.298 0.531 0.147 0.522 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -99.92% 38.32% -2.608 -13.28% -4.89% -5.36% -12.88%
MinVar -78.33% 19.26% -4.067 -3.16% -1.95% -2.50% -2.92%
MinVar-C50 -85.83% 19.96% -4.299 -3.96% -2.11% -2.64% -3.71%
MaxSharpe -99.92% 38.32% -2.608 -13.28% -4.89% -5.36% -12.88%

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 -100.00% 47.12% -2.122 -17.51% -5.88% -6.47% -17.71%
ETH -100.00% 74.82% -1.337 -22.18% -9.64% -10.66% -22.76%
SOL -100.00% 59.18% -1.690 -24.54% -8.28% -8.56% -24.77%
HYPE -99.87% 141.35% -0.707 -20.87% -11.81% -13.73% -13.54%
GOLD -92.48% 26.84% -3.445 -4.90% -2.73% -3.10% -4.90%
SPX -74.08% 20.39% -3.634 -2.97% -2.07% -2.64% -2.59%
TSLA -99.60% 56.94% -1.749 -10.28% -5.96% -6.56% -10.28%
GOOGL -79.13% 42.58% -1.858 -5.61% -3.01% -3.86% -3.11%
JLP -99.98% 36.99% -2.703 -15.46% -5.09% -5.19% -15.57%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 81.1%, GOOGL 16.2%, HYPE 2.7%
  • Highest-return tested portfolio: MinVar — SPX 81.1%, GOOGL 16.2%, HYPE 2.7%
  • 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 81.1%, GOOGL 16.2%, HYPE 2.7%
  • Highest-return single asset: SPX — -2.59%
  • Single-asset dominance ratio: 0.887x

1 Month

Window: 2026-05-07 → 2026-06-06 (31 rows)

Claude Narrative Report

# Portfolio Analysis: One-Month Review

The past month delivered a stark reminder of crypto's volatility. Major digital assets suffered severe losses, with Ethereum and Solana each dropping roughly a third of their value while Bitcoin fell nearly a quarter. This broad crypto selloff contrasted sharply with traditional equities, where the S&P 500 held essentially flat. The standout performer was HYPE, which surged nearly forty percent—though investors should note this came with extreme volatility that more than doubled any other asset in the sample.

When examining portfolio strategies, the results reveal a clear tension between safety and opportunity. The minimum variance approach, dominated by S&P 500 exposure with a small allocation to Google, essentially broke even while limiting drawdowns to under three percent—a defensive posture that worked during this crypto downturn. The maximum Sharpe portfolio, however, told a different story: by splitting exposure between the S&P 500 and HYPE, it captured impressive gains approaching twenty percent despite a significant drawdown. The equal-weight approach, dragged down by heavy crypto losses, demonstrated why passive diversification across volatile assets can backfire during correlated selloffs.

Single-asset analysis reinforces a critical insight: holding any major cryptocurrency alone would have produced both substantial losses and painful drawdowns exceeding twenty-five percent. Even gold, typically a safe haven, declined meaningfully. The dominance ratio suggests the optimized portfolio meaningfully outperformed simply holding the best single asset on a risk-adjusted basis, highlighting the value of strategic allocation over conviction bets.

**Takeaway:** In turbulent markets, pairing a volatile high-conviction crypto position with a stable anchor like broad equity exposure can capture upside while dramatically reducing portfolio drawdowns—pure crypto concentration remains a costly gamble.

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

2.045 1.744 1.443 1.141 0.840 2026-05-07 2026-05-13 2026-05-19 2026-05-25 2026-05-31 2026-06-06 HYPE +94.0% SPX +30.8% TSLA +26.5% GOLD +20.1% GOOGL +18.4% JLP +7.3% SOL -3.6% ETH -6.0%

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

1.797 1.521 1.244 0.968 0.691 2026-05-07 2026-05-13 2026-05-19 2026-05-25 2026-05-31 2026-06-06 HYPE +61.7% SPX +8.9% TSLA +5.4% GOOGL -1.4% JLP -10.6% BTC -16.7% SOL -19.7% ETH -21.6%

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

1.668 1.409 1.151 0.892 0.633 2026-05-07 2026-05-13 2026-05-19 2026-05-25 2026-05-31 2026-06-06 HYPE +48.4% TSLA -3.3% GOLD -8.2% GOOGL -9.5% JLP -17.9% BTC -23.5% SOL -26.2% ETH -28.1%

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: 93.90%
GOOGL: 6.10%
GOLD: 0.00%
BTC: 0.00%
JLP: 0.00%
TSLA: 0.00%
SOL: 0.00%
ETH: 0.00%
HYPE: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 35.42%
GOOGL: 14.15%
JLP: 0.43%
BTC: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
TSLA: 0.00%
MaxSharpe ▲
SPX: 50.00%
HYPE: 50.00%
GOOGL: 0.00%
GOLD: 0.00%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -24.14%
ETH -31.92%
SOL -29.75%
HYPE 38.75%
GOLD -7.72%
SPX 0.64%
TSLA -5.05%
GOOGL -7.40%
JLP -19.48%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.827 0.851 0.450 0.459 0.432 0.231 0.315 0.899
ETH 0.827 1.000 0.881 0.523 0.495 0.624 0.323 0.252 0.906
SOL 0.851 0.881 1.000 0.576 0.400 0.503 0.359 0.131 0.993
HYPE 0.450 0.523 0.576 1.000 0.185 0.267 0.116 -0.129 0.561
GOLD 0.459 0.495 0.400 0.185 1.000 0.755 0.634 0.239 0.443
SPX 0.432 0.624 0.503 0.267 0.755 1.000 0.713 0.304 0.524
TSLA 0.231 0.323 0.359 0.116 0.634 0.713 1.000 0.132 0.362
GOOGL 0.315 0.252 0.131 -0.129 0.239 0.304 0.132 1.000 0.177
JLP 0.899 0.906 0.993 0.561 0.443 0.524 0.362 0.177 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -74.00% 32.38% -2.285 -13.48% -3.08% -4.57% -10.86%
MinVar 2.62% 12.93% 0.202 -2.79% -1.02% -1.88% 0.15%
MinVar-C50 -35.22% 14.22% -2.477 -4.62% -1.40% -2.14% -3.58%
MaxSharpe 983.09% 61.95% 15.868 -11.77% -4.06% -5.82% 19.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 -96.29% 36.48% -2.640 -26.11% -4.30% -5.49% -24.14%
ETH -98.95% 49.42% -2.002 -34.16% -5.40% -8.96% -31.92%
SOL -98.43% 53.90% -1.826 -36.21% -6.01% -8.09% -29.75%
HYPE 10517.21% 119.78% 87.802 -20.87% -6.83% -10.53% 38.75%
GOLD -61.71% 18.69% -3.302 -8.12% -2.28% -2.86% -7.72%
SPX 8.91% 13.05% 0.683 -2.97% -1.01% -1.94% 0.64%
TSLA -40.89% 46.16% -0.886 -12.19% -4.67% -5.66% -5.05%
GOOGL -59.01% 30.08% -1.962 -10.84% -2.80% -3.45% -7.40%
JLP -92.45% 32.59% -2.837 -23.63% -3.69% -5.02% -19.48%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 93.9%, GOOGL 6.1%
  • Highest-return tested portfolio: MaxSharpe — SPX 50.0%, HYPE 50.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — SPX 50.0%, HYPE 50.0%
  • Lowest-drawdown tested portfolio: MinVar — SPX 93.9%, GOOGL 6.1%
  • Highest-return single asset: HYPE — 38.75%
  • Single-asset dominance ratio: 1.956x

3 Months

Window: 2026-03-07 → 2026-06-06 (92 rows)

Claude Narrative Report

Over the past three months, the crypto market broadly struggled while a few outliers thrived. Major tokens like Bitcoin, Ethereum, and Solana all posted double-digit losses, with Solana falling the hardest. Meanwhile, HYPE nearly doubled in value, dramatically outpacing everything else in the sample—including traditional assets like the S&P 500 and Google, which both delivered solid positive returns. Gold and the JLP token also declined, making this a challenging period for anyone holding a conventional crypto-heavy allocation.

The portfolio analysis reveals a stark contrast between strategies. An equal-weight approach across all assets barely broke even, weighed down by crypto's weakness. The minimum variance portfolio, dominated by S&P 500 exposure with small allocations to JLP and gold, delivered steady returns with the lowest drawdown and reasonable risk-adjusted performance. However, the maximum Sharpe portfolio—concentrated in Google, HYPE, and the S&P 500—generated exceptional results, returning over forty percent despite higher volatility. Notably, this optimized blend outperformed even holding HYPE alone on a risk-adjusted basis, demonstrating the power of diversification even when one asset dominates.

For single-asset holders, the data is sobering. Holding only Bitcoin or Ethereum meant absorbing severe drawdowns exceeding a quarter of portfolio value, with negative risk-adjusted returns. HYPE delivered extraordinary raw gains, but its extreme volatility made it a white-knuckle ride. Traditional equities, particularly the S&P 500 and Google, offered far better stability relative to their returns.

**Takeaway:** Rather than concentrating in major cryptocurrencies during volatile periods, crypto investors should consider blending high-momentum tokens with stable equity exposure—a mix like the maximum Sharpe portfolio captured most of the upside while cutting drawdown risk nearly in half compared to holding volatile single assets alone.

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

2.240 1.837 1.434 1.031 0.628 2026-03-07 2026-03-25 2026-04-12 2026-04-30 2026-05-18 2026-06-06 HYPE +110.5% GOOGL +23.0% SPX +9.2% TSLA +4.1% JLP -4.2% ETH -6.8% SOL -11.1% GOLD -15.2%

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

2.628 2.185 1.743 1.300 0.857 2026-03-07 2026-03-25 2026-04-12 2026-04-30 2026-05-18 2026-06-06 HYPE +148.0% GOOGL +45.1% SPX +28.7% TSLA +22.9% BTC +18.5% JLP +13.3% ETH +10.5% SOL +5.4%

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

2.042 1.697 1.352 1.007 0.662 2026-03-07 2026-03-25 2026-04-12 2026-04-30 2026-05-18 2026-06-06 HYPE +92.7% GOOGL +12.8% TSLA -4.5% BTC -7.9% JLP -11.9% ETH -14.1% SOL -18.0% GOLD -22.3%

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: 91.14%
JLP: 4.47%
GOLD: 4.39%
BTC: 0.00%
HYPE: 0.00%
SOL: 0.00%
GOOGL: 0.00%
TSLA: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 28.38%
JLP: 20.42%
GOOGL: 1.21%
BTC: 0.00%
TSLA: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 50.00%
HYPE: 29.71%
SPX: 20.29%
TSLA: 0.00%
GOLD: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -9.78%
ETH -20.80%
SOL -25.34%
HYPE 94.66%
GOLD -15.72%
SPX 9.55%
TSLA -1.44%
GOOGL 23.54%
JLP -12.65%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.903 0.872 0.435 0.181 0.414 0.279 0.305 0.925
ETH 0.903 1.000 0.862 0.486 0.206 0.437 0.330 0.260 0.914
SOL 0.872 0.862 1.000 0.473 0.098 0.350 0.282 0.161 0.989
HYPE 0.435 0.486 0.473 1.000 0.093 0.180 0.139 -0.032 0.487
GOLD 0.181 0.206 0.098 0.093 1.000 0.484 0.423 0.394 0.135
SPX 0.414 0.437 0.350 0.180 0.484 1.000 0.627 0.647 0.380
TSLA 0.279 0.330 0.282 0.139 0.423 0.627 1.000 0.382 0.303
GOOGL 0.305 0.260 0.161 -0.032 0.394 0.647 0.382 1.000 0.201
JLP 0.925 0.914 0.989 0.487 0.135 0.380 0.303 0.201 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 12.87% 30.26% 0.425 -13.48% -2.30% -3.56% 1.90%
MinVar 34.12% 15.02% 2.271 -6.58% -1.40% -1.82% 7.29%
MinVar-C50 -8.02% 16.85% -0.476 -7.77% -1.48% -2.34% -2.41%
MaxSharpe 322.42% 33.21% 9.708 -10.14% -2.19% -2.83% 41.31%

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 -28.65% 38.90% -0.737 -26.11% -3.55% -4.44% -9.78%
ETH -54.79% 53.29% -1.028 -35.58% -3.95% -6.39% -20.80%
SOL -64.40% 52.91% -1.217 -36.21% -4.03% -6.17% -25.34%
HYPE 2019.85% 88.96% 22.705 -20.87% -5.72% -8.31% 94.66%
GOLD -47.65% 27.88% -1.709 -17.07% -2.68% -3.85% -15.72%
SPX 45.81% 15.12% 3.030 -6.65% -1.44% -1.82% 9.55%
TSLA 3.15% 42.50% 0.074 -15.83% -3.57% -4.98% -1.44%
GOOGL 148.58% 36.04% 4.123 -12.04% -2.43% -3.34% 23.54%
JLP -38.67% 32.85% -1.177 -23.63% -2.51% -3.83% -12.65%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 91.1%, JLP 4.5%, GOLD 4.4%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 50.0%, HYPE 29.7%, SPX 20.3%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 50.0%, HYPE 29.7%, SPX 20.3%
  • Lowest-drawdown tested portfolio: MinVar — SPX 91.1%, JLP 4.5%, GOLD 4.4%
  • Highest-return single asset: HYPE — 94.66%
  • Single-asset dominance ratio: 2.292x

6 Months

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

Claude Narrative Report

## Portfolio Analysis: 6-Month Performance Review

The past six months delivered a stark reality check for crypto-heavy investors. While one standout token posted exceptional gains, the broader crypto market suffered significantly, with major assets losing between a third and half their value. Traditional assets told a different story—equities and gold held steady or advanced modestly, demonstrating their role as portfolio stabilizers during crypto downturns.

The portfolio construction exercise reveals a compelling case for diversification over crypto concentration. An equal-weight approach across all assets still posted losses due to crypto drag, but the optimized strategies performed dramatically better. The minimum variance portfolio, anchored almost entirely in broad equities with a small gold allocation, delivered positive returns with less than a quarter of the volatility seen in pure crypto holdings. The maximum Sharpe portfolio found its edge by blending traditional tech exposure with a measured position in the top-performing token, achieving returns that far exceeded any single major cryptocurrency while keeping drawdowns manageable around ten percent.

The single-asset data underscores a dangerous asymmetry in crypto investing: the winning token's volatility approached one hundred percent annualized, meaning that spectacular gain came with stomach-churning swings and a drawdown exceeding thirty percent along the way. Meanwhile, holding Bitcoin, Ethereum, or Solana alone resulted in deep losses with even deeper peak-to-trough drops.

**Takeaway:** Rather than concentrating in any single cryptocurrency, crypto investors should consider capping their exposure and pairing it with lower-volatility assets like broad market equities—this approach captured meaningful upside from the best-performing token while dramatically reducing portfolio damage when the rest of the crypto market sold off.

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

2.486 2.010 1.534 1.059 0.583 2025-12-05 2026-01-10 2026-02-16 2026-03-24 2026-04-30 2026-06-06 HYPE +132.7% GOOGL +46.1% SPX +33.6% GOLD +31.0% TSLA +13.7% JLP -1.2% ETH -18.9% SOL -25.8%

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

1.886 1.519 1.152 0.784 0.417 2025-12-05 2026-01-10 2026-02-16 2026-03-24 2026-04-30 2026-06-06 HYPE +76.4% GOOGL +11.6% SPX +1.8% TSLA -13.2% BTC -23.3% JLP -24.3% ETH -37.8% SOL -43.1%

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

1.845 1.495 1.144 0.794 0.443 2025-12-05 2026-01-10 2026-02-16 2026-03-24 2026-04-30 2026-06-06 HYPE +72.9% GOOGL +9.6% GOLD -1.8% TSLA -14.7% BTC -24.6% JLP -25.6% ETH -38.8% SOL -44.0%

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.61%
GOLD: 5.39%
GOOGL: 0.00%
JLP: 0.00%
HYPE: 0.00%
TSLA: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 21.27%
GOOGL: 17.71%
JLP: 10.16%
TSLA: 0.86%
BTC: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 40.23%
SPX: 34.31%
HYPE: 25.47%
GOLD: 0.00%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -32.10%
ETH -48.43%
SOL -53.42%
HYPE 89.84%
GOLD 2.95%
SPX 7.47%
TSLA -14.07%
GOOGL 14.87%
JLP -31.03%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.915 0.903 0.377 0.105 0.480 0.307 0.196 0.938
ETH 0.915 1.000 0.905 0.435 0.115 0.492 0.276 0.206 0.933
SOL 0.903 0.905 1.000 0.422 0.035 0.432 0.264 0.159 0.985
HYPE 0.377 0.435 0.422 1.000 0.082 0.217 0.049 0.048 0.437
GOLD 0.105 0.115 0.035 0.082 1.000 0.284 0.187 0.182 0.083
SPX 0.480 0.492 0.432 0.217 0.284 1.000 0.586 0.579 0.452
TSLA 0.307 0.276 0.264 0.049 0.187 0.586 1.000 0.337 0.295
GOOGL 0.196 0.206 0.159 0.048 0.182 0.579 0.337 1.000 0.166
JLP 0.938 0.933 0.985 0.437 0.083 0.452 0.295 0.166 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -16.69% 33.45% -0.499 -19.12% -2.62% -4.11% -11.27%
MinVar 16.22% 13.18% 1.231 -9.32% -1.22% -1.63% 7.36%
MinVar-C50 9.12% 16.01% 0.569 -12.75% -1.26% -1.91% 3.81%
MaxSharpe 86.42% 30.24% 2.857 -10.16% -1.94% -3.00% 33.60%

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 -48.05% 48.32% -0.994 -37.38% -3.80% -5.77% -32.10%
ETH -67.02% 64.90% -1.033 -53.51% -5.00% -7.98% -48.43%
SOL -73.15% 64.39% -1.136 -57.68% -5.72% -7.81% -53.42%
HYPE 465.77% 97.03% 4.800 -32.26% -6.91% -9.10% 89.84%
GOLD 11.83% 32.59% 0.363 -18.45% -2.74% -4.43% 2.95%
SPX 16.47% 13.28% 1.240 -9.10% -1.24% -1.66% 7.47%
TSLA -20.23% 39.14% -0.517 -29.93% -3.55% -4.52% -14.07%
GOOGL 37.67% 29.74% 1.267 -20.37% -2.39% -2.97% 14.87%
JLP -48.57% 38.96% -1.247 -35.59% -3.20% -4.67% -31.03%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 94.6%, GOLD 5.4%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 40.2%, SPX 34.3%, HYPE 25.5%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 40.2%, SPX 34.3%, HYPE 25.5%
  • Lowest-drawdown tested portfolio: MinVar — SPX 94.6%, GOLD 5.4%
  • Highest-return single asset: HYPE — 89.84%
  • Single-asset dominance ratio: 2.674x

12 Months

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

Claude Narrative Report

**A Rough Year for Crypto, a Strong Year for Tech**

Over the past twelve months, the crypto market told a painful story for holders. Bitcoin, Ethereum, and Solana all posted deep losses, with Solana falling nearly sixty percent and Bitcoin shedding more than forty percent of its value. Meanwhile, traditional assets and select tech stocks thrived — Alphabet more than doubled, gold climbed steadily, and the S&P 500 delivered solid gains. The standout in crypto was HYPE, which surged impressively but came with stomach-churning volatility and a drawdown exceeding sixty percent. This divergence highlights how brutally sentiment can shift against digital assets even while broader markets rally.

**Diversification Proved Its Worth**

The portfolio analysis reveals a clear lesson: mixing assets dramatically improved outcomes. An equal-weight approach barely broke even and suffered nearly thirty percent peak-to-trough losses. In contrast, the minimum-variance portfolio — heavily anchored in the S&P 500 with a modest gold allocation — delivered returns more than three times higher while cutting volatility by two-thirds and limiting drawdowns to single digits. The maximum-Sharpe portfolio, which leaned into Alphabet while maintaining traditional asset exposure and a small HYPE position, captured the best risk-adjusted performance by a wide margin. Notably, none of the optimized portfolios held meaningful positions in Bitcoin, Ethereum, or Solana.

**Crypto Concentration Was the Costliest Mistake**

Going all-in on any major cryptocurrency resulted in negative risk-adjusted returns and catastrophic drawdowns approaching seventy-five percent in Solana's case. Even HYPE's impressive gains came with volatility so extreme that its Sharpe ratio lagged far behind a simple S&P 500 holding. The data suggests that during this period, crypto served portfolios best as a small satellite position rather than a core holding.

**Takeaway:** If you're a crypto investor, this analysis argues strongly for capping your digital asset exposure and anchoring your portfolio in diversified traditional assets — the math shows that a five-to-fifteen percent crypto allocation within a balanced framework would have delivered far better sleep and surprisingly competitive returns.

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

3.243 2.572 1.901 1.230 0.559 2025-06-06 2025-08-18 2025-10-30 2026-01-11 2026-03-25 2026-06-06 GOOGL +201.9% HYPE +110.7% TSLA +92.2% GOLD +90.0% SPX +69.7% JLP +21.3% ETH +19.5% SOL -21.8%

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

1.709 1.351 0.993 0.635 0.276 2025-06-06 2025-08-18 2025-10-30 2026-01-11 2026-03-25 2026-06-06 GOOGL +59.0% HYPE +10.0% TSLA +1.1% SPX -10.8% JLP -36.0% ETH -36.9% BTC -47.2% SOL -58.7%

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

1.914 1.519 1.123 0.728 0.333 2025-06-06 2025-08-18 2025-10-30 2026-01-11 2026-03-25 2026-06-06 GOOGL +78.2% HYPE +22.6% TSLA +13.3% GOLD +12.3% JLP -28.1% ETH -29.0% BTC -40.7% SOL -53.6%

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: 89.48%
GOLD: 10.52%
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: 29.05%
GOOGL: 13.56%
JLP: 7.39%
BTC: 0.00%
TSLA: 0.00%
SOL: 0.00%
HYPE: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 50.00%
SPX: 28.62%
GOLD: 16.42%
HYPE: 4.96%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -41.86%
ETH -37.04%
SOL -58.02%
HYPE 76.73%
GOLD 30.53%
SPX 23.05%
TSLA 32.48%
GOOGL 112.92%
JLP -26.70%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.856 0.828 0.498 0.115 0.473 0.343 0.191 0.896
ETH 0.856 1.000 0.881 0.548 0.105 0.483 0.364 0.237 0.914
SOL 0.828 0.881 1.000 0.565 0.078 0.429 0.342 0.188 0.981
HYPE 0.498 0.548 0.565 1.000 0.098 0.256 0.211 0.096 0.565
GOLD 0.115 0.105 0.078 0.098 1.000 0.219 0.147 0.190 0.104
SPX 0.473 0.483 0.429 0.256 0.219 1.000 0.549 0.546 0.453
TSLA 0.343 0.364 0.342 0.211 0.147 0.549 1.000 0.345 0.354
GOOGL 0.191 0.237 0.188 0.096 0.190 0.546 0.345 1.000 0.192
JLP 0.896 0.914 0.981 0.565 0.104 0.453 0.354 0.192 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 14.09% 35.14% 0.401 -28.88% -2.82% -3.94% 7.27%
MinVar 25.12% 11.83% 2.124 -9.54% -0.99% -1.50% 24.25%
MinVar-C50 33.12% 14.32% 2.313 -12.43% -1.10% -1.79% 31.77%
MaxSharpe 75.18% 19.55% 3.846 -13.57% -1.46% -1.92% 71.90%

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 -36.23% 42.89% -0.845 -51.35% -3.66% -5.24% -41.86%
ETH -20.78% 67.86% -0.306 -67.72% -5.27% -7.80% -37.04%
SOL -45.47% 72.17% -0.630 -74.92% -5.66% -8.25% -58.02%
HYPE 176.06% 95.41% 1.845 -64.19% -6.96% -9.27% 76.73%
GOLD 35.38% 26.85% 1.318 -18.45% -2.20% -3.66% 30.53%
SPX 23.97% 12.16% 1.971 -9.10% -1.11% -1.58% 23.05%
TSLA 46.06% 44.28% 1.040 -29.93% -3.79% -5.14% 32.48%
GOOGL 122.08% 29.34% 4.161 -20.37% -2.07% -2.75% 112.92%
JLP -21.16% 38.20% -0.554 -46.07% -3.03% -4.39% -26.70%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 89.5%, GOLD 10.5%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 28.6%, GOLD 16.4%, HYPE 5.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 28.6%, GOLD 16.4%, HYPE 5.0%
  • Lowest-drawdown tested portfolio: MinVar — SPX 89.5%, GOLD 10.5%
  • Highest-return single asset: GOOGL — 112.92%
  • Single-asset dominance ratio: 1.571x

24 Months

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

Claude Narrative Report

## Portfolio Analysis: 24-Month Performance Review

The past two years delivered a stark reality check for crypto investors. While Tesla and Google more than doubled and gold posted exceptional gains approaching eighty percent, the major cryptocurrencies moved decisively in the opposite direction. Bitcoin lost roughly one-seventh of its value, but Ethereum and Solana fared far worse, each surrendering more than half their worth. This divergence between traditional risk assets and digital currencies defined the period, with the S&P 500's steady mid-thirties return looking almost conservative by comparison.

The portfolio optimization results tell a compelling story about the power of diversification during crypto winter. An equal-weight approach across all assets barely managed a twenty percent gain while subjecting investors to gut-wrenching drawdowns exceeding thirty percent. The minimum variance portfolio, heavily anchored in the S&P 500 and gold with minimal crypto exposure, delivered more than double that return with less than half the volatility and drawdowns under thirteen percent. The maximum Sharpe portfolio pushed returns even higher by concentrating in gold and Google, achieving nearly a triple of the equal-weight return while maintaining disciplined risk metrics.

The single-asset comparison reveals why pure crypto bets proved costly. Holding only Bitcoin meant enduring a fifty percent peak-to-trough collapse for a negative return, while Solana holders watched three-quarters of their value evaporate at the worst point. Meanwhile, gold delivered risk-adjusted performance rivaling the best tech stocks, with dramatically less turbulence. **The practical takeaway: even crypto-focused investors should maintain substantial allocations to uncorrelated assets like gold and broad equities—this period shows that a fifty-percent gold weighting combined with quality stocks can capture strong returns while providing crucial protection when digital assets falter.**

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

2.379 1.853 1.327 0.801 0.275 2024-06-06 2024-10-30 2025-03-25 2025-08-18 2026-01-11 2026-06-06 TSLA +113.9% GOLD +91.0% GOOGL +88.5% SPX +27.1% JLP +25.8% ETH -45.4% SOL -51.7%

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

1.759 1.347 0.935 0.523 0.111 2024-06-06 2024-10-30 2025-03-25 2025-08-18 2026-01-11 2026-06-06 TSLA +12.4% GOOGL -0.5% SPX -33.2% JLP -33.9% BTC -47.3% ETH -71.3% SOL -74.6%

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

2.065 1.606 1.147 0.688 0.229 2024-06-06 2024-10-30 2025-03-25 2025-08-18 2026-01-11 2026-06-06 TSLA +68.3% GOLD +50.5% GOOGL +48.3% JLP -0.7% BTC -21.0% ETH -56.8% SOL -61.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: 66.69%
GOLD: 31.32%
JLP: 2.00%
GOOGL: 0.00%
BTC: 0.00%
SOL: 0.00%
TSLA: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 39.63%
JLP: 6.59%
GOOGL: 3.78%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 50.00%
GOOGL: 31.76%
SPX: 13.26%
TSLA: 4.98%
JLP: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC -14.22%
ETH -59.08%
SOL -63.47%
GOLD 82.98%
SPX 37.94%
TSLA 119.74%
GOOGL 110.25%
JLP 9.05%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.826 0.790 0.081 0.397 0.345 0.266 0.844
ETH 0.826 1.000 0.794 0.054 0.427 0.363 0.296 0.848
SOL 0.790 0.794 1.000 0.045 0.349 0.308 0.231 0.952
GOLD 0.081 0.054 0.045 1.000 0.118 0.043 0.121 0.048
SPX 0.397 0.427 0.349 0.118 1.000 0.639 0.605 0.375
TSLA 0.345 0.363 0.308 0.043 0.639 1.000 0.468 0.322
GOOGL 0.266 0.296 0.231 0.121 0.605 0.468 1.000 0.249
JLP 0.844 0.848 0.952 0.048 0.375 0.322 0.249 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 17.08% 34.23% 0.499 -33.39% -2.65% -3.87% 22.00%
MinVar 24.79% 14.04% 1.765 -12.80% -1.03% -1.78% 52.69%
MinVar-C50 27.23% 14.45% 1.885 -12.06% -1.15% -1.82% 58.53%
MaxSharpe 41.75% 18.39% 2.271 -15.31% -1.45% -2.27% 94.28%

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 3.19% 46.58% 0.068 -51.35% -3.72% -5.29% -14.22%
ETH -18.06% 70.62% -0.256 -67.72% -5.57% -8.18% -59.08%
SOL -16.76% 80.17% -0.209 -76.29% -6.40% -8.78% -63.47%
GOLD 38.95% 23.07% 1.689 -18.45% -1.80% -3.10% 82.98%
SPX 19.02% 16.37% 1.162 -18.90% -1.35% -2.11% 37.94%
TSLA 77.89% 60.88% 1.279 -53.77% -4.66% -6.89% 119.74%
GOOGL 51.84% 30.50% 1.699 -29.81% -2.35% -3.54% 110.25%
JLP 12.20% 37.95% 0.322 -46.07% -2.96% -4.28% 9.05%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 66.7%, GOLD 31.3%, JLP 2.0%
  • Highest-return tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 31.8%, SPX 13.3%, TSLA 5.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 31.8%, SPX 13.3%, TSLA 5.0%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 39.6%, JLP 6.6%, GOOGL 3.8%
  • Highest-return single asset: TSLA — 119.74%
  • Single-asset dominance ratio: 1.270x

3 Years

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

Claude Narrative Report

## Portfolio Analysis: 3-Year Performance Review

Over the past three years, individual asset performance varied dramatically across the crypto and traditional spectrum. Solana delivered exceptional gains, more than tripling in value, while Google nearly matched it with similarly strong performance from the tech sector. Bitcoin and gold both roughly doubled investor capital, proving their staying power across different market conditions. On the weaker end, Ethereum actually lost value over this period—a stark reminder that not all major cryptocurrencies move together—while Tesla and the broader S&P 500 delivered more modest growth.

The real story, however, emerges when comparing single-asset holdings to diversified portfolios. Going all-in on Solana would have generated the highest raw return, but at a brutal cost: volatility exceeding eighty percent and a maximum drawdown that wiped out more than three-quarters of portfolio value at its worst point. By contrast, the optimized MaxSharpe portfolio—anchored heavily in gold and traditional equities with only modest crypto exposure—achieved comparable returns while cutting volatility by roughly eighty percent and limiting peak losses to under fifteen percent. The risk-adjusted efficiency, measured by Sharpe ratio, was nearly double what even the best single crypto asset could offer.

What stands out most is how the optimization process consistently favored traditional assets as the portfolio core, treating crypto as a small satellite allocation rather than the foundation. Gold and equities dominated every efficient portfolio, with Bitcoin and Solana earning only single-digit weightings even in the most aggressive configuration.

**Takeaway:** For crypto investors seeking sustainable growth, the data suggests treating digital assets as a five-to-ten percent portfolio enhancer rather than the main event—pairing them with gold and broad equities dramatically improves your risk-adjusted returns while still capturing meaningful crypto upside.

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)

3.521 2.663 1.805 0.947 0.090 2023-06-06 2024-01-11 2024-08-17 2025-03-24 2025-10-29 2026-06-06 SOL +60.7% JLP +23.8% (from 2023-12-20) GOOGL -1.4% GOLD -9.0% TSLA -32.4% SPX -39.1% ETH -57.1%

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)

7.210 5.374 3.537 1.701 -0.135 2023-06-06 2024-01-11 2024-08-17 2025-03-24 2025-10-29 2026-06-06 SOL +78.3% BTC +11.0% GOOGL +9.4% JLP -11.5% (from 2023-12-20) TSLA -25.4% SPX -32.8% ETH -52.3%

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)

7.016 5.297 3.578 1.859 0.140 2023-06-06 2024-01-11 2024-08-17 2025-03-24 2025-10-29 2026-06-06 SOL +166.8% BTC +65.4% GOOGL +62.1% GOLD +49.8% JLP +40.0% (from 2023-12-20) TSLA +11.3% ETH -28.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: 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: 63.01%
GOLD: 32.85%
JLP: 4.14%
GOOGL: 0.00%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 40.08%
JLP: 8.14%
GOOGL: 1.78%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 47.56%
SPX: 25.55%
GOOGL: 21.55%
SOL: 4.19%
BTC: 1.15%
JLP: 0.00%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 122.82%
ETH -17.23%
SOL 204.43%
GOLD 120.66%
SPX 72.36%
TSLA 76.68%
GOOGL 191.87%
JLP 72.62%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.810 0.732 0.065 0.327 0.270 0.183 0.721
ETH 0.810 1.000 0.714 0.063 0.371 0.286 0.234 0.766
SOL 0.732 0.714 1.000 0.029 0.295 0.221 0.195 0.774
GOLD 0.065 0.063 0.029 1.000 0.122 0.042 0.101 0.051
SPX 0.327 0.371 0.295 0.122 1.000 0.587 0.587 0.340
TSLA 0.270 0.286 0.221 0.042 0.587 1.000 0.385 0.270
GOOGL 0.183 0.234 0.195 0.101 0.587 0.385 1.000 0.198
JLP 0.721 0.766 0.774 0.051 0.340 0.270 0.198 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 40.42% 31.49% 1.283 -33.39% -2.49% -3.57% 138.96%
MinVar 25.14% 12.58% 1.997 -12.49% -0.93% -1.56% 91.48%
MinVar-C50 26.65% 12.82% 2.078 -12.07% -0.95% -1.60% 98.34%
MaxSharpe 35.69% 15.34% 2.327 -14.76% -1.21% -1.90% 141.41%

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 45.71% 46.97% 0.973 -51.35% -3.68% -5.32% 122.82%
ETH 16.18% 65.59% 0.247 -67.72% -5.19% -7.51% -17.23%
SOL 106.10% 84.56% 1.255 -76.29% -6.38% -8.75% 204.43%
GOLD 32.86% 20.18% 1.628 -18.45% -1.47% -2.67% 120.66%
SPX 21.21% 14.88% 1.425 -18.90% -1.22% -1.88% 72.36%
TSLA 42.48% 57.75% 0.736 -53.77% -4.43% -6.61% 76.68%
GOOGL 49.26% 29.70% 1.659 -29.81% -2.29% -3.51% 191.87%
JLP 26.44% 32.55% 0.812 -46.07% -2.61% -3.82% 72.62%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 63.0%, GOLD 32.9%, JLP 4.1%
  • Highest-return tested portfolio: MaxSharpe — GOLD 47.6%, SPX 25.5%, GOOGL 21.6%, SOL 4.2%, BTC 1.1%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 47.6%, SPX 25.5%, GOOGL 21.6%, SOL 4.2%, BTC 1.1%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 40.1%, JLP 8.1%, GOOGL 1.8%
  • Highest-return single asset: SOL — 204.43%
  • Single-asset dominance ratio: 1.446x

4 Years

Window: 2022-06-07 → 2026-06-06 (1461 rows)

Claude Narrative Report

**A Surprising Four Years for Crypto**

Over this four-year window, the narrative that crypto outperforms everything simply didn't hold. Google delivered more than double Bitcoin's return and vastly outpaced Ethereum, which actually lost money. Gold posted the second-best performance among individual assets, quietly compounding while the flashier tokens suffered brutal volatility. Bitcoin, often positioned as the flagship digital asset, landed in the middle of the pack — ahead of Tesla and the S&P 500, but far behind traditional safe havens and big tech.

**Diversification Proved Its Worth**

The optimized portfolios tell a compelling story about risk management. Putting everything into a single crypto asset meant enduring drawdowns exceeding fifty percent for Bitcoin and approaching eighty percent for Solana — gut-wrenching declines that test even committed holders. Meanwhile, the maximum Sharpe ratio portfolio achieved roughly sixty percent higher returns than Bitcoin alone while cutting volatility by nearly seventy percent and limiting drawdowns to around sixteen percent. This portfolio leaned heavily into gold, the S&P 500, and Google, with only trace allocations to crypto. The minimum variance approach, holding just stocks and gold, delivered the smoothest ride with the smallest peak-to-trough drop.

**What the Optimizer Is Telling You**

The best risk-adjusted portfolios allocated almost nothing to cryptocurrency, and when they did, it was a small position in Solana or Bitcoin rather than Ethereum. This doesn't mean crypto has no place in a portfolio, but it suggests that over this period, traditional assets offered better compensation for the risks taken. **Practical takeaway:** If you're holding concentrated crypto positions expecting outsized returns, consider that a diversified mix anchored in equities and gold historically delivered superior risk-adjusted performance — sometimes with higher absolute returns and far less pain along the way.

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

2.014 1.584 1.155 0.726 0.296 2022-06-07 2023-03-26 2024-01-12 2024-10-30 2025-08-18 2026-06-06 GOOGL +15.6% GOLD +3.8% SOL +0.1% TSLA -29.7% SPX -31.9% ETH -47.1%

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

3.478 2.667 1.856 1.046 0.235 2022-06-07 2023-03-26 2024-01-12 2024-10-30 2025-08-18 2026-06-06 GOOGL +12.4% SOL -0.1% BTC -1.3% TSLA -31.3% SPX -33.9% ETH -47.3%

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

3.496 2.684 1.872 1.060 0.248 2022-06-07 2023-03-26 2024-01-12 2024-10-30 2025-08-18 2026-06-06 GOOGL +69.5% GOLD +52.1% SOL +50.8% BTC +49.0% TSLA +3.9% ETH -20.5%

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: 58.07%
GOLD: 41.93%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 49.99%
BTC: 0.01%
GOOGL: 0.00%
ETH: 0.00%
TSLA: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 50.00%
SPX: 24.75%
GOOGL: 22.17%
SOL: 2.50%
BTC: 0.58%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 94.81%
ETH -14.02%
SOL 57.46%
GOLD 134.76%
SPX 77.46%
TSLA 63.68%
GOOGL 217.18%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL
BTC 1.000 0.831 0.737 0.104 0.378 0.285 0.257
ETH 0.831 1.000 0.729 0.086 0.398 0.293 0.281
SOL 0.737 0.729 1.000 0.057 0.329 0.241 0.247
GOLD 0.104 0.086 0.057 1.000 0.143 0.036 0.114
SPX 0.378 0.398 0.329 0.143 1.000 0.575 0.653
TSLA 0.285 0.293 0.241 0.036 0.575 1.000 0.398
GOOGL 0.257 0.281 0.247 0.114 0.653 0.398 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 33.99% 34.79% 0.977 -39.86% -2.69% -4.03% 153.20%
MinVar 20.72% 13.34% 1.553 -13.13% -1.04% -1.68% 104.96%
MinVar-C50 21.45% 13.47% 1.592 -12.52% -1.06% -1.71% 109.80%
MaxSharpe 27.76% 15.71% 1.767 -16.11% -1.31% -1.95% 153.64%

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 33.61% 49.62% 0.677 -51.35% -3.74% -5.84% 94.81%
ETH 21.72% 68.62% 0.316 -67.72% -5.34% -8.17% -14.02%
SOL 71.74% 92.30% 0.777 -79.24% -6.91% -9.92% 57.46%
GOLD 26.06% 19.03% 1.369 -18.45% -1.46% -2.46% 134.76%
SPX 17.01% 16.55% 1.027 -18.90% -1.37% -2.08% 77.46%
TSLA 34.13% 58.65% 0.582 -65.05% -4.80% -7.04% 63.68%
GOOGL 40.34% 31.80% 1.269 -31.66% -2.43% -3.78% 217.18%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 58.1%, GOLD 41.9%
  • Highest-return tested portfolio: MaxSharpe — GOLD 50.0%, SPX 24.7%, GOOGL 22.2%, SOL 2.5%, BTC 0.6%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 50.0%, SPX 24.7%, GOOGL 22.2%, SOL 2.5%, BTC 0.6%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 50.0%
  • Highest-return single asset: GOOGL — 217.18%
  • Single-asset dominance ratio: 1.414x