Excel Allocaton problem

[sonalib]

Hi I am trying to solve a allocation problem and need help understanding how to proceed.
Problem Definition:
I have a fund of USD 1000 (this fund will change as needed and will be a user input)
I also have 4 categories for stocks in my portfolio (a,b,c,d) where a>b>c>d respectively. I will be assigning a category to each stock as per my choice. Each category will represent a % of the stock price. Therefore the fund allocated to each stock will be dependent on the stock price since all stocks belonging to the same category will receive same % share but different value (%*stock price)

I have about 50 stocks

Now I want to allocate the fund fully to all the stocks.

I do not want to use macros. can this problem be solved using formulas. I can already solve it recurrsively but I want to build a model which can solve without me running a hit and trial for each change in input values.

Can anyone help?

 

[wsjackman]

Please explain again with some examples of what you want to do.
I am not able to visualize what you need?

 

[sonalib]

OK. Here is the crux of the problem as I see it. I need a solution to this mathematical problem in Excel.

x1*A%+x2*B%+x3*C%+x4*D%=Z

where A>B>C>D>=0
x1,x2,x3,x4 >0
Z>0

 

[sonalib]

Solve for A,B,C,D.

 

[wsjackman]

can you give numerical examples for the variables?

I still can't visualize what you are doing and have several confusing alternate definitions of the variables you are trying to solve in the equation.

how do you solve it recursively?