how to constrain coefficients in a multiple regression using solver
I'm looking to create a sharpe style analysis. This is done by regressing the return of one fund against mulitple benchmark returns. The coefficents of the resulting multiple regession must be positive and sum to one. I'm not sure if excel is capable of doing this which I believe is referred to as quadratic programming. Does anyone know if it is possible to do this using the solver function and if so how? I've attached a spreadsheet of the raw returns (Column B & Benchmark returns in C,D,E&F).
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1