johnsmithafc
New Member
- Joined
- Nov 6, 2002
- Messages
- 6
I have a portfolio of five assets A,B,C,D and E and I want to make a combination of weights in any or all of the assets such that the sum total of the weights will equal 100%. Assuming the possible combination of weights I can make for each asset are 0%,10%,20%,30%,40%,50%,60%,70%,80%,90% or 100% how can I get the listing of possible combination of weights in assets A,B,C,D and E.
Using the Combine function of excel =Combin(11,5) I get 462 possible combinations, but what I need is the syntax to enable me obtain all possible combination in % terms as shown .
An example of the result I expect is shown below:
A B C D E Total
10% 20% 30% 0% 40% 100%
20% 10% 0% 10% 60% 100%
40% 10% 10% 10% 30% 100%
Using the Combine function of excel =Combin(11,5) I get 462 possible combinations, but what I need is the syntax to enable me obtain all possible combination in % terms as shown .
An example of the result I expect is shown below:
A B C D E Total
10% 20% 30% 0% 40% 100%
20% 10% 0% 10% 60% 100%
40% 10% 10% 10% 30% 100%