Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2021, 12:13 PM
NoaHomeRun NoaHomeRun is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Novice
Finding the optimal percent to sell stocks in excel
 
Join Date: Sep 2021
Posts: 3
NoaHomeRun is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-25-2021, 06:56 PM
Marcia's Avatar
Marcia Marcia is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 428
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Do the dashes denote negative percentage change? Like, the prices of the stocks went down?
Reply With Quote
  #3  
Old 09-25-2021, 07:01 PM
NoaHomeRun NoaHomeRun is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Novice
Finding the optimal percent to sell stocks in excel
 
Join Date: Sep 2021
Posts: 3
NoaHomeRun is on a distinguished road
Default

Quote:
Originally Posted by Marcia View Post
Do the dashes denote negative percentage change? Like, the prices of the stocks went down?
Yes they do
Reply With Quote
  #4  
Old 09-25-2021, 11:28 PM
Purfleet Purfleet is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please add a workbook with all the field and an example of what you are trying to achieve
Reply With Quote
  #5  
Old 09-26-2021, 10:26 AM
NoaHomeRun NoaHomeRun is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Novice
Finding the optimal percent to sell stocks in excel
 
Join Date: Sep 2021
Posts: 3
NoaHomeRun is on a distinguished road
Default

I figured out a solution, thank you for your help.
Reply With Quote
  #6  
Old 09-26-2021, 03:25 PM
Marcia's Avatar
Marcia Marcia is offline Finding the optimal percent to sell stocks in excel Windows 10 Finding the optimal percent to sell stocks in excel Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 428
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by NoaHomeRun View Post
I figured out a solution, thank you for your help.
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the optimal percent to sell stocks in excel 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
Finding the optimal percent to sell stocks in excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft