IDEN

Relationship Lab

How a series has moved with others: the correlation of daily changes (% for prices, bp for rates) over 1 and 3 years, the beta, a rolling correlation and whether one tends to move first. Correlation is not causation, and it changes over time.

MSFT capex (quarterly) against…

Series1M3M1Y ↓n 1Y3Y3M − 3YBeta 1Y
Nasdaq 100
ndx
–– −1.003−0.76 – −2.22scatter
PHLX Semiconductor (SOX)
sox
–– −0.993−0.75 – −1.24scatter
S&P 500
spx
–– −0.983−0.82 – −2.55scatter
Copper
copper
–– −0.953−0.67 – −2.23scatter
Gold
gold
–– −0.943−0.86 – −2.33scatter
Brent
brent
–– −0.913−0.64 – −1.24scatter
DXY
dxy
–– 0.7830.72 – 10.58scatter
UST 10YR
ust10y
–– 0.7030.67 – 0.57scatter
UST 2YR
ust2y
–– 0.6230.69 – 0.82scatter
USD/IDR
usdidr
–– −0.603−0.16 – −6.39scatter
Bitcoin
btc
–– −0.593−0.56 – −1.11scatter
Hyperscaler capex (5 cos, quarterly)
capex_total
–– 0.5140.60 – 0.20scatter
INDOGB 10YR
id10y
–– −0.484−0.36 – −0.66scatter
META capex (quarterly)
capex_META
–– 0.3040.33 – 0.22scatter
GOOGL capex (quarterly)
capex_GOOGL
–– −0.1740.25 – −0.20scatter
CRWV capex (quarterly)
capex_CRWV
–– −0.1440.05 – −0.28scatter
AMZN capex (quarterly)
capex_AMZN
–– 0.1040.28 – 0.14scatter
JCI (IHSG)
jci
–– –2−0.96 – –scatter
LQ45
lq45
–– –2−1.00 – –scatter
Newcastle coal
coal
–– –0– – –scatter
NVDA capex (quarterly)
capex_NVDA
–– –0– – –scatter
Nvidia revenue (quarterly)
nvda_rev
–– –0– – –scatter
ORCL capex (quarterly)
capex_ORCL
–– –0– – –scatter

Compared with the headline cross-asset series and the series in the same catalog category and country. Changes are matched on common dates. Beta = change in MSFT capex (quarterly) per unit change in the other series (least squares, 1 year). Amber: fewer than 20 common changes (hover a value for its n). Stability: the 3-month correlation minus the 3-year one; ⇄ marks opposite signs. A change in correlation describes the past; it does not say the relationship has broken or will return. Data ↓

MSFT capex (quarterly) · Nasdaq 100
2060120252

Not enough common dates for a rolling correlation.

Rolling correlation of daily changes over the last 60 common readings, last 3 years.

Who moves first? (1 year)

Lag (readings)-10-9-8-7-6-5-4-3-2-1+0+1+2+3+4+5+6+7+8+9+10
correlation––––––––––−1.00––––––––––

Lag +k: today's change in MSFT capex (quarterly) against the change in Nasdaq 100 k readings later (positive = the first one leads). A peak away from 0 is a description of the past year only.