Serving the Quantitative Finance Community

 
User avatar
misi
Topic Author
Posts: 0
Joined: November 17th, 2002, 3:49 pm

covariance matrix: daily or monthly returns?

January 10th, 2005, 8:02 am

in a porfolio optimization problem is it better to use daily or monthly returns?the trade-off is as follow:- monthly returns held better properties (less leptokurtosis etc.);- daily returns increase the number of observations for the same time period;For the latter reason I use daily returns. I clean data from autocorrelation using residuals and then I compute the covariance matrix.At this point I don't know how I can trasform this matrix to apply a monthly optimization approach.for instance for volatility in a general case people applythis relationship sigma(yearly)=sigma(daily)*sqrt(250).What about correlation and covariance?any idea? please, could you help me to clarify.As you can see I'm a bit confused.
 
User avatar
gjlipman
Posts: 5
Joined: May 20th, 2002, 9:13 pm

covariance matrix: daily or monthly returns?

January 10th, 2005, 9:14 am

Assuming multivariate normal distributions,sigma annual = sigma daily * sqrt(250)variance annual = variance daily * 250covarience annual = covariance daily * 250as correlation = covariance / (sigma_i * sigma_j)then it should be clear thatcorrelation annual = correlation daily.
 
User avatar
misi
Topic Author
Posts: 0
Joined: November 17th, 2002, 3:49 pm

covariance matrix: daily or monthly returns?

January 10th, 2005, 12:12 pm

thanks gjlipman,but are you really sure that annual correlation is equal to daily correlation?I would like to ask you if you know a good "practical" book for portfolio mgmt?
 
User avatar
Gmike2000
Posts: 0
Joined: September 25th, 2003, 9:49 pm

covariance matrix: daily or monthly returns?

January 10th, 2005, 1:16 pm

Use weekly. Daily may run you into the problem of data holes, where e.g. one market is on holiday and the other is not. Also there is too much noise. Monthly is too coarse. Use weekly, then do the scaling glpglman suggested.
 
User avatar
luebke
Posts: 0
Joined: August 17th, 2004, 5:40 pm

covariance matrix: daily or monthly returns?

January 11th, 2005, 9:58 am

It depends on your application. Usually, you optimize your portfolio for one period. Then the correlation should be estimated on a history of values with this period length. All other approaches (explicitely or implicitely) assume some (mathematical) model, e.g. Brownian motion. Use different estimators to get an idea of the reliability of your estimates.
 
User avatar
htmlballsup
Posts: 0
Joined: February 9th, 2004, 10:23 am

covariance matrix: daily or monthly returns?

January 11th, 2005, 10:04 am

QuoteOriginally posted by: misithanks gjlipman,but are you really sure that annual correlation is equal to daily correlation?I would like to ask you if you know a good "practical" book for portfolio mgmt?MisiModern Investment Management, Litterman has a whole chapter on covariance matrix estimation, and in general is an excellent intro to portfolio management. In addition if you ever go for an interview with GS it'll stand you in great stead - (they wrote it).