Government borrowing costs are at the mercy of oil prices

Oil/10-year Treasury, three-month rolling correlation (%)

Key points
  • Replication. The FT chart is the correlation of daily WTI log returns with daily changes in the 10Y yield, over a rolling 63-trading-day (3-month) window. It matches the FT's landmarks: +70 in late 1990 (Gulf War), −54 in early 2003 (Iraq war), +63 in 2026.
  • Gaps vs FT. FT starts in 1985 and looks slightly noisier, so it probably uses futures. FRED's WTI spot series starts in 1986.
  • Hypothesis (Erdem Hoca). The oil–yield link depends on the regime. Above some threshold the correlation switches on. Next step: a Hansen (2000) threshold model with the threshold γ estimated and bootstrap inference.
  • Warning. High oil–yield correlation shows up in two different regimes. In 2009–14 it was demand-driven: oil, stocks and yields all moved together. From 2022 it is supply/inflation-driven: oil and yields rise while stocks fall. A threshold on the oil price alone may lump the two together. Inflation or breakevens are strong alternative threshold variables (see the Stock–Bond tab).
  • "Gap vs avg" transform. Oil: ln(WTI) minus its trailing 12-month average. Bond: the 10Y yield level minus its trailing 12-month average, in pp; no log is needed for yields. It captures how far each market is from its recent norm, which is cycle-level co-movement rather than day-to-day reaction. Caveat: the gaps are very persistent (AR(1) ≈ 0.99), so a 3-month correlation swings between −90 and +98 (SD 47 vs 20 for returns), with |corr| > 50 in 44% of windows vs 4%. Use 12-month or longer windows with it. Its full-sample correlation is 0.38, and its 3-month version is higher than the FT measure in both 2009–14 (39 vs 25) and 2022–26 (36 vs 22).
  • LOESS (span 0.3, FT transform). The full-sample curve is an inverted U: the correlation rises from about 5% at $20 to about 23% around $80, then falls to about 5% near $115. That is not a simple "higher oil → stronger link". By period, the 2022+ curve falls from about 40% at $60 to about −5% above $110, while 2000–21 is flat at 10–25%. Whatever switches the regime does not look like the oil price level alone, which is consistent with inflation being the stronger threshold variable in the Research tab. The extremes rest on few, highly overlapping windows.
  • Descriptive split (3m window). Mean oil–bond correlation is 0.07 pre-2000, 0.15 in 2000–21 and 0.22 from 2022.
Oil
Window (months)
63 trading days
Transform
Frequency
Period
–
Methods & notation: what each setting computes

\(P_t\): oil price (WTI or Brent spot, $/bbl) on trading day \(t\); \(y_t\): 10-year Treasury yield (%). Only days with both series observed and \(P_t > 0\) are used. Each transform turns \((P_t, y_t)\) into a pair \((x_t, z_t)\), and the chart plots the rolling correlation of \(x\) and \(z\).

Δlog oil vs Δyield (FT replica)

\[\begin{aligned} x_t &= \ln P_t - \ln P_{t-1} \\ z_t &= y_t - y_{t-1} \end{aligned}\]

The oil return (log %) against the daily change in the yield (pp). It captures day-to-day co-movement.

% change

\[\begin{aligned} x_t &= P_t / P_{t-1} - 1 \\ z_t &= y_t / y_{t-1} - 1 \end{aligned}\]

Simple percentage changes of both. For the yield this is a relative change, which inflates moves when yields are low.

Levels

\[\begin{aligned} x_t &= P_t \\ z_t &= y_t \end{aligned}\]

Raw levels. Both are near-unit-root series, so the correlation is prone to being spurious.

Gap vs avg

\[\begin{aligned} x_t &= \ln P_t - \tfrac{1}{M}\textstyle\sum_{j=0}^{M-1} \ln P_{t-j} \\ z_t &= y_t - \tfrac{1}{M}\textstyle\sum_{j=0}^{M-1} y_{t-j} \end{aligned}\]

The deviation from a trailing average that includes day \(t\). \(M = 21 \times\) (average length in months), e.g. \(M = 252\) for 12 months. Oil in logs, yield in level (pp). The series are very persistent (AR(1) ≈ 0.99).

Rolling correlation (window \(W\))

\[\rho_t = 100 \times \frac{\sum_{s \in \mathcal W_t} (x_s - \bar x_t)(z_s - \bar z_t)}{\sqrt{\sum_{s \in \mathcal W_t} (x_s - \bar x_t)^2 \,\sum_{s \in \mathcal W_t} (z_s - \bar z_t)^2}}\] \[\mathcal W_t = \{t-W+1, \dots, t\}, \qquad \bar x_t = \tfrac{1}{W}\textstyle\sum_{s \in \mathcal W_t} x_s\]

A Pearson correlation over the last \(W\) observations, dated at the window's last day (trailing, no look-ahead). Daily: \(W = \operatorname{round}(21 m)\), so 3 months = 63 days. Weekly: \(W = \operatorname{round}(\tfrac{52}{12} m)\), so 3 months = 13 weeks. With "Gap vs avg" the first value needs \(M + W - 1\) days.

Weekly frequency

\(P_w, y_w\) are the last available observations in the week ending Friday. The transform is then applied to the weekly series, e.g. \(x_w = \ln P_w - \ln P_{w-1}\).

Oil threshold split

Each window is assigned by the oil price on its last day: high if \(P_t \ge c\), low otherwise. The tiles show \(\frac{1}{|\{t: P_t \ge c\}|}\sum_{t: P_t \ge c} \rho_t\) and its complement. This is descriptive only; the formal test is in the Research tab.

Bin means

\[\bar\rho_k = \operatorname{mean}\{\rho_t : 10k \le P_t < 10(k+1)\}\]

Bins of $10, shown only if they contain at least 20 windows.

LOESS

\[\begin{aligned} \hat g(p_0) &= \hat a, \quad (\hat a, \hat b) = \arg\min_{a,b} \textstyle\sum_i w_i e_i^2 \\ e_i &= \rho_i - a - b\,(P_i - p_0) \end{aligned}\]

Tricube weights \(w_i = (1 - |P_i - p_0|^3 / h^3)^3\) for \(|P_i - p_0| < h\), where \(h\) is the distance to the \(\lceil \text{span} \cdot n \rceil\)-th nearest \(P_i\). Evaluated between the 1st and 99th percentile of \(P\).

Is the correlation higher when oil is expensive?

Each point is one day: the rolling correlation against that day's oil price. The line is the mean correlation within $10 oil-price bins. This is a descriptive preview, not a formal threshold test.

LOESS: a smooth alternative to the bins

The same points with a LOESS curve: a local linear fit with tricube weights (Cleveland 1979). The span is the share of observations used in each local fit; smaller spans follow the data more closely. "By period" fits a separate curve for each regime, to show whether the oil-price/correlation relationship itself shifts. The curve is descriptive: overlapping windows make nearby points strongly dependent, so no confidence band is shown.

Span
Curves