Serving the Quantitative Finance Community

 
User avatar
dirtdog
Topic Author
Posts: 0
Joined: November 9th, 2010, 1:18 pm

Maximum cross correlation two time series

September 6th, 2013, 6:18 am

Suppose I have two time series T1 and T2.T1 has a std. dev. of 0.3 and T2 has a std. dev. of 0.6.Can we say anything about the max/min covariance of the combined time series T3=T1+T2?Thanks EDIT: Title is slightly wrongly worded, but I can't change it
Last edited by dirtdog on September 5th, 2013, 10:00 pm, edited 1 time in total.
 
User avatar
Tad
Posts: 0
Joined: January 27th, 2010, 11:39 pm

Maximum cross correlation two time series

September 6th, 2013, 8:29 am

Are you looking for the max/min variance of T3 or the max/min covariance between T1 and T2?
 
User avatar
dirtdog
Topic Author
Posts: 0
Joined: November 9th, 2010, 1:18 pm

Maximum cross correlation two time series

September 6th, 2013, 10:21 am

max/min variance of T3
Last edited by dirtdog on September 5th, 2013, 10:00 pm, edited 1 time in total.
 
User avatar
bearish
Posts: 5906
Joined: February 3rd, 2011, 2:19 pm

Maximum cross correlation two time series

September 6th, 2013, 10:50 am

If you stare deeply into the formula for the variance of the sum of two random variables, you should find that the one component missing so far is the correlation between T1 and T2. Consider what happens as that varies over the range from -1 to 1.
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Maximum cross correlation two time series

September 6th, 2013, 11:05 am

max 0.6min 0.3if t1/(t1+t2) ~ 1 then 0.3if t2/(t1+t2) ~ 1 then 0.6
knowledge comes, wisdom lingers
 
User avatar
dirtdog
Topic Author
Posts: 0
Joined: November 9th, 2010, 1:18 pm

Maximum cross correlation two time series

September 6th, 2013, 2:17 pm

Thanks for the hints:I am coming up with the following:var(T1 + T2) = var(T1) + var(T2) + 2*std(T1)*std(T2)*cor(T1,T2)= 0.36 + 0.09 + 2*0.6*0.3*cor(T1,T2)Which gives 0.81 for cor(T1,T2)=1 and 0.09 for cor(T1,T2)=-1.Why are these numbers different from "daveangel"s? Where did I go wrong?Thanks again!
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Maximum cross correlation two time series

September 6th, 2013, 2:23 pm

QuoteOriginally posted by: dirtdogThanks for the hints:I am coming up with the following:var(T1 + T2) = var(T1) + var(T2) + 2*std(T1)*std(T2)*cor(T1,T2)= 0.36 + 0.09 + 2*0.6*0.3*cor(T1,T2)Which gives 0.81 for cor(T1,T2)=1 and 0.09 for cor(T1,T2)=-1.Why are these numbers different from "daveangel"s? Where did I go wrong?Thanks again! T1 and T2 are the time series of returns or prices ? If its prices then the weight of T1 and T2 in the portfolio is T1/(T1+T2) and T2/(T1+T2)if its returns then you have an equal weights of 0.5 and you need to modify your variance formula
knowledge comes, wisdom lingers
 
User avatar
dirtdog
Topic Author
Posts: 0
Joined: November 9th, 2010, 1:18 pm

Maximum cross correlation two time series

September 6th, 2013, 4:14 pm

@daveangel, I now see the errors of my ways ;DThanks so much for your help!
 
User avatar
bearish
Posts: 5906
Joined: February 3rd, 2011, 2:19 pm

Maximum cross correlation two time series

September 7th, 2013, 1:01 am

This is an interesting case where DA may have answered the question that you meant to ask, but he certainly didn't answer the one that you did ask. But if you are happy, we are happy.
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Maximum cross correlation two time series

September 7th, 2013, 8:50 am

QuoteOriginally posted by: bearishThis is an interesting case where DA may have answered the question that you meant to ask, but he certainly didn't answer the one that you did ask. But if you are happy, we are happy.better lucky than smart
knowledge comes, wisdom lingers
 
User avatar
dirtdog
Topic Author
Posts: 0
Joined: November 9th, 2010, 1:18 pm

Maximum cross correlation two time series

September 7th, 2013, 9:23 am

Haha - this line cleared it up for me:"if its returns then you have an equal weights of 0.5 and you need to modify your variance formula".Guess I was tired when I posted the question.Thanks again