Forum Discussion
Find optimal percent
Hi all, I am trying to find an optimal percent to sell a group of ten stocks. Down below I have copied some info. The first column is the final percent change of the stocks and the second column is t...
JoeUser2004 Thank you for your suggestions. I think I figured out the problems with the $'s. The issue now, as you mentioned is that the answer becomes 0 if there is no way to sell the stocks for a gain. I would much rather the formula produce a solution that sells them for the least loss rather then 0. You mentioned that the solver approach could do this. Could you explain that further? I have never used solver before. Thanks. Attached is a copy of my worksheet.
@Joe User actually, never mind, I figured out the solver solution. Thank you so much for all the help you have given me. If there is anything I can do for you don't hesitate to ask. Thanks