# An Exponentially Weighted Covariance Matrix in R

Exponential weighting schemes can help navigate the trade-off between responsiveness and stability of the inherently noisy estimates we make from market data.

We previously saw examples of calculating the exponentially weighted moving average of a vector, and estimating the correlation between SPY and TLT using an exponential weighting scheme [link].

In this article, we’ll implement an exponentially weighted covariance matrix for a portfolio of assets.

Covariance describes the extent of co-movement between two assets.

From pair-wise covariances between assets in a portfolio, we can get the variance of the portfolio quite easily – it’s just the weighted sum of the covariances, given by ${w}^{T}\mathrm{\Sigma }ww^T \Sigma w$ where $ww$ is a vector representing the weights of each asset in the portfolio and $\mathrm{\Sigma }\Sigma$ is the covariance matrix. (Getting portfolio variance from the correlation matrix is a slightly more difficult computation).

And we can use the variance of the portfolio as a measure of risk.

So you see how a good forecast of covariance can be of benefit in portfolio construction.

I would like to use historical covariance as my forecast of future covariance. So firstly, let’s see if that stacks up. We’ll pull some data from Yahoo Finance into an R session and look at the relationship between past and future pair-wise covariances for a 3-asset ETF portfolio (SPY, TLT, GLD). We’ll start by estimating covariance over an equally weighted fixed window length (that is, no exponential weighting).

The functions being sourced in the code block below get data from Yahoo Finance and come from here.

library(tidyverse)
library(roll)

# Set chart options
options(repr.plot.width = 14, repr.plot.height=7, warn=-1)
theme_set(theme_bw())
theme_update(text = element_text(size = 20))

# functions for getting prices from Yahoo Finance
source("../data_tools/yahoo_prices.R")
# get data
tickers <- c("TLT", "SPY", "GLD")
prices <- yahoo_prices(
tickers,
from_date = "2004-11-18",
to_date = "2023-11-06"
) %>%
arrange(Date, Ticker)

head(prices)
A data.frame: 6 × 8
<date><chr><dbl><dbl><dbl><dbl><dbl><int>
12004-11-17SPY118.37119.14118.07118.5882.3728454494000
22004-11-17TLT 87.89 88.76 87.89 88.7048.90133 1249400
32004-11-18GLD 44.43 44.49 44.07 44.3844.38000 5992000
42004-11-18SPY118.53118.80118.23118.7482.4839631854300
52004-11-18TLT 88.55 89.06 88.41 88.9749.05021 891500
62004-11-19GLD 44.49 44.92 44.47 44.7844.7800011655300
# create log returns
returns <- prices %>%
group_by(Ticker) %>%
arrange(Date) %>%
mutate(
)

# covariance lookback period
wdw <- 90

# calculate rolling pairwise covariances over period as a long dataframe
rolling_cov <- returns %>%
na.omit() %>%
full_join(returns, by = "Date") %>%
ungroup() %>%
# drop diagonal
dplyr::filter(Ticker.x != Ticker.y) %>%
# get all combinations (Tickers) and remove duplicate combos (eg SPY-TLT, TLT-SPY)
mutate(Tickers = ifelse(Ticker.x < Ticker.y, glue("{Ticker.x}, {Ticker.y}"), glue("{Ticker.y}, {Ticker.x}"))) %>%
distinct(Date, Tickers, .keep_all = TRUE) %>%
# calculate rolling pairwise covariances
group_by(Tickers) %>%
arrange(Date, .by_group = TRUE) %>%
mutate(rolling_cov = roll::roll_cov(
x = log_return.x,
y = log_return.y,
width = wdw
)) %>%
select(Date, Tickers, rolling_cov)

tail(rolling_cov)
A grouped_df: 6 × 3
DateTickersrolling_cov
<date><chr><dbl>
2023-10-26SPY, TLT2.455208e-05
2023-10-27SPY, TLT2.487787e-05
2023-10-30SPY, TLT2.501001e-05
2023-10-31SPY, TLT2.577403e-05
2023-11-01SPY, TLT2.879114e-05
2023-11-02SPY, TLT3.412896e-05

Here’s a plot of rolling pairwise covariances:

# plot pairwise rolling covariances
rolling_cov %>%
ggplot(aes(x = Date, y = rolling_cov, colour = Tickers)) +
geom_line(size=0.8) +
# facet_wrap(~Tickers, ncol = 1) +
labs(
title = "Rolling Window Covariance Estimates",
subtitle = glue("Window length {wdw} days"),
colour = "Tickers"
) Next we look at whether past covariance is predictive of future covariance. We take non-overlapping periods and compare the covariance in one period to the covariance in the next.

options(repr.plot.width = 14, repr.plot.height=14)
rolling_cov %>%
group_by(Tickers) %>%
mutate(cov_lag = dplyr::lag(rolling_cov, wdw)) %>%
na.omit() %>%
# remove overlapping data
dplyr::filter(row_number() %% wdw == 0) %>%
ggplot(aes(x = cov_lag, y = rolling_cov)) +
geom_point() +
geom_smooth(method = lm) +
facet_wrap(~Tickers, ncol=1, scales = 'free') +
labs(
x = glue::glue("{wdw}-day covariance lagged {wdw} days"),
y = glue::glue("{wdw}-day covariance"),
title = "Does Covariance Predict Future Covariance?"
)
geom_smooth() using formula = 'y ~ x' The first thing that stands out is that any relationship between past and future covariance is extremely noisy at best.

The covariances of SPY-TLT and GLD-TLT are noisily “sticky” on average. If their covariance was high recently, then it’s slightly more likely to be high in the next period.

The GLD-SPY covariance showed the opposite relationship on average. If their covariance was high recently, then it’s slightly more likely to be low in the next period.

But that relationship seems to be driven by the large outlier in the top left of the chart above. Take that data point out, and the relationship looks a lot more like SPY-TLT and GLD-TLT. (For what it’s worth, that data point occurred in February 2009 – certainly an unusual time).

So based on the data above, let’s say that covariance is weakly and noisily predictive of future covariance.

In addition, the previous time series plot of rolling covariance shows that our covariance estimate wiggles around all over the place.

You can imagine that if my covariance forecast is unstable, that I’d be hyperactively changing my portfolio weights in response to this perceived change in risk. But those short-term fluctuations are mostly just noise, so maybe I can smooth out my estimate of historical covariance without losing a great deal of information.

So we’ll implement an exponentially weighted covariance matrix to try to smooth things out a bit.

## An exponentially weighted covariance

This approach to implemetning an exponentially weighted covariance is based on equations 5.6 and 5.7 in Risk Metrics (page 83):

${\mathrm{\Sigma }}_{1,2,t}=\lambda \left({\mathrm{\Sigma }}_{1,2,t-1}\right)+\left(1-\lambda \right)\ast \left({r}_{1,t-1}\ast {r}_{2,t-1}\right)\Sigma_\left\{1,2,t\right\} = \lambda \left(\Sigma_\left\{1,2,t-1\right\}\right) + \left(1 – \lambda\right)*\left(r_\left\{1,t-1\right\}*r_\left\{2,t-1\right\}\right)$

where ${\mathrm{\Sigma }}_{1,2,t}\Sigma_\left\{1,2,t\right\}$ is the covariance between assets $11$ and $22$ at time $tt$, ${r}_{1,t}r_\left\{1,t\right\}$ and ${r}_{2,t}r_\left\{2,t\right\}$ are the returns of assets $11$ and $22$ at time $tt$, and $\lambda \lambda$ is the exponential decay factor.

At the start of the calculation, I initialise $\mathrm{\Sigma }\Sigma$ to the covariance over some initial window, and ${r}_{1}r_1$ and ${r}_{2}r_2$ to the mean returns of the two assets over that same initial window.

# EWMA covariance estimate
# note definition of lambda in line with Risk Metrics
# ie higher values of lambda put less weight on the most recent returns and more weight on historical returns.
ewma_cov <- function(x, y, lambda, initialisation_wdw = 100) {
# TODO:
# check that x and y are the same length and greater than initialisation_wdw
# check NA removed

# create initialisation window and estimation window
init_x = x[1:initialisation_wdw]
init_y = y[1:initialisation_wdw]

num_obs <- length(x)

# initial covariance and mean return estimates
old_cov <- cov(init_x, init_y)
old_x <- mean(init_x)
old_y <- mean(init_y)

# preallocate output vector
ewma_cov <- vector(mode = "numeric", length = num_obs)

# pad with NA for initialisation window
ewma_cov[1:initialisation_wdw] <- NA

# covariance estimate
for(i in c((initialisation_wdw+1):num_obs)) {
ewma_cov[i] <- lambda*old_cov + (1 - lambda)*(old_x * old_y)
old_cov <- ewma_cov[i]
old_x <- x[i]
old_y <- y[i]
}
ewma_cov
}

Here’s how we can get a long dataframe of EW covariances using this function:

lambda <- 0.98
wdw <- 90

ewma_covs <- returns %>%
full_join(returns, by = "Date") %>%
na.omit() %>%
ungroup() %>%
# drop diagonal
dplyr::filter(Ticker.x != Ticker.y) %>%
# get all combinations (Tickers) and remove duplicate combos (eg SPY-TLT, TLT-SPY)
mutate(Tickers = ifelse(Ticker.x < Ticker.y, glue("{Ticker.x}, {Ticker.y}"), glue("{Ticker.y}, {Ticker.x}"))) %>%
distinct(Date, Tickers, .keep_all = TRUE) %>%
# calculate rolling pairwise ewma correlations
group_by(Tickers) %>%
arrange(Date, .by_group = TRUE) %>%
mutate(ewma_cov = ewma_cov(log_return.x, log_return.y, lambda = lambda, initialisation_wdw = wdw)) %>%
select(Date, Tickers, ewma_cov) %>%
na.omit()

tail(ewma_covs)
A grouped_df: 6 × 3
DateTickersewma_cov
<date><chr><dbl>
2023-10-26SPY, TLT2.871603e-05
2023-10-27SPY, TLT2.447412e-05
2023-10-30SPY, TLT2.437151e-05
2023-10-31SPY, TLT2.281108e-05
2023-11-01SPY, TLT2.174214e-05
2023-11-02SPY, TLT2.585833e-05

And here’s a plot of the EW covariance and the rolling window version:

options(repr.plot.width = 14, repr.plot.height=14)
ewma_covs %>%
left_join(rolling_cov, by = c("Date", "Tickers")) %>%
pivot_longer(c(-Date, -Tickers), names_to = "cov_type", values_to = "cov_est") %>%
ggplot(aes(x = Date, y = cov_est, colour = cov_type)) +
geom_line() +
facet_wrap(~Tickers, scales = "free_y", ncol = 1) +
labs(
title = "Rolling Window and EWMA Covariance Estimates",
subtitle = glue("Window length {wdw} days, lambda {lambda}")
) The EW covariance looks a little more responsive and possibly more stable – although it does wiggle around quite a lot.

Let’s play with the value of lambda to see how the covariance estimate behaves.

We’ll focus on 2020 so that you can see how different values of lambda make the estimate more or less responsive to a significant market event.

returns %>%
full_join(returns, by = "Date") %>%
na.omit() %>%
ungroup() %>%
# drop diagonal
dplyr::filter(Ticker.x != Ticker.y) %>%
# get all combinations (Tickers) and remove duplicate combos (eg SPY-TLT, TLT-SPY)
mutate(Tickers = ifelse(Ticker.x < Ticker.y, glue("{Ticker.x}, {Ticker.y}"), glue("{Ticker.y}, {Ticker.x}"))) %>%
distinct(Date, Tickers, .keep_all = TRUE) %>%
# calculate rolling pairwise ewma covariances
group_by(Tickers) %>%
arrange(Date, .by_group = TRUE) %>%
mutate(
lambda_0.90 = ewma_cov(log_return.x, log_return.y, lambda = 0.9, initialisation_wdw = wdw),
lambda_0.94 = ewma_cov(log_return.x, log_return.y, lambda = 0.94, initialisation_wdw = wdw),
lambda_0.97 = ewma_cov(log_return.x, log_return.y, lambda = 0.97, initialisation_wdw = wdw),
lambda_0.99 = ewma_cov(log_return.x, log_return.y, lambda = 0.99, initialisation_wdw = wdw),
lambda_0.999 = ewma_cov(log_return.x, log_return.y, lambda = 0.999, initialisation_wdw = wdw),
) %>%
na.omit() %>%
filter(Date >= "2020-01-01", Date <= "2020-12-31") %>%
select(Tickers, Date, starts_with("lambda")) %>%
pivot_longer(cols = starts_with("lambda"), names_to = "lambda", values_to = "ewma_cov") %>%
mutate(lambda = as.factor(as.numeric(stringr::str_extract(lambda, "[0-9]+\\.[0-9]+")))) %>%
ggplot(aes(x = Date, y = ewma_cov, colour = lambda)) +
geom_line(size=0.8) +
facet_wrap(~Tickers, ncol = 1, scales = "free_y") +
labs(
title = "EWMA Covariance Estimates in 2020",
subtitle = glue("Varying lambda"),
y = "Covariance"
) The trade-off between responsiveness and stability is clear. Lower values of lambda will respond more quickly and extremely to changes, whereas higher values of lambda will respond more slowly but more smoothly.

A sensible value of lambda will very much depend on your application, and you’ll probably end up tuning it a bit to find what works.

Next time, we’ll make this all a little more tangible when we have a look at one possible application – an Equal Risk Contribution portfolio optimisation problem.

### 2 thoughts on “An Exponentially Weighted Covariance Matrix in R”

1. Amazing content! Thanks for sharing