Combin worksheet function: Obtaining a listing of possible c

[johnsmithafc]

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%

 

[PaddyD]

Hi - welcome to the board!

There's no need to start new threads on the same issue! If youve got extra info that relates to your original post, simply post a reply to it.

paddy

http://216.92.17.166/board/viewtopic.php?topic=28415&forum=2