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 the highest percent change the stock gets to. I want a command that will find the best percent to sell all the stocks, (one percent for all of them not an optimal percent per stock). Basically, if the percent is higher than the second column it will sell at the first column level, while if the percent is lower than the second column it will sell at the percent chosen. Can anyone help come up with a formula for this?

Thanks,

Noah



-32.1786 3.571429
-19.6597 18.17108
-7.08861 1.012658
-43.6093 6.104159
-10.3846 7.692308
-29.375 15.625


-32.008 2.584493
-11.6512 17.86991
-20.9756 5.853659
8.888889 1.851852