Hello,
I am using this sheet as a supplement positions I have in certain stocks.
Lets say I am buying 50 shares of stock, and I am selling out a percentage of the 50 each day for 13 days.
Day 1 I sell 6%
Days 2 - 6 I sell 8% each day
Days 7-10 I sell 9% each day
Day 11-13 i sell 6% each day
The issue I am having is that I cannot sell 4.5 shares of a stock like the formula currently tells me to do on days 7-10. I have been going through and manually editing any days where this occurs and just making them into whole numbers manually (change 2 days to 4 shares and 2 days to 5 shares).
Is there any way to set this formula up so that it returns only whole numbers AND equals 100% of my initial starting number?
I have tried using rounding and INT formulas yet have no found one that accomplishes what I was looking for. The RoundUP/Down and TRUNC formulas always leave me without 100% of the initial number of shares.
I have included an attachment showing the current method behind it.
Thanks for any help, it is greatly appreciated.
Bookmarks