#1
|
|||
|
|||
Finding the optimal percent to sell stocks in excel
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 |
#2
|
||||
|
||||
Do the dashes denote negative percentage change? Like, the prices of the stocks went down?
|
#3
|
|||
|
|||
Yes they do
|
#4
|
|||
|
|||
Please add a workbook with all the field and an example of what you are trying to achieve
|
#5
|
|||
|
|||
I figured out a solution, thank you for your help.
|
#6
|
||||
|
||||
That's great Noa. It would be better that you show your solution here so the other members or visitors may learn and get an idea from it.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding a word in Excel problem | PomDave | Excel | 2 | 10-08-2020 04:23 PM |
Finding the optimal value in a set of data | Notryonlydo | Excel Programming | 5 | 08-30-2017 10:55 AM |
Automatically have Percent Complete filled by Excel data | robbinskelly7 | Project | 1 | 02-10-2015 03:14 PM |
Generating Buy/Sell signals accordingly... | babapusy | Excel | 0 | 04-14-2012 10:11 AM |
Excel Not Finding the Median | BrazzellMarketing | Excel | 4 | 02-17-2012 02:20 PM |