Need help portfolio simulation

 values are the same for all data.

Yes of course as there is no change of the solver data. As I said before

what data should solver be given for each change of date in the range B38 to B59?

and as the solver input stays the same the solver result will not change.

This main reason for this macro was to show you one way of how you can make solver run in a loop.

So could you show me all macro? how it looks like?

As I do not understand the "mechanism" behind this problem I'm not capable of writing a macro that does what you wish.

Why don't you have a go at it and when you know what you wish to do but can't get the macro to work the way you wish post again in this forum.

Alf

Ps This forum now opens up a paid service where the real forum experts will solve all kinds of problems. Perhaps you should check if this service could be of use to you?