Hey guys, I'm trying to do something really basic for a spreadsheet I'm making for working with stocks. Basically it's aim is to calculate net profits/loss on a stock depending on different sell prices. Here's how it works:
1) Number of shares = X
2) Purchase price (cost per share) = Y
3) Sell price (cost per share) = Z
4) Sell price increment (ex: sell price of $10.00, increment of $0.10) = N
5) Commission fee = {[(X*Y)+(Y*Z)]}*0.005+14
The calculation should look something like this:
X*Z - X*(Y+N) - commission fee = net profit/loss
So here's what I need to do and what I'm having trouble accomplishing. I need the results to come out on multiple rows with each row incrementing by the price increment N. So if someone enters $0.10 then the first row displays the profit/loss *without* the increment, the second row would take into account N*1, the second N*2, the third N*3, etc.
Here's the equation I have so far (as it appears in Excel), although it isn't working:
A=number of shares, B=purchase price, C=sell price, D=price increment. E2 should display the value of C while E3 and beyond is the value of C plus D's incrementally increasing value.
Help!
Thanks everyone!
Bookmarks