In the post pairs trading issues one of the problems raised was the unstable estimates of the stock’s beta with respect to the market. Here is a suggestion for a possible solution, which is not really a solution but more stuff to do to make you feel less stupid when trading based on your fragile estimates.

Have a look at the following figure:

We can see the intercept is not fluctuating much meaning indeed that if the market does not move, neither does MSFT. The beta however is comfortably fluctuating between a solid market follower, (beta = 1) to neutral (beta = 0), and can be even used to hedge the market at some short period (beta < 0), yeah sure, loads of economic sense in that estimate. Things of course get more volatile with a shorter window, 120 days roughly means the most recent 6 months which is not that short. Maybe we can find a compromise between the long term (stable) estimate and the short term one which might be more relevant but is also more erratic. A way to proceed is to simply average the two estimate. Less simple is to average them in a fancy way using what is commonly known as the shrinkage estimator*. I will shortly provide the figure and code but for now, a flat explanation for this method is that the averaging accounts for the dispersion in the X matrix, in our case it is just the market returns and the intercept, is the current period volatile or not? a more thorough explanation can be given using Singular Value Decomposition of the X matrix but we drop it here. We get a new beta estimate which is an average of the short and long term estimates. We need to decide how much shrinkage to apply. We have a parameter, called hyper parameter since it is chosen rather than estimated from the data, that determines the amount of shrinkage to apply, a low number would mean smaller pull towards the long term estimate and a high number would mean a larger pull towards the long term, so less weight is given to the short term estimate**. The result is:[caption id="attachment_1124" align="aligncenter" width="740" caption="The horizontal black line is the long run slope coefficient"][/caption]

You can see that the more shrinkage you apply the closer the estimate to its long run value. taking the hyper parameter to 0.1 will prevent the beta to fluctuate into negative territory yet still allowing some room for a possible structural changes. You can use this solution to reconsile a volatile estimation procedure with common sense arguments, e.g. might be that beta is indeed negative for this period in time, but does this make sense? might be that your estimate went negative only since you wanted to allow for a structural change, which is a good thing, and this resulted in “not so intuitive” estimate. Enforcing some structure in a smart way might be a simple way to move on. As always, code is given below, thanks for reading.

The following code includes a function to plot your own figures taking as input the time frame, window length and ticker you wish to view.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
library('quantmod') plotbet = function(sym,w,years = 5){ library(quantmod) sym = c(sym,'SPY') # SPY is proxy for the S&P end<- format(Sys.Date(),"%Y-%m-%d") start<-format(Sys.Date() - years*365,"%Y-%m-%d") dat0 = (getSymbols(sym[2], src="google", from=start, to=end, auto.assign = F, warnings = FALSE,symbol.lookup = F)) n = NROW(dat0) ; l = length(sym) dat = array(dim = c(n,NCOL(dat0),l)) ; ret <<- matrix(nrow = n, ncol = l) # Write the return matrix up one level for (i in 1:l){ dat0 = (getSymbols(sym[i], src="google", from=start, to=end, auto.assign = F,warnings = FALSE,symbol.lookup = F)) dat[1:NROW(dat0),,i] = dat0 ret[2:NROW(dat0),i] <<- dat[2:NROW(dat0),4,i]/dat[1:(NROW(dat0)-1),4,i] - 1 } bet0 = NULL ; bet1 = NULL for (i in 1:(n-w)){ bet0[i] = lm(ret[i:(i+w),1]~ret[i:(i+w),2])$coef[1] bet1[i] = lm(ret[i:(i+w),1]~ret[i:(i+w),2])$coef[2] } bet0lt <<- lm(ret[,1]~ret[,2])$coef[1] # write it up one level bet1lt <<- lm(ret[,1]~ret[,2])$coef[2] # we need it later as a prior mean plot(bet0, ty = "l", ylab = "Intercept", xlab = "Time", main = "Intercept over Time - moving window estimation") abline(bet0lt,0,col = 4, lwd = 3) legend("bottomleft",c("Short run estimate - moving window", "Long run estimate - full sample"), bty = "n", lty = c(1,1), lwd = c(1,2), col = c(1,4)) plot(bet1, ty = "l", ylab = "Slope", xlab = "Time", main = "Beta over Time - moving window estimation") legend("bottomleft",c("Short run estimate - moving window", "Long run estimate - full sample"), bty = "n", lty = c(1,1), lwd = c(1,2), col = c(1,4)) abline(bet1lt,0,col = 4, lwd = 3) } par(mfrow = c(2,1)) plotbet('MSFT',wl, years = 5) wl = 120 ; n = NROW(ret) bet0 = NULL ; bet1 = NULL AmountSrhink <- 0.01 #AKA regularization parameter A = AmountSrhink*diag(2) # you can try different values instead of diagonal # Maybe you don't want to shrink the intercept in another application prior_beta = c(bet0lt,bet1lt) postbet = matrix(nrow = (n-wl), ncol = 2) for (i in 2:(n-wl)){ # ret[1,] is NA bet0[i] = lm(ret[i:(i+wl),1]~ret[i:(i+wl),2])$coef[1] bet1[i] = lm(ret[i:(i+wl),1]~ret[i:(i+wl),2])$coef[2] x = cbind(rep(1,(wl+1)),ret[i:(i+wl),2]) postbet[i,] = solve(t(x)%*%x +A) %*% ( (t(x)%*%x)%*%c(bet0[i],bet1[i]) + A%*%prior_beta ) } par(mfrow = c(1,1)) plot(postbet[,2], ty = "l") ; abline(bet0lt,0,col = 4, lwd = 3) lines(bet1, col = 2, lty = 2) |

**NOTES:**

* The idea is related to “Ridge Regression” and can also be viewed as a semi-bayesian approach where the prior has mean equal to the long term estimate.

– I skip the “interesting” explanation through the Singular Value Decomposition of the predictor matrix.

– The new estimate is biased but whatever, we are not into inference anyway.

** thats specifically for the code, but you may find it is reveresed in other texts, depending on math definitions.

*** “<<-" is a nice operator mentioned in "The art of R programming" book, it writes the object into the upper level.

Hi Eran,

The line: wl = 120 ; n = NROW(ret), is not working because ret is not set.

By the way I like your blog.

Regards, André

Hi Andre,

Thanks for the comment.

The super-assignment operator writes the variable after you run the function. So plotbet() needs to come first, I updated the post.

O, so your the one..