What we want to do for each of the 75 months is to divide the companies in 3 portfolios based om value weighted market to book value (30% highest, 40% mid and 30% lowest). When the portfolios are created we need to calculate the return of each portfolio.
Or main issue is to rank the companies and assign them to a portfolio without having to do it manually per month.
All help would be appreciated!
