1995issue C041-2
Pin one reference close and roll companion correlations as an overlay
Treat rolling intermarket correlation as a construction problem first. Lock one reference-close, estimate each companion-series over a copied lookback-window, and read the strip against the same contract instead of in isolation.
- A correlation-coefficient measures the degree and direction of a linear association between two series and is bounded by 1 and -1.
- Pin every companion estimate to one reference-close so the short market strip stays aligned to the same contract.
- A 30-session lookback-window copied down the history produces a rolling series rather than a single static reading.
- A dual-axis-overlay can keep the reference high, low, and close on the primary scale and the rolling coefficients on a secondary scale.
What the coefficient measures
A correlation-coefficient measures the degree and direction of a linear association between two series and is bounded by 1 and -1. Illustrative readings of 0.90, 0, and -0.90 are used to mark a strong same-direction linear link, no linear link, and a strong inverse link.
The coefficient is formed with one series treated as independent and the other as dependent. The same measure can be applied to weekly closes of a stock versus a broad equity benchmark or to daily closes in a multi-market workbook.
Lock a single reference-close
One construction pins every companion correlation to a single Treasury-bond futures closing-price column while storing the date, high, low, and close for that reference contract. Companion-series in the worked sheet cover a dollar index, a commodity index, an equity benchmark, gold, a finance-sector index, and a utility-sector index.
Editorial reading: the sheet is built so a single position can be read against a short companion-market strip, not as an isolated reading.
Copy the lookback-window down the sheet
Each coefficient is estimated over a 30-session lookback-window that is then copied down the history to produce a rolling series. Locking the reference-close column while copying the formula across companion columns keeps every estimate aligned to the same contract.
Place coefficients on a second axis
The reference high, low, and close can occupy the primary price axis while the rolling coefficients occupy a secondary overlay axis. That dual-axis-overlay keeps the contract path and the linkage strip visible together.
All readings on this track · 37 readings
- 1988Constructing a lead-aware correlation coefficient
- 1989A precious-metal price as a changing intermarket equation
- 1990Two clocks for copper: a factor regime, a regression baseline, and leftover moving-average timing
- 1990Earnings yield, rate correlation and regression for equity value
- 1991Name the window, then combine leaders
- 1991Constructing a two-market linear correlation check
- 1991Constructing a commodity-bond correlation regime filter
- 1992Building intermarket context with linear correlation
- 1993Inverse-scale overlays as a gold-equity regime filter
- 1994Constructing seasonal slots from windows, analog years, and implied volatility
- 1995Pin one reference close and roll companion correlations as an overlay
- 1995Rolling correlation windows for shifting intermarket regimes
- 1998Gold as a cross-market regime barometer
- 1999The gold-bond inverse is a regime, not a cause
- 1999A nested lag test of gold leading bond yields
- 1999Constructing spreads from stock and intermarket correlation
- 2000Evaluating headline versus food-and-energy-excluded CPI as bond-yield context
- 2005A late EUR/USD fifth wave tested by the Bund-Treasury gap
- 2006Intermarket dislocation as context for short-horizon momentum
- 2008Map ordinary 12-month outcomes before stacking valuation, rates, and seasonality
- 2008A clean-energy theme inside the oil-and-energy regime
- 2014Quantitative-easing overlays as fragile belief regimes
- 2015Three intermarket checks from the late-2014 crude decline
- 2015Basket construction via rank, correlation, and locked rules
- 2015Construct a CAD-oil pair from percent-of-range Bollinger maps
- 2015CAD/USD and crude: first the correlation, then the band gap
- 2017Correlation regime versus moving-average crossover for S&P 500 exposure
- 2017Updating intermarket systems after correlation shifts
- 2017Constructing a correlation-divergence regime filter for yen and Nikkei context
- 2018Clustered negative troughs in an energy-index pairwise correlation
- 2018Filter pairwise-correlation before reading an intermarket regime
- 2018Moving-average supports in the March 2018 correlation shock
- 2020Bond spreads as an equity regime lens
- 2020Crash-protection folklore as a correlation regime question
- 2020Constructing a bounded correlation-trend-filter
- 2020Constructing a correlation-to-line trend filter
- 2020Bitcoin correlation regimes across equities and gold