Portfolio Analysis Report — 24-04-2026 21:15

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-04-25 → 2026-04-24

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 77,713.00 63.5 16.11% 14.27% 9.21% Bullish
ETH 2,314.96 54.3 12.74% 17.57% 6.87% Bullish
SOL 85.45 51.2 6.32% 0.96% -0.34% Mixed
HYPE 41.11 48.4 15.45% 35.38% 5.94% Bullish
GOLD 4,705.10 43.5 1.15% -7.00% -1.43% Mixed
SPX 7,108.40 80.7 7.99% 2.88% 5.62% Overbought
TSLA 373.72 64.3 3.64% -9.25% -0.83% Mixed
GOOGL 338.89 74.9 14.58% 7.67% 9.87% Overbought
JLP 3.89 54.0 6.77% 5.96% 2.45% Bullish

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 MaxSharpe BTC MinVar MinVar MaxSharpe
1 Month 31 MaxSharpe GOOGL MinVar MinVar MaxSharpe
3 Months 92 MaxSharpe HYPE MinVar MinVar MaxSharpe
6 Months 184 MaxSharpe GOOGL MinVar MinVar MaxSharpe
12 Months 366 MaxSharpe HYPE MinVar MinVar MaxSharpe
24 Months 731 MaxSharpe TSLA MinVar MinVar-C50 MaxSharpe
3 Years 1097 Equal 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% 0.00% 0.00% 91.30% 0.00% 0.00% 8.70%
1 Month 0.00% 0.00% 0.00% 0.00% 11.44% 73.77% 0.00% 0.00% 14.79%
3 Months 0.00% 0.00% 0.00% 0.00% 4.70% 95.30% 0.00% 0.00% 0.00%
6 Months 0.00% 0.00% 0.00% 0.00% 8.69% 91.31% 0.00% 0.00% 0.00%
12 Months 0.00% 0.00% 0.00% 0.00% 15.51% 84.49% 0.00% 0.00% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 31.90% 65.77% 0.00% 0.00% 2.33%
3 Years 0.00% 0.00% 0.00% nan% 34.79% 65.21% 0.00% 0.00% nan%
4 Years 0.00% 0.00% 0.00% nan% 45.01% 54.99% 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% 0.00% 24.54% 50.00% 3.53% 0.00% 21.94%
1 Month 0.00% 0.00% 0.00% 0.00% 27.51% 50.00% 0.00% 0.00% 22.49%
3 Months 0.00% 0.00% 0.00% 0.00% 15.46% 50.00% 3.36% 24.08% 7.10%
6 Months 0.00% 0.00% 0.00% 0.00% 23.39% 50.00% 0.00% 17.91% 8.71%
12 Months 0.00% 0.00% 0.00% 0.00% 29.16% 50.00% 0.00% 14.06% 6.78%
24 Months 0.00% 0.00% 0.00% nan% 39.75% 50.00% 0.00% 3.53% 6.72%
3 Years 1.98% 0.00% 0.00% nan% 43.77% 50.00% 0.00% 4.25% nan%
4 Years 0.00% 0.00% 0.00% nan% 50.00% 50.00% 0.00% 0.00% nan%

MaxSharpe Weight History

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
1 Week 50.00% 0.00% 0.00% 0.00% 0.00% 50.00% 0.00% 0.00% 0.00%
1 Month 9.46% 0.00% 0.00% 0.00% 0.00% 40.54% 0.00% 50.00% 0.00%
3 Months 0.00% 0.00% 0.00% 50.00% 0.00% 49.02% 0.00% 0.98% 0.00%
6 Months 0.00% 0.00% 0.00% 3.61% 27.87% 18.52% 0.00% 50.00% 0.00%
12 Months 0.00% 0.00% 0.00% 4.28% 21.53% 31.76% 0.00% 42.43% 0.00%
24 Months 0.00% 0.00% 0.00% nan% 50.00% 11.29% 3.99% 27.64% 7.09%
3 Years 4.60% 0.00% 3.56% nan% 50.00% 15.77% 0.00% 26.08% nan%
4 Years 4.61% 0.00% 0.00% nan% 50.00% 24.64% 0.00% 20.75% nan%

Stable Allocation Band

Min Avg Max Times > 20% Times < 1%
BTC 0.00% 0.25% 1.98% 0 7
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 15.46% 31.70% 50.00% 7 0
SPX 50.00% 50.00% 50.00% 8 0
TSLA 0.00% 0.86% 3.53% 0 6
GOOGL 0.00% 7.98% 24.08% 1 3
JLP 6.72% 12.29% 22.49% 2 0

1 Day

Window: 2026-04-23 → 2026-04-24 (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.71%
ETH -0.71%
SOL -0.80%
HYPE -0.46%
GOLD 0.00%
SPX 0.00%
TSLA 0.00%
GOOGL 0.00%
JLP -0.62%

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 -92.59% nan% nan 0.00% -0.71% -0.71% -0.71%
ETH -92.58% nan% nan 0.00% -0.71% -0.71% -0.71%
SOL -94.71% nan% nan 0.00% -0.80% -0.80% -0.80%
HYPE -81.08% nan% nan 0.00% -0.46% -0.46% -0.46%
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 -89.74% nan% nan 0.00% -0.62% -0.62% -0.62%

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

1.024 1.013 1.002 0.991 0.980 2026-04-23 2026-04-24 GOLD +0.4% SPX +0.4% TSLA +0.4% GOOGL +0.4% HYPE +0.1% JLP +0.0% ETH +0.0% SOL -0.0%

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

1.020 1.009 0.998 0.987 0.976 2026-04-23 2026-04-24 SPX +0.0% TSLA +0.0% GOOGL +0.0% HYPE -0.2% JLP -0.3% ETH -0.4% BTC -0.4% SOL -0.4%

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

1.020 1.009 0.998 0.987 0.976 2026-04-23 2026-04-24 GOLD +0.0% TSLA +0.0% GOOGL +0.0% HYPE -0.2% JLP -0.3% ETH -0.4% BTC -0.4% SOL -0.4%

1 Week

Window: 2026-04-17 → 2026-04-24 (8 rows)

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

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.30%
JLP: 8.70%
SOL: 0.00%
GOLD: 0.00%
TSLA: 0.00%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
HYPE: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 24.54%
JLP: 21.94%
TSLA: 3.53%
SOL: 0.00%
GOOGL: 0.00%
BTC: 0.00%
ETH: 0.00%
HYPE: 0.00%
MaxSharpe ▲
BTC: 50.00%
SPX: 50.00%
GOOGL: 0.00%
JLP: 0.00%
GOLD: 0.00%
SOL: 0.00%
ETH: 0.00%
TSLA: 0.00%
HYPE: 0.00%

Asset Total Returns

Total Return
BTC 0.76%
ETH -4.38%
SOL -3.85%
HYPE -7.87%
GOLD -3.14%
SPX -0.25%
TSLA -6.71%
GOOGL -0.82%
JLP -2.14%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.960 0.959 0.778 -0.190 0.233 -0.307 0.061 0.977
ETH 0.960 1.000 0.968 0.730 -0.216 0.255 -0.114 0.032 0.973
SOL 0.959 0.968 1.000 0.660 -0.388 0.047 -0.334 -0.141 0.994
HYPE 0.778 0.730 0.660 1.000 0.187 0.434 -0.165 0.404 0.704
GOLD -0.190 -0.216 -0.388 0.187 1.000 0.828 0.571 0.879 -0.323
SPX 0.233 0.255 0.047 0.434 0.828 1.000 0.646 0.929 0.124
TSLA -0.307 -0.114 -0.334 -0.165 0.571 0.646 1.000 0.507 -0.320
GOOGL 0.061 0.032 -0.141 0.404 0.879 0.929 0.507 1.000 -0.051
JLP 0.977 0.973 0.994 0.704 -0.323 0.124 -0.320 -0.051 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -80.49% 22.84% -3.524 -2.22% -1.84% -2.08% -3.13%
MinVar -18.86% 9.92% -1.902 -0.80% -0.50% -0.53% -0.41%
MinVar-C50 -56.49% 10.97% -5.150 -1.38% -0.73% -0.80% -1.59%
MaxSharpe 18.01% 20.71% 0.870 -1.23% -1.14% -1.23% 0.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 57.76% 37.83% 1.527 -2.47% -2.27% -2.47% 0.76%
ETH -89.47% 44.58% -2.007 -3.67% -3.43% -3.67% -4.38%
SOL -86.27% 38.04% -2.268 -3.04% -3.03% -3.04% -3.85%
HYPE -98.33% 63.93% -1.538 -9.17% -5.86% -7.39% -7.87%
GOLD -80.76% 18.47% -4.372 -3.28% -1.89% -2.25% -3.14%
SPX -11.74% 10.22% -1.149 -0.87% -0.57% -0.63% -0.25%
TSLA -97.24% 27.62% -3.520 -6.71% -3.10% -3.56% -6.71%
GOOGL -33.37% 22.43% -1.488 -2.75% -1.44% -1.52% -0.82%
JLP -66.46% 27.64% -2.405 -2.12% -2.11% -2.12% -2.14%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 91.3%, JLP 8.7%
  • Highest-return tested portfolio: MaxSharpe — BTC 50.0%, SPX 50.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — BTC 50.0%, SPX 50.0%
  • Lowest-drawdown tested portfolio: MinVar — SPX 91.3%, JLP 8.7%
  • Highest-return single asset: BTC — 0.76%
  • Single-asset dominance ratio: 2.687x

Claude Narrative Report

Over the past week, markets broadly retreated with Bitcoin standing as the lone bright spot among the assets tracked. While most holdings posted losses—ranging from modest declines in traditional equities to sharper drops in altcoins and even gold—Bitcoin managed to eke out a small gain. The divergence was particularly stark in the crypto space, where Ethereum, Solana, and Hype all suffered meaningful drawdowns, with Hype losing nearly eight percent and exhibiting extreme volatility throughout the period.

From a portfolio construction standpoint, the minimum variance approach proved most effective at capital preservation, limiting losses to a fraction of a percent by leaning heavily into the stability of the S&P 500 with only a small allocation to yield-generating crypto exposure. In contrast, the equal-weight strategy suffered the worst risk-adjusted performance by spreading exposure evenly across volatile losers. The maximum Sharpe portfolio—split evenly between Bitcoin and the S&P 500—was the only strategy to post a positive return, demonstrating that a balanced pairing of the strongest crypto performer with defensive equity exposure can outperform even in a down week.

The single-asset analysis reveals an important pattern: Bitcoin's modest gain came with substantial volatility, yet it still delivered the best risk-adjusted return among individual holdings by a wide margin. Meanwhile, assets like Tesla and Hype showed that chasing momentum in high-beta names can backfire quickly during risk-off periods.

**Takeaway:** When crypto markets turn choppy, pairing Bitcoin with a stable equity anchor like the S&P 500 offers a practical middle ground—capturing upside from crypto's resilience while dampening the portfolio damage from altcoin weakness.

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

1.051 1.010 0.969 0.927 0.886 2026-04-17 2026-04-18 2026-04-19 2026-04-21 2026-04-22 2026-04-24 SPX -1.4% GOOGL -1.9% JLP -2.9% GOLD -4.2% SOL -4.5% ETH -5.1% TSLA -7.7% HYPE -8.7%

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

1.064 1.022 0.980 0.938 0.896 2026-04-17 2026-04-18 2026-04-19 2026-04-21 2026-04-22 2026-04-24 BTC +4.4% SPX +3.0% GOOGL +2.4% JLP +1.4% SOL -0.3% ETH -0.9% TSLA -3.7% HYPE -4.7%

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

1.035 0.998 0.961 0.924 0.887 2026-04-17 2026-04-18 2026-04-19 2026-04-21 2026-04-22 2026-04-24 BTC +1.4% GOOGL -0.6% JLP -1.6% GOLD -2.9% SOL -3.2% ETH -3.8% TSLA -6.5% HYPE -7.4%

1 Month

Window: 2026-03-25 → 2026-04-24 (31 rows)

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: 73.77%
JLP: 14.79%
GOLD: 11.44%
SOL: 0.00%
BTC: 0.00%
HYPE: 0.00%
GOOGL: 0.00%
ETH: 0.00%
TSLA: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 27.51%
JLP: 22.49%
SOL: 0.00%
BTC: 0.00%
HYPE: 0.00%
GOOGL: 0.00%
TSLA: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 50.00%
SPX: 40.54%
BTC: 9.46%
GOLD: 0.00%
JLP: 0.00%
HYPE: 0.00%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%

Asset Total Returns

Total Return
BTC 8.98%
ETH 6.78%
SOL -6.82%
HYPE 2.08%
GOLD 3.41%
SPX 7.84%
TSLA -3.17%
GOOGL 16.49%
JLP -0.32%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.946 0.868 0.743 0.104 0.402 0.304 0.371 0.931
ETH 0.946 1.000 0.839 0.743 0.208 0.371 0.382 0.385 0.912
SOL 0.868 0.839 1.000 0.672 -0.040 0.171 0.179 0.122 0.985
HYPE 0.743 0.743 0.672 1.000 0.046 0.228 0.221 0.204 0.728
GOLD 0.104 0.208 -0.040 0.046 1.000 0.537 0.475 0.676 0.019
SPX 0.402 0.371 0.171 0.228 0.537 1.000 0.585 0.921 0.233
TSLA 0.304 0.382 0.179 0.221 0.475 0.585 1.000 0.593 0.238
GOOGL 0.371 0.385 0.122 0.204 0.676 0.921 0.593 1.000 0.196
JLP 0.931 0.912 0.985 0.728 0.019 0.233 0.238 0.196 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 71.62% 31.72% 2.258 -3.48% -2.21% -3.01% 4.12%
MinVar 110.25% 17.23% 6.397 -1.50% -1.00% -1.76% 6.17%
MinVar-C50 81.26% 17.82% 4.560 -1.81% -0.98% -1.91% 4.88%
MaxSharpe 323.05% 26.06% 12.396 -2.44% -1.63% -2.47% 12.29%

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 208.52% 40.96% 5.091 -4.24% -3.36% -3.55% 8.98%
ETH 160.63% 57.92% 2.773 -6.45% -3.97% -4.54% 6.78%
SOL -50.60% 56.72% -0.892 -8.67% -3.99% -4.88% -6.82%
HYPE 54.64% 62.15% 0.879 -10.87% -3.79% -5.78% 2.08%
GOLD 56.34% 28.21% 1.997 -3.28% -2.53% -3.29% 3.41%
SPX 154.37% 18.16% 8.498 -2.06% -1.21% -1.71% 7.84%
TSLA -24.21% 48.93% -0.495 -9.97% -3.57% -4.50% -3.17%
GOOGL 577.95% 34.73% 16.640 -2.75% -1.97% -2.89% 16.49%
JLP 2.16% 35.33% 0.061 -4.15% -2.52% -3.01% -0.32%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 73.8%, JLP 14.8%, GOLD 11.4%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 40.5%, BTC 9.5%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 50.0%, SPX 40.5%, BTC 9.5%
  • Lowest-drawdown tested portfolio: MinVar — SPX 73.8%, JLP 14.8%, GOLD 11.4%
  • Highest-return single asset: GOOGL — 16.49%
  • Single-asset dominance ratio: 1.342x

Claude Narrative Report

Over the past month, traditional assets significantly outpaced most cryptocurrencies. Alphabet led the pack with exceptional gains, followed by Bitcoin which held its ground as the strongest crypto performer. The S&P 500 also delivered solid returns, while Ethereum posted modest gains. On the losing side, Solana suffered meaningful losses, Tesla continued its slide, and JLP barely moved. This divergence highlights a period where established tech and broad equities rewarded investors far more than altcoin exposure.

The portfolio analysis reveals a compelling case for diversification over single-asset concentration. The maximum Sharpe portfolio, built primarily around Alphabet and the S&P 500 with a modest Bitcoin allocation, delivered returns that outpaced even holding Bitcoin alone — and did so with substantially lower volatility and a shallower drawdown. Meanwhile, the minimum variance approach cut risk dramatically by leaning heavily into equities and gold, sacrificing some upside but avoiding the stomach-churning swings typical of pure crypto holdings. Notably, going all-in on Bitcoin meant enduring roughly double the volatility of the optimized portfolios while actually earning less than the best-constructed mix.

The single-asset comparison underscores just how punishing crypto volatility can be without commensurate reward this month. Ethereum and Solana both carried volatility levels above fifty percent annualized, yet Solana delivered negative returns and Ethereum barely outpaced gold. Even Bitcoin, despite respectable gains, offered a risk-adjusted profile inferior to simply holding the S&P 500.

**Takeaway:** If you're a crypto investor, this month's data argues strongly for trimming altcoin concentration and blending your holdings with traditional assets like broad equities — you can capture Bitcoin's upside while dramatically smoothing your ride and protecting against drawdowns.

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

1.126 1.054 0.983 0.911 0.839 2026-03-25 2026-03-31 2026-04-06 2026-04-12 2026-04-18 2026-04-24 GOOGL +6.5% ETH -1.0% SPX -1.0% GOLD -4.9% HYPE -6.8% JLP -8.1% TSLA -9.5% SOL -13.7%

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

1.146 1.068 0.990 0.912 0.834 2026-03-25 2026-03-31 2026-04-06 2026-04-12 2026-04-18 2026-04-24 GOOGL +12.0% BTC +5.2% ETH +4.1% SPX +4.1% HYPE -2.0% JLP -3.3% TSLA -4.8% SOL -9.3%

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

1.106 1.040 0.975 0.909 0.843 2026-03-25 2026-03-31 2026-04-06 2026-04-12 2026-04-18 2026-04-24 GOOGL +7.6% BTC +1.0% ETH +0.0% GOLD -3.9% HYPE -5.9% JLP -7.1% TSLA -8.6% SOL -12.9%

3 Months

Window: 2026-01-23 → 2026-04-24 (92 rows)

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.30%
GOLD: 4.70%
HYPE: 0.00%
GOOGL: 0.00%
JLP: 0.00%
TSLA: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOOGL: 24.08%
GOLD: 15.46%
JLP: 7.10%
TSLA: 3.36%
HYPE: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
HYPE: 50.00%
SPX: 49.02%
GOOGL: 0.98%
GOLD: 0.00%
TSLA: 0.00%
BTC: 0.00%
JLP: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -13.17%
ETH -21.61%
SOL -32.91%
HYPE 82.08%
GOLD -5.45%
SPX 2.79%
TSLA -16.78%
GOOGL 3.41%
JLP -15.48%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.937 0.923 0.360 0.074 0.518 0.394 0.173 0.950
ETH 0.937 1.000 0.927 0.413 0.122 0.500 0.371 0.191 0.949
SOL 0.923 0.927 1.000 0.371 -0.027 0.420 0.313 0.138 0.984
HYPE 0.360 0.413 0.371 1.000 0.143 0.152 0.090 0.122 0.400
GOLD 0.074 0.122 -0.027 0.143 1.000 0.251 0.119 0.212 0.039
SPX 0.518 0.500 0.420 0.152 0.251 1.000 0.611 0.678 0.444
TSLA 0.394 0.371 0.313 0.090 0.119 0.611 1.000 0.352 0.361
GOOGL 0.173 0.191 0.138 0.122 0.212 0.678 0.352 1.000 0.137
JLP 0.950 0.949 0.984 0.400 0.039 0.444 0.361 0.137 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -5.69% 38.92% -0.146 -19.12% -3.01% -4.33% -3.28%
MinVar 11.53% 14.94% 0.772 -9.29% -1.43% -1.58% 2.48%
MinVar-C50 1.89% 17.91% 0.106 -12.99% -1.46% -1.86% 0.07%
MaxSharpe 349.33% 51.91% 6.729 -13.73% -3.63% -4.47% 40.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 -31.93% 60.39% -0.529 -29.69% -3.85% -6.85% -13.17%
ETH -48.86% 78.44% -0.623 -39.72% -5.49% -8.76% -21.61%
SOL -72.65% 77.99% -0.932 -38.80% -6.04% -8.88% -32.91%
HYPE 1677.00% 100.43% 16.699 -25.69% -6.89% -8.39% 82.08%
GOLD -13.19% 40.51% -0.326 -17.73% -3.22% -5.66% -5.45%
SPX 12.91% 15.05% 0.858 -9.10% -1.44% -1.60% 2.79%
TSLA -48.40% 38.99% -1.241 -23.56% -3.35% -3.96% -16.78%
GOOGL 19.00% 28.27% 0.672 -20.37% -2.17% -2.91% 3.41%
JLP -42.95% 47.74% -0.900 -24.87% -3.42% -5.29% -15.48%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 95.3%, GOLD 4.7%
  • Highest-return tested portfolio: MaxSharpe — HYPE 50.0%, SPX 49.0%, GOOGL 1.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — HYPE 50.0%, SPX 49.0%, GOOGL 1.0%
  • Lowest-drawdown tested portfolio: MinVar — SPX 95.3%, GOLD 4.7%
  • Highest-return single asset: HYPE — 82.08%
  • Single-asset dominance ratio: 2.011x

Claude Narrative Report

**A Brutal Quarter for Crypto, With One Standout Exception**

The past three months delivered a punishing environment for most crypto assets. Bitcoin, Ethereum, and Solana all posted double-digit losses, with Solana suffering the steepest decline of roughly a third of its value. The volatility on these positions was severe — Ethereum swung nearly eighty percent annualized — yet delivered nothing but pain for holders. Meanwhile, traditional assets held up far better: the S&P 500 eked out modest gains, and even Google stock outperformed the entire crypto basket except for one dramatic outlier. That outlier was HYPE, which surged spectacularly and single-handedly reshaped the risk-return picture.

**Diversification Worked, But the Right Mix Mattered Enormously**

Simply spreading money equally across all assets produced a small loss with uncomfortably high volatility — a poor tradeoff. The minimum variance approach, which leaned almost entirely into the S&P 500 with a small gold allocation, delivered positive returns with far less turbulence and a much shallower drawdown. However, the maximum Sharpe portfolio — splitting roughly half into HYPE and half into equities — generated extraordinary risk-adjusted performance. Its return dwarfed every other strategy tested, and despite higher volatility, the drawdown remained more contained than holding any single crypto asset outright.

**Practical Takeaway**

When a single asset dominates this dramatically, concentration risk cuts both ways — HYPE's explosive gains could just as easily reverse. For crypto investors, the lesson is clear: pair your highest-conviction speculative bets with stable, low-correlation anchors like broad equity indexes. The data shows that a half-HYPE, half-stocks blend captured most of the upside while limiting damage far better than going all-in on any token alone.

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

2.373 1.943 1.513 1.083 0.653 2026-01-23 2026-02-10 2026-02-28 2026-03-18 2026-04-05 2026-04-24 HYPE +121.7% GOOGL +21.0% SPX +20.4% GOLD +13.2% TSLA +0.9% JLP -0.4% ETH -6.6% SOL -20.4%

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

2.089 1.694 1.300 0.906 0.511 2026-01-23 2026-02-10 2026-02-28 2026-03-18 2026-04-05 2026-04-24 HYPE +95.7% GOOGL +6.9% SPX +6.4% TSLA -10.9% BTC -11.6% JLP -12.0% ETH -17.4% SOL -29.6%

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

1.965 1.609 1.253 0.897 0.542 2026-01-23 2026-02-10 2026-02-28 2026-03-18 2026-04-05 2026-04-24 HYPE +84.0% GOOGL +0.5% GOLD -6.0% TSLA -16.3% BTC -17.0% JLP -17.3% ETH -22.4% SOL -33.9%

6 Months

Window: 2025-10-23 → 2026-04-24 (184 rows)

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.31%
GOLD: 8.69%
JLP: 0.00%
GOOGL: 0.00%
HYPE: 0.00%
TSLA: 0.00%
BTC: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 23.39%
GOOGL: 17.91%
JLP: 8.71%
TSLA: 0.00%
BTC: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 50.00%
GOLD: 27.87%
SPX: 18.52%
HYPE: 3.61%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -29.40%
ETH -39.97%
SOL -55.35%
HYPE 2.26%
GOLD 14.05%
SPX 5.49%
TSLA -16.76%
GOOGL 34.09%
JLP -28.73%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.919 0.891 0.438 0.077 0.486 0.319 0.166 0.933
ETH 0.919 1.000 0.909 0.475 0.086 0.481 0.301 0.218 0.939
SOL 0.891 0.909 1.000 0.472 -0.003 0.396 0.259 0.154 0.985
HYPE 0.438 0.475 0.472 1.000 0.071 0.196 0.074 0.071 0.486
GOLD 0.077 0.086 -0.003 0.071 1.000 0.211 0.106 0.133 0.041
SPX 0.486 0.481 0.396 0.196 0.211 1.000 0.597 0.631 0.425
TSLA 0.319 0.301 0.259 0.074 0.106 0.597 1.000 0.442 0.292
GOOGL 0.166 0.218 0.154 0.071 0.133 0.631 0.442 1.000 0.159
JLP 0.933 0.939 0.985 0.486 0.041 0.425 0.292 0.159 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal -19.98% 35.44% -0.564 -26.55% -2.91% -3.95% -13.34%
MinVar 14.21% 13.16% 1.080 -9.46% -1.29% -1.52% 6.43%
MinVar-C50 21.18% 15.65% 1.354 -12.66% -1.29% -1.84% 9.44%
MaxSharpe 55.25% 20.19% 2.737 -14.37% -1.53% -2.06% 23.42%

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 -43.24% 50.52% -0.856 -45.23% -3.88% -5.86% -29.40%
ETH -53.85% 69.87% -0.771 -56.19% -5.70% -8.09% -39.97%
SOL -74.18% 71.10% -1.043 -61.13% -5.74% -8.18% -55.35%
HYPE 64.58% 96.71% 0.668 -56.33% -7.37% -9.16% 2.26%
GOLD 36.97% 32.13% 1.151 -17.73% -2.72% -4.41% 14.05%
SPX 12.25% 13.45% 0.911 -9.10% -1.32% -1.60% 5.49%
TSLA -24.50% 41.32% -0.593 -29.93% -3.58% -4.58% -16.76%
GOOGL 86.91% 28.66% 3.033 -20.37% -2.28% -2.77% 34.09%
JLP -44.57% 41.36% -1.077 -38.29% -3.38% -4.61% -28.73%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 91.3%, GOLD 8.7%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 50.0%, GOLD 27.9%, SPX 18.5%, HYPE 3.6%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 50.0%, GOLD 27.9%, SPX 18.5%, HYPE 3.6%
  • Lowest-drawdown tested portfolio: MinVar — SPX 91.3%, GOLD 8.7%
  • Highest-return single asset: GOOGL — 34.09%
  • Single-asset dominance ratio: 1.456x

Claude Narrative Report

## Portfolio Analysis: A Brutal Six Months for Crypto

The past six months delivered a stark reminder of crypto's volatility. Major digital assets suffered devastating losses, with Solana losing more than half its value and Ethereum shedding nearly forty percent. Bitcoin fared only marginally better, still dropping close to thirty percent. Meanwhile, traditional assets told a completely different story—Alphabet surged with exceptional gains, gold provided steady appreciation, and the S&P 500 delivered modest but positive returns. The divergence between crypto and traditional finance was unusually pronounced during this period.

Portfolio construction proved its worth decisively. An equal-weight approach across all assets lost more than thirteen percent while enduring substantial volatility—essentially the worst of both worlds. However, the optimized portfolios demonstrated why diversification matters. The minimum variance strategy, allocating overwhelmingly to equities with a small gold position, delivered positive returns with dramatically lower drawdowns. The maximum Sharpe portfolio performed even better, generating returns north of twenty percent while keeping volatility manageable, primarily by concentrating in Alphabet, gold, and broad equities with only minimal crypto exposure through HYPE.

The single-asset comparisons reveal a sobering truth: every crypto-native holding would have destroyed portfolio value over this window. Even HYPE, the lone crypto asset in positive territory, carried volatility approaching one hundred percent—a punishing risk-reward tradeoff compared to gold's steady climb or the S&P's stability. Notably, Alphabet alone outperformed every tested portfolio, highlighting that sometimes concentrated conviction beats diversification when you pick correctly.

**Takeaway:** In risk-off environments, limiting crypto exposure to single-digit portfolio percentages while anchoring in quality equities and gold can preserve capital and dramatically improve risk-adjusted returns—the optimized portfolios' crypto allocation of under four percent proved far more effective than the equal-weight approach's heavier exposure.

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

2.090 1.701 1.312 0.923 0.534 2025-10-23 2025-11-28 2026-01-04 2026-02-09 2026-03-18 2026-04-24 GOOGL +91.9% GOLD +74.0% SPX +54.1% HYPE +51.3% TSLA +24.4% JLP +5.4% ETH -12.0% SOL -33.6%

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

1.274 1.027 0.780 0.533 0.286 2025-10-23 2025-11-28 2026-01-04 2026-02-09 2026-03-18 2026-04-24 GOOGL +10.5% SPX -11.3% HYPE -12.9% TSLA -28.4% JLP -39.3% BTC -42.4% ETH -49.3% SOL -61.8%

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

1.340 1.092 0.844 0.596 0.348 2025-10-23 2025-11-28 2026-01-04 2026-02-09 2026-03-18 2026-04-24 GOOGL +24.5% GOLD +12.8% HYPE -1.8% TSLA -19.3% JLP -31.6% BTC -35.1% ETH -42.9% SOL -56.9%

12 Months

Window: 2025-04-24 → 2026-04-24 (366 rows)

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: 84.49%
GOLD: 15.51%
JLP: 0.00%
BTC: 0.00%
GOOGL: 0.00%
TSLA: 0.00%
SOL: 0.00%
HYPE: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 29.16%
GOOGL: 14.06%
JLP: 6.78%
BTC: 0.00%
TSLA: 0.00%
HYPE: 0.00%
SOL: 0.00%
ETH: 0.00%
MaxSharpe ▲
GOOGL: 42.43%
SPX: 31.76%
GOLD: 21.53%
HYPE: 4.28%
TSLA: 0.00%
JLP: 0.00%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC -17.28%
ETH 30.80%
SOL -43.89%
HYPE 118.96%
GOLD 41.21%
SPX 29.60%
TSLA 44.01%
GOOGL 113.50%
JLP -5.99%

Correlation Matrix

BTC ETH SOL HYPE GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.836 0.824 0.518 0.069 0.428 0.333 0.184 0.889
ETH 0.836 1.000 0.868 0.555 0.042 0.439 0.377 0.240 0.907
SOL 0.824 0.868 1.000 0.571 0.032 0.384 0.341 0.190 0.981
HYPE 0.518 0.555 0.571 1.000 0.093 0.212 0.196 0.123 0.574
GOLD 0.069 0.042 0.032 0.093 1.000 0.064 0.033 0.088 0.048
SPX 0.428 0.439 0.384 0.212 0.064 1.000 0.547 0.530 0.409
TSLA 0.333 0.377 0.341 0.196 0.033 0.547 1.000 0.357 0.352
GOOGL 0.184 0.240 0.190 0.123 0.088 0.530 0.357 1.000 0.189
JLP 0.889 0.907 0.981 0.574 0.048 0.409 0.352 0.189 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 44.10% 35.66% 1.237 -28.88% -2.69% -3.83% 35.27%
MinVar 32.98% 11.59% 2.845 -9.76% -0.93% -1.40% 32.09%
MinVar-C50 43.08% 13.52% 3.188 -12.42% -1.00% -1.66% 41.79%
MaxSharpe 74.84% 17.39% 4.304 -13.21% -1.28% -1.86% 72.24%

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 -9.35% 42.72% -0.219 -49.74% -3.56% -5.04% -17.28%
ETH 68.87% 72.12% 0.955 -62.29% -5.21% -7.52% 30.80%
SOL -26.66% 73.17% -0.364 -68.60% -5.66% -8.03% -43.89%
HYPE 241.93% 95.59% 2.531 -64.19% -6.91% -9.00% 118.96%
GOLD 46.65% 27.33% 1.707 -17.73% -2.20% -3.70% 41.21%
SPX 30.61% 12.45% 2.458 -9.10% -1.06% -1.51% 29.60%
TSLA 61.71% 48.17% 1.281 -29.93% -3.66% -5.45% 44.01%
GOOGL 122.20% 28.46% 4.294 -20.37% -1.94% -2.83% 113.50%
JLP 1.18% 38.40% 0.031 -41.55% -2.84% -4.16% -5.99%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 84.5%, GOLD 15.5%
  • Highest-return tested portfolio: MaxSharpe — GOOGL 42.4%, SPX 31.8%, GOLD 21.5%, HYPE 4.3%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOOGL 42.4%, SPX 31.8%, GOLD 21.5%, HYPE 4.3%
  • Lowest-drawdown tested portfolio: MinVar — SPX 84.5%, GOLD 15.5%
  • Highest-return single asset: HYPE — 118.96%
  • Single-asset dominance ratio: 1.647x

Claude Narrative Report

## Portfolio Analysis: 12-Month Performance Review

Over the past year, crypto assets delivered a deeply uneven performance that defies the typical "rising tide lifts all boats" narrative. While HYPE posted exceptional gains and ETH managed modest growth, the major coins struggled significantly—Bitcoin finished deep in negative territory and Solana lost nearly half its value. Meanwhile, traditional assets quietly dominated: Google more than doubled, and even the S&P 500 and gold delivered solid returns with far less turbulence. This environment punished crypto-heavy portfolios and rewarded those with broader diversification.

The portfolio comparison reveals a striking lesson about risk management. An equal-weight approach across all assets produced moderate returns but with painful volatility and drawdowns approaching thirty percent. The optimized portfolios told a different story: the minimum variance strategy, built almost entirely on the S&P 500 with a gold buffer, delivered steadier returns while cutting maximum drawdown to single digits. The maximum Sharpe portfolio achieved the best risk-adjusted performance by concentrating in Google and traditional assets while allocating only a sliver to HYPE—just enough to capture upside without excessive exposure.

Single-asset analysis underscores why going all-in on crypto proved treacherous. Despite HYPE's headline-grabbing return, holding it alone meant enduring volatility near one hundred percent annualized and a drawdown exceeding sixty percent—a stomach-churning ride few investors could tolerate. Google, by contrast, delivered nearly comparable returns with a fraction of the volatility and a far shallower peak-to-trough decline, resulting in almost identical risk-adjusted performance. Bitcoin and Solana as standalone holdings destroyed value while inflicting maximum pain.

**Takeaway:** Rather than betting heavily on individual crypto assets, consider anchoring your portfolio in stable performers like broad equities and gold, then adding only modest crypto exposure—the data shows this approach captured meaningful upside while dramatically reducing the risk of catastrophic drawdowns.

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

2.961 2.356 1.751 1.146 0.541 2025-04-24 2025-07-06 2025-09-17 2025-11-29 2026-02-10 2026-04-24 HYPE +176.0% GOOGL +155.9% TSLA +90.2% GOLD +87.3% ETH +62.1% SPX +61.3% JLP +21.1% SOL -25.8%

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

2.530 1.945 1.359 0.773 0.188 2025-04-24 2025-07-06 2025-09-17 2025-11-29 2026-02-10 2026-04-24 HYPE +47.8% GOOGL +36.9% TSLA +1.6% ETH -13.2% SPX -13.7% JLP -35.3% BTC -46.5% SOL -60.3%

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

2.247 1.758 1.268 0.779 0.290 2025-04-24 2025-07-06 2025-09-17 2025-11-29 2026-02-10 2026-04-24 HYPE +71.1% GOOGL +58.6% TSLA +17.9% GOLD +16.1% ETH +0.5% JLP -24.9% BTC -38.0% SOL -54.0%

24 Months

Window: 2024-04-24 → 2026-04-24 (731 rows)

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: 65.77%
GOLD: 31.90%
JLP: 2.33%
GOOGL: 0.00%
BTC: 0.00%
TSLA: 0.00%
SOL: 0.00%
ETH: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 39.75%
JLP: 6.72%
GOOGL: 3.53%
BTC: 0.00%
TSLA: 0.00%
ETH: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 50.00%
GOOGL: 27.64%
SPX: 11.29%
JLP: 7.09%
TSLA: 3.99%
BTC: 0.00%
ETH: 0.00%
SOL: 0.00%

Asset Total Returns

Total Return
BTC 20.90%
ETH -26.27%
SOL -42.16%
GOLD 102.41%
SPX 40.16%
TSLA 130.51%
GOOGL 114.72%
JLP 49.62%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL JLP
BTC 1.000 0.820 0.786 0.077 0.398 0.335 0.254 0.833
ETH 0.820 1.000 0.783 0.048 0.418 0.345 0.292 0.839
SOL 0.786 0.783 1.000 0.043 0.345 0.288 0.226 0.947
GOLD 0.077 0.048 0.043 1.000 0.103 0.030 0.107 0.036
SPX 0.398 0.418 0.345 0.103 1.000 0.622 0.611 0.371
TSLA 0.335 0.345 0.288 0.030 0.622 1.000 0.439 0.309
GOOGL 0.254 0.292 0.226 0.107 0.611 0.439 1.000 0.247
JLP 0.833 0.839 0.947 0.036 0.371 0.309 0.247 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 32.12% 34.29% 0.937 -33.39% -2.62% -3.82% 55.31%
MinVar 28.00% 13.85% 2.022 -12.68% -1.03% -1.74% 60.75%
MinVar-C50 31.64% 14.22% 2.226 -12.06% -1.14% -1.78% 69.85%
MaxSharpe 44.98% 17.49% 2.572 -15.36% -1.47% -2.18% 103.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 22.89% 47.30% 0.484 -49.74% -3.69% -5.22% 20.90%
ETH 10.74% 71.76% 0.150 -63.24% -5.55% -8.01% -26.27%
SOL 5.65% 81.31% 0.070 -70.31% -6.36% -8.72% -42.16%
GOLD 46.06% 22.81% 2.019 -17.73% -1.74% -3.06% 102.41%
SPX 19.96% 16.29% 1.225 -18.90% -1.35% -2.08% 40.16%
TSLA 83.15% 61.82% 1.345 -53.77% -4.63% -6.86% 130.51%
GOOGL 53.30% 30.19% 1.766 -29.81% -2.31% -3.50% 114.72%
JLP 31.22% 37.55% 0.831 -41.55% -2.88% -4.17% 49.62%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 65.8%, GOLD 31.9%, JLP 2.3%
  • Highest-return tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 27.6%, SPX 11.3%, JLP 7.1%, TSLA 4.0%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 50.0%, GOOGL 27.6%, SPX 11.3%, JLP 7.1%, TSLA 4.0%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 39.7%, JLP 6.7%, GOOGL 3.5%
  • Highest-return single asset: TSLA — 130.51%
  • Single-asset dominance ratio: 1.256x

Claude Narrative Report

## Portfolio Analysis: A Rough Period for Crypto, A Strong Case for Diversification

Over the past two years, the crypto assets in this analysis dramatically underperformed nearly everything else. While Tesla and Google more than doubled and gold delivered triple-digit returns, Bitcoin barely managed a modest gain, and Ethereum and Solana posted steep losses. The volatility tells an even starker story: Solana experienced swings exceeding eighty percent annualized while delivering deeply negative returns, and Ethereum wasn't far behind. For investors who concentrated their holdings in these assets, the experience was painful—maximum drawdowns approached or exceeded sixty percent.

The diversified portfolios tell a completely different story. The minimum variance approach, which leaned heavily into the S&P 500 and gold with only a small allocation to the yield-generating JLP token, delivered roughly triple Bitcoin's return while experiencing less than a third of its volatility and a far shallower drawdown. The maximum Sharpe portfolio pushed further, capturing over one hundred percent returns by emphasizing gold and Google while still maintaining modest exposure to equities and JLP. Notably, none of the optimized portfolios held meaningful positions in Bitcoin, Ethereum, or Solana—the optimizer consistently found better risk-adjusted opportunities elsewhere.

The single-asset dominance ratio of 1.26 indicates that Tesla alone beat the equal-weight portfolio, but this masks the extreme risk involved. Tesla's drawdown exceeded fifty percent, meaning investors needed iron nerves to capture those gains. Meanwhile, the optimized portfolios achieved comparable or superior returns with far less stomach-churning volatility.

**Takeaway:** If you're a crypto-focused investor, this period demonstrates that holding concentrated positions in volatile tokens can destroy risk-adjusted returns; consider building a diversified core around less correlated assets like gold and broad equities, using crypto as a satellite allocation rather than the foundation.

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

2.359 1.851 1.343 0.835 0.327 2024-04-24 2024-09-17 2025-02-10 2025-07-06 2025-11-29 2026-04-24 TSLA +119.0% GOLD +89.4% GOOGL +78.1% JLP +32.1% SPX +20.7% ETH -38.0% SOL -46.0%

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

1.891 1.454 1.016 0.579 0.142 2024-04-24 2024-09-17 2025-02-10 2025-07-06 2025-11-29 2026-04-24 TSLA +15.9% GOOGL -5.6% JLP -29.8% SPX -36.1% BTC -46.8% ETH -66.9% SOL -71.2%

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

2.142 1.681 1.219 0.758 0.297 2024-04-24 2024-09-17 2025-02-10 2025-07-06 2025-11-29 2026-04-24 TSLA +81.5% GOLD +56.7% GOOGL +47.7% JLP +9.9% BTC -16.7% ETH -48.3% SOL -55.0%

3 Years

Window: 2023-04-24 → 2026-04-24 (1097 rows)

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: 65.21%
GOLD: 34.79%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 43.77%
GOOGL: 4.25%
BTC: 1.98%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%
MaxSharpe ▲
GOLD: 50.00%
GOOGL: 26.08%
SPX: 15.77%
BTC: 4.60%
SOL: 3.56%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 182.33%
ETH 25.62%
SOL 299.47%
GOLD 136.54%
SPX 71.82%
TSLA 129.91%
GOOGL 222.44%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL
BTC 1.000 0.808 0.730 0.053 0.321 0.268 0.174
ETH 0.808 1.000 0.711 0.050 0.365 0.286 0.232
SOL 0.730 0.711 1.000 0.017 0.292 0.219 0.192
GOLD 0.053 0.050 0.017 1.000 0.088 0.022 0.073
SPX 0.321 0.365 0.292 0.088 1.000 0.587 0.595
TSLA 0.268 0.286 0.219 0.022 0.587 1.000 0.395
GOOGL 0.174 0.232 0.192 0.073 0.595 0.395 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 51.97% 32.08% 1.620 -34.38% -2.54% -3.59% 201.35%
MinVar 26.05% 12.44% 2.094 -12.15% -0.93% -1.52% 95.80%
MinVar-C50 29.35% 12.80% 2.293 -12.11% -0.91% -1.59% 111.30%
MaxSharpe 41.36% 15.72% 2.631 -15.71% -1.17% -1.95% 172.47%

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 57.71% 47.06% 1.226 -49.74% -3.67% -5.27% 182.33%
ETH 33.26% 65.36% 0.509 -63.79% -5.15% -7.38% 25.62%
SOL 125.82% 84.68% 1.486 -70.31% -6.35% -8.71% 299.47%
GOLD 35.89% 19.88% 1.805 -17.73% -1.40% -2.59% 136.54%
SPX 21.09% 14.94% 1.412 -18.90% -1.22% -1.86% 71.82%
TSLA 55.53% 57.75% 0.962 -53.77% -4.33% -6.56% 129.91%
GOOGL 54.06% 29.16% 1.854 -29.81% -2.16% -3.46% 222.44%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 65.2%, GOLD 34.8%
  • 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 50.0%, GOOGL 26.1%, SPX 15.8%, BTC 4.6%, SOL 3.6%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 43.8%, GOOGL 4.3%, BTC 2.0%
  • Highest-return single asset: SOL — 299.47%
  • Single-asset dominance ratio: 1.487x

Claude Narrative Report

Over the past three years, Solana delivered extraordinary gains that dwarfed everything else in this analysis, roughly tripling what Bitcoin returned and more than tenfold what Ethereum managed. Google also stood out as a surprisingly strong performer among traditional assets, handily beating the broader market. Meanwhile, Ethereum significantly lagged its crypto peers, barely posting positive returns while carrying the highest volatility of any asset tested—a painful combination for anyone who held it in isolation.

The portfolio comparisons tell a compelling story about the power of diversification. While an equal-weight approach captured the highest raw return, it came with punishing drawdowns exceeding a third of portfolio value. The maximum Sharpe portfolio, which leaned heavily into gold and Google while maintaining only modest crypto exposure, delivered strong returns with far less volatility and a much shallower worst drawdown. The minimum variance strategies sacrificed upside but offered remarkable stability, proving that even small allocations to risk assets can enhance returns without dramatically increasing pain.

The single-asset numbers reveal that going all-in on any cryptocurrency meant stomach-churning drawdowns between fifty and seventy percent—declines most investors struggle to hold through emotionally. Gold and the S&P 500, by contrast, offered much smoother rides with respectable returns relative to their risk.

**Takeaway:** Rather than chasing the next Solana, crypto investors should consider a diversified approach anchored by traditional assets like gold and equities, with only a small tactical allocation to crypto—this captured most of the upside while cutting maximum drawdowns by more than half.

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

3.389 2.572 1.755 0.938 0.120 2023-04-24 2023-11-29 2024-07-05 2025-02-09 2025-09-16 2026-04-24 SOL +69.0% GOOGL +7.1% TSLA -9.1% GOLD -14.1% SPX -40.8% ETH -52.8%

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

6.947 5.208 3.469 1.731 -0.008 2023-04-24 2023-11-29 2024-07-05 2025-02-09 2025-09-16 2026-04-24 SOL +105.4% GOOGL +26.0% BTC +19.9% TSLA +7.8% SPX -30.4% ETH -42.8%

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

6.445 4.910 3.374 1.838 0.303 2023-04-24 2023-11-29 2024-07-05 2025-02-09 2025-09-16 2026-04-24 SOL +192.5% GOOGL +81.1% BTC +71.3% TSLA +54.5% GOLD +44.4% ETH -18.6%

4 Years

Window: 2022-04-25 → 2026-04-24 (1461 rows)

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: 54.99%
GOLD: 45.01%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
SOL: 0.00%
TSLA: 0.00%
MinVar-C50
SPX: 50.00%
GOLD: 50.00%
BTC: 0.00%
GOOGL: 0.00%
ETH: 0.00%
TSLA: 0.00%
SOL: 0.00%
MaxSharpe ▲
GOLD: 50.00%
SPX: 24.64%
GOOGL: 20.75%
BTC: 4.61%
SOL: 0.00%
TSLA: 0.00%
ETH: 0.00%

Asset Total Returns

Total Return
BTC 92.08%
ETH -23.08%
SOL -15.60%
GOLD 148.53%
SPX 65.46%
TSLA 12.34%
GOOGL 177.63%

Correlation Matrix

BTC ETH SOL GOLD SPX TSLA GOOGL
BTC 1.000 0.836 0.743 0.094 0.390 0.305 0.267
ETH 0.836 1.000 0.738 0.077 0.401 0.305 0.289
SOL 0.743 0.738 1.000 0.049 0.336 0.258 0.256
GOLD 0.094 0.077 0.049 1.000 0.119 0.021 0.096
SPX 0.390 0.401 0.336 0.119 1.000 0.590 0.674
TSLA 0.305 0.305 0.258 0.021 0.590 1.000 0.425
GOOGL 0.267 0.289 0.256 0.096 0.674 0.425 1.000

Tested Portfolio Comparison

Ann. Return Ann. Vol Sharpe-like Max Drawdown VaR 95% (daily) CVaR 95% (daily) Sample Total Return
Equal 29.11% 35.89% 0.811 -50.56% -2.76% -4.28% 114.75%
MinVar 20.67% 13.45% 1.536 -14.60% -1.09% -1.70% 104.48%
MinVar-C50 21.30% 13.51% 1.577 -14.42% -1.09% -1.71% 108.74%
MaxSharpe 26.42% 15.36% 1.720 -18.43% -1.26% -1.94% 143.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.99% 50.85% 0.668 -60.31% -3.93% -6.08% 92.08%
ETH 19.45% 69.90% 0.278 -66.21% -5.54% -8.34% -23.08%
SOL 51.74% 95.49% 0.542 -90.19% -7.31% -10.57% -15.60%
GOLD 27.82% 18.83% 1.477 -17.73% -1.40% -2.41% 148.53%
SPX 15.11% 17.25% 0.876 -18.90% -1.43% -2.21% 65.46%
TSLA 23.20% 60.11% 0.386 -65.96% -5.03% -7.40% 12.34%
GOOGL 35.81% 31.93% 1.122 -31.76% -2.46% -3.89% 177.63%

Deterministic Summary

  • Best low-risk tested portfolio: MinVar — SPX 55.0%, GOLD 45.0%
  • Highest-return tested portfolio: MaxSharpe — GOLD 50.0%, SPX 24.6%, GOOGL 20.8%, BTC 4.6%
  • Best risk-adjusted tested portfolio: MaxSharpe — GOLD 50.0%, SPX 24.6%, GOOGL 20.8%, BTC 4.6%
  • Lowest-drawdown tested portfolio: MinVar-C50 — SPX 50.0%, GOLD 50.0%
  • Highest-return single asset: GOOGL — 177.63%
  • Single-asset dominance ratio: 1.237x

Claude Narrative Report

## Portfolio Analysis: A Case for Diversification Over Crypto Concentration

The past four years have been humbling for crypto investors who expected digital assets to dominate. While Bitcoin delivered respectable gains, it was actually outpaced by both Google and gold by substantial margins. More striking, Ethereum and Solana both finished in the red despite the hype cycles, with Solana experiencing a devastating drawdown that wiped out over ninety percent of its value at the worst point. Meanwhile, traditional safe havens like gold quietly delivered strong returns with far less volatility.

The portfolio comparison reveals a compelling story about risk management. An investor who simply held Bitcoin alone would have endured gut-wrenching swings and a sixty percent drawdown, yet still underperformed every diversified portfolio tested. The minimum variance approach, which leaned heavily into broad equities and gold while avoiding crypto entirely, delivered solid returns with only a fraction of the volatility and a much shallower maximum decline. The most efficient portfolio by risk-adjusted measures combined gold, equities, Google, and just a small Bitcoin allocation — proving that a little crypto exposure goes a long way without requiring a concentrated bet.

What stands out is that the best-performing diversified portfolio outperformed a pure Bitcoin strategy by over fifty percentage points while cutting volatility by more than two-thirds. The optimal allocation treated Bitcoin as a seasoning rather than a main ingredient, dedicating less than five percent to it.

**Takeaway:** If you're tempted to go heavy into crypto, consider instead anchoring your portfolio in gold and broad equities, then adding only a modest Bitcoin position — you'll likely capture most of the upside while sleeping much better during the inevitable drawdowns.

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

1.953 1.509 1.066 0.622 0.178 2022-04-25 2023-02-11 2023-11-30 2024-09-17 2025-07-06 2026-04-24 GOOGL +26.8% GOLD +22.2% SPX -20.7% TSLA -37.5% SOL -45.1% ETH -56.8%

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

1.636 1.245 0.854 0.463 0.071 2022-04-25 2023-02-11 2023-11-30 2024-09-17 2025-07-06 2026-04-24 GOOGL +5.1% BTC -13.9% SPX -34.0% TSLA -47.5% SOL -51.5% ETH -62.3%

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

1.940 1.468 0.996 0.524 0.051 2022-04-25 2023-02-11 2023-11-30 2024-09-17 2025-07-06 2026-04-24 GOOGL +59.5% GOLD +52.5% BTC +29.0% TSLA -20.7% SOL -27.9% ETH -43.8%