return calculation
Posted: Sun Jul 01, 2018 6:36 am
Hi there,
I have monthly return data(as attached), and i need to calculate
1. buy-and-hold return over Jan(t) to June(t) where t is the portfolio formation year t >> BHRET6_it=[(1+r)_(i,1))*…*(1+r_(i,6) )]-1
2. the 36 months buy-and-hole return over July(t-3) to June(t)
And, the R1 order need as same as RetM_F file(see picture below)
I'm working with my thesis, and really need helps, thank you so so so much!!!
I have monthly return data(as attached), and i need to calculate
1. buy-and-hold return over Jan(t) to June(t) where t is the portfolio formation year t >> BHRET6_it=[(1+r)_(i,1))*…*(1+r_(i,6) )]-1
2. the 36 months buy-and-hole return over July(t-3) to June(t)
And, the R1 order need as same as RetM_F file(see picture below)
I'm working with my thesis, and really need helps, thank you so so so much!!!