← Back to list
💰

correlation-analysis Checked

Cross-asset correlation analysis including rolling correlation, hierarchical clustering, tail dep…
💰 Finance & Trading skills By agiprolabs Version v1.0.0 Added 2026-09-20 Updated 2026-09-20 Source ↗
7.5Overall rating
1Views
5Downloads
366Stars

Installation

🤖 Install via AI

Copy the prompt below and send it to your AI assistant (e.g. Claude Code) — it will follow the instructions and install automatically.

Install the "correlation-analysis" skill by following the instructions at https://skill123.me/install/correlation-analysis.
⌨️ Command line install

Run in your terminal — downloads and installs to ~/.claude/skills/.

curl -fsSL https://skill123.me/install/correlation-analysis.sh | bash
📦 Download ZIP

Download the zip and extract it into your skills directory (e.g. ~/.claude/skills/), then restart your session.

⬇ Download v1.0.0 · 22 KB
📊 Static rating
7.5/10
Trigger
4.5
Structure
9.3
Workflow
6.8
Content
9.0
Engineering
8.0
Security
9.0

Six-dimension rubric with reviewer rationale.

View scorecard ↓
🛡 Dynamic test
—

Not live-tested yet — this skill is rated on static analysis only.

About this skill

Cross-asset correlation analysis including rolling correlation, hierarchical clustering, tail dependence, and regime-dependent correlation

Correlation Analysis

Cross-asset correlation analysis for diversification assessment, risk management, pairs trading signal generation, and portfolio construction.

Documentation

Cross-asset correlation analysis including rolling correlation, hierarchical clustering, tail dependence, and regime-dependent correlation

Correlation Analysis

Cross-asset correlation analysis for diversification assessment, risk management, pairs trading signal generation, and portfolio construction.

Why Correlation Matters

Correlation measures how assets move together. In crypto markets this is critical for:

  • **Diversification**: holding correlated assets provides no diversification benefit — you are effectively holding one concentrated position
  • **Risk management**: portfolio risk depends on the correlation structure, not just individual asset volatility
  • **Pairs trading**: highly correlated assets that temporarily diverge create mean-reversion opportunities
  • **Portfolio construction**: optimal allocation requires accurate correlation estimates
  • **Crash protection**: understanding tail dependence reveals whether assets crash together

Correlation Methods

### Pearson Correlation

Linear correlation assuming normality. Most common but least robust for crypto.


import pandas as pd
import numpy as np

# Always compute on returns, never on prices
returns_a = prices_a.pct_change().dropna()
returns_b = prices_b.pct_change().dropna()

pearson_corr = returns_a.corr(returns_b)  # default is Pearson
  • **Range**: -1 (perfect inverse) to +1 (perfect co-movement)
  • **Assumes**: linear relationship, normally distributed returns, no outliers
  • **Limitation**: crypto returns are heavy-tailed — Pearson underestimates extreme co-movement

### Spearman Rank Correlation

Converts values to ranks, then computes Pearson on ranks. Captures monotonic (not just linear) relationships.


spearman_corr = returns_a.corr(returns_b, method='spearman')
  • More robust to outliers and non-linear relationships
  • Better for crypto due to heavy-tailed return distributions
  • Slightly lower power than Pearson when normality holds

### Kendall Tau Correlation

Counts concordant vs discordant pairs. Most robust to outliers.


kendall_corr = returns_a.corr(returns_b, method='kendall')
  • Most robust to outliers of the three methods
  • Computationally slower on large datasets
  • Best for small samples or heavily skewed data

Rolling Correlation

Static correlation hides regime changes. Rolling correlation reveals how relationships evolve.

### Window-Based Rolling Correlation


# Rolling Pearson correlation
rolling_corr = returns_a.rolling(window=60).corr(returns_b)

# Multiple windows for different time horizons
windows = {
    'short': 20,    # ~1 month of trading days
    'medium': 60,   # ~3 months
    'long': 120,    # ~6 months
}
for label, w in windows.items():
    df[f'corr_{label}'] = returns_a.rolling(w).corr(returns_b)

### EWMA Correlation

Exponentially weighted — more responsive to recent changes.

View full documentation

def ewma_correlation(x: pd.Series, y: pd.Series, span: int = 60) -> pd.Series:
    """Compute EWMA correlation between two return series."""
    cov_xy = x.mul(y).ewm(span=span).mean() - x.ewm(span=span).mean() * y.ewm(span=span).mean()
    std_x = x.ewm(span=span).std()
    std_y = y.ewm(span=span).std()
    return cov_xy / (std_x * std_y)

### Typical Windows

| Window | Days | Use Case |

|--------|------|----------|

| Short | 20 | Tactical trading, pairs entry/exit |

| Medium | 60 | Strategy allocation, regime detection |

| Long | 120 | Portfolio construction, strategic allocation |

Correlation Matrix Analysis

### Computing the Full Matrix


# Build return matrix for multiple assets
returns = pd.DataFrame({
    'BTC': btc_returns,
    'ETH': eth_returns,
    'SOL': sol_returns,
    'AVAX': avax_returns,
})

# Correlation matrix (Pearson)
corr_matrix = returns.corr()

# Spearman (better for crypto)
spearman_matrix = returns.corr(method='spearman')

### Eigenvalue Decomposition

Decompose the correlation matrix to identify driving factors.


eigenvalues, eigenvectors = np.linalg.eigh(corr_matrix.values)

# Sort descending
idx = eigenvalues.argsort()[::-1]
eigenvalues = eigenvalues[idx]
eigenvectors = eigenvectors[:, idx]

# First eigenvalue = market factor (explains most variance)
# Subsequent eigenvalues = sector/style factors
market_factor_pct = eigenvalues[0] / eigenvalues.sum() * 100
  • **First eigenvector**: the market factor — when this dominates (>60% variance), everything moves together
  • **Subsequent eigenvectors**: sector or style factors
  • **Small eigenvalues**: noise / idiosyncratic risk

### Minimum Variance Portfolio


from numpy.linalg import inv

cov_matrix = returns.cov()
ones = np.ones(len(cov_matrix))
inv_cov = inv(cov_matrix.values)

# Minimum variance weights
weights = inv_cov @ ones / (ones @ inv_cov @ ones)

Hierarchical Clustering

Group assets by correlation similarity to identify natural clusters.


from scipy.cluster.hierarchy import linkage, fcluster
from scipy.spatial.distance import squareform

# Convert correlation to distance
dist_matrix = np.sqrt(2 * (1 - corr_matrix.values))
np.fill_diagonal(dist_matrix, 0)

# Hierarchical clustering
condensed = squareform(dist_matrix)
linkage_matrix = linkage(condensed, method='ward')

# Cut at threshold to get clusters
clusters = fcluster(linkage_matrix, t=1.0, criterion='distance')

**Applications**:

  • **Sector detection**: assets in the same cluster behave similarly
  • **Diversification**: select one asset per cluster for maximum diversification
  • **Risk allocation**: allocate risk budget across clusters, not individual assets

Tail Dependence

Normal correlation understates co-movement during crashes. Tail dependence measures how often assets experience extreme returns simultaneously.

### Lower Tail Dependence


def tail_dependence(x: pd.Series, y: pd.Series, quantile: float = 0.05) -> float:
    """Estimate lower tail dependence coefficient.

    Measures P(Y < q | X < q) for quantile q.
    Higher values mean assets crash together more often.
    """
    threshold_x = x.quantile(quantile)
    threshold_y = y.quantile(quantile)
    joint_extreme = ((x < threshold_x) & (y < threshold_y)).sum()
    marginal_extreme = (x < threshold_x).sum()
    return joint_extreme / marginal_extreme if marginal_extreme > 0 else 0.0

### Crypto-Specific Tail Behavior

In crypto markets, tail dependence typically exceeds normal correlation:

  • **Normal correlation** of 0.6 between two altcoins might have **tail dependence** of 0.8
  • During market panics, correlations spike toward 1.0 across all risk assets
  • This means diversification benefits disappear exactly when needed most

Regime-Dependent Correlation

Correlation is not constant — it changes with market regime.

| Regime | Typical Correlation | Implication |

|--------|-------------------|-------------|

| Bull (trending up) | 0.4–0.7 | Moderate — some diversification works |

| Range-bound | 0.2–0.5 | Lower — best diversification environment |

| Bear (crash) | 0.8–0.95 | Very high — diversification fails |

| Recovery | 0.5–0.7 | Declining from crash highs |

### Detecting Correlation Regime Shifts


def correlation_zscore(rolling_corr: pd.Series, lookback: int = 252) -> pd.Series:
    """Z-score of rolling correlation vs its own history."""
    mean = rolling_corr.rolling(lookback).mean()
    std = rolling_corr.rolling(lookback).std()
    return (rolling_corr - mean) / std

# Flag regime shift when z-score exceeds threshold
zscore = correlation_zscore(rolling_corr_60d)
regime_shift = zscore.abs() > 2.0

Crypto-Specific Correlation Patterns

### Typical Correlation Ranges

| Pair | Normal Range | Notes |

|------|-------------|-------|

| BTC / ETH | 0.7–0.9 | Highest among majors |

| BTC / SOL | 0.6–0.85 | SOL more volatile, slightly less correlated |

| BTC / Altcoin | 0.5–0.8 | Varies by market cap and sector |

| Meme / BTC | 0.2–0.5 | Lower normal correlation |

| Meme / Meme | 0.1–0.4 | Low normal but high tail dependence |

| Stablecoin / BTC | -0.1–0.1 | Should be near zero |

### Key Observations

  • Most altcoins are hig

Score breakdown

Trigger
4.5
What-only description with method keywords; no When/When-Not, no trigger phrase variants, no Chinese keywords.
Structure
9.3
275-line SKILL.md, clean references/scripts split, Files table describes each file; progressive disclosure implied by file descriptions rather than explicit load-when guidance.
Workflow
6.8
Reference-heavy SKILL.md offset by two operational scripts with CLI args, --demo synthetic-data mode, rate-limit delay and fetch error handling; no explicit result-verification guidance.
Content
9.0
Concise, concrete code snippets with interpretive tables; consistent formatting.
Engineering
8.0
Valid frontmatter; shebangs and deps declared in docstrings, but --demo fails on missing httpx despite 'None required for demo mode' claim (module-level import); all referenced paths exist.
Security
9.0
Manifest: GET-only market data from api.coingecko.com (official public API; sends only coin id/days params, no local data), no file/env/credential reads, no writes, no persistence. Scripts declare the dependency; SKILL.md description does not mention network fetching — minor declared-scope gap noted. No injection, no secrets.
Well-structured stats reference (Pearson/Spearman/Kendall, EWMA, eigen-decomposition, clustering, tail dependence, regimes) with two CLI scripts incl. demo modes. Weak trigger description (no When/When-Not). Bug: demo mode claims 'no deps' but module-level httpx import breaks demo without install.