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.

Medco Energi (MEDC) against…

Series	1M	3M	1Y ↓	n 1Y	3Y	3M − 3Y	Beta 1Y
JCI (IHSG) jci	0.11	0.30	0.27	240	0.20	+0.10	0.56	scatter
Brent brent	0.17	0.16	0.23	238	0.23	−0.06	0.22	scatter
LQ45 lq45	0.25	0.35	0.23	240	0.17	+0.18	0.45	scatter
Bukalapak (BUKA.JK) BUKA.JK	0.05	0.56	0.23	230	0.07	+0.49	0.29	scatter
Solusi Sinergi Digital (WIFI.JK) WIFI.JK	−0.03	0.23	0.16	230	0.07	+0.16	0.12	scatter
Metrodata (MTDL.JK) MTDL.JK	0.50	0.18	0.14	231	−0.03	+0.21 ⇄	0.29	scatter
Indosat (ISAT.JK) ISAT.JK	−0.12	0.26	0.14	231	0.06	+0.21	0.14	scatter
Emtek (EMTK.JK) EMTK.JK	0.14	0.44	0.14	230	0.03	+0.41	0.12	scatter
Sarana Menara (TOWR.JK) TOWR.JK	0.38	0.17	0.13	230	0.03	+0.14	0.17	scatter
Bitcoin btc	−0.33	0.00	0.08	245	0.10	−0.10	0.10	scatter
INDOGB 10YR id10y	0.14	−0.01	0.07	206	0.02	−0.03 ⇄	0.03	scatter
USD/IDR usdidr	0.32	0.09	0.07	245	0.05	+0.04	0.42	scatter
DCI Indonesia (DCII.JK) DCII.JK	−0.33	−0.23	0.07	230	−0.02	−0.21	0.09	scatter
Copper copper	−0.36	0.01	0.06	238	0.08	−0.07	0.11	scatter
UST 2YR ust2y	0.17	0.11	0.05	235	0.06	+0.05	0.04	scatter
Nasdaq 100 ndx	−0.38	0.05	−0.04	238	−0.04	+0.09 ⇄	−0.11	scatter
S&P 500 spx	−0.27	−0.01	−0.04	238	−0.04	+0.03	−0.17	scatter
Gold gold	−0.58	−0.12	0.03	238	0.05	−0.17 ⇄	0.05	scatter
DXY dxy	0.27	−0.11	0.02	238	0.02	−0.13 ⇄	0.22	scatter
UST 10YR ust10y	0.07	−0.02	0.02	235	0.05	−0.06 ⇄	0.01	scatter
GoTo (GOTO.JK) GOTO.JK	–	–	0.00	230	−0.04	–	0.00	scatter
PHLX Semiconductor (SOX) sox	−0.53	0.10	0.00	238	0.00	+0.09	0.00	scatter
Newcastle coal coal	–	–	–	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 Medco Energi (MEDC) 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 ↓

Medco Energi (MEDC) · JCI (IHSG)

20 60 120 252

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	−0.11	−0.03	0.08	0.07	−0.11	0.08	−0.06	0.17	0.10	−0.01	0.27	0.00	−0.03	0.00	−0.03	−0.07	0.17	−0.07	0.05	0.08	−0.21

Lag +k: today's change in Medco Energi (MEDC) against the change in JCI (IHSG) k readings later (positive = the first one leads). A peak away from 0 is a description of the past year only.