Hey my fellow celly nerds, I'm wondering if you can help out. I need 4 simple, but related formulas.
I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would.
http://we.tl/1n6sJdBRot
It's just a wetransfer.com link, since there's no "browse" to local file option here. Thanks for looking at that image now.
OK, you'll notice there are 2 data columns. Column A5:A85 (not all data shown on the screenshot) is simply "B" for "buy" and "S" for "Sell". The gain or loss from each of those is reflected in the NEXT line, and in the "D" column (first result is always blank, so don't be alarmed there).
What I'm hoping for would be 4 Formulas to Calculate the total Wins & total Losses for both Buys and Sales.
You'll see further down that screenshot, that the 2x2 table is located at O15 thru Q17
So, basically it goes like this:
You see in A1 that the first trade is a "B"uy, that results in a 1.25 loss, ie -1.25.
The next trade in A2 is a "S"ell that results in a 0.5 loss, it -0.5
etc
etc
There are 2 instances (in this example) of "SL&R" which is just an internal label. So hopefully you're asking, "but there's no SL&R header in your 2x2 table. How do you want us to treat those, as B or S? The answer is this: It's whatever the cell immediately above it is.
So, if A11 reads "SL&R", then because the cell above it is a "Sell" trade, you'll treat the SL&R trade result (-1.5 found in D12) as a "S"ell. It just so happens both instances in this screenshot I've shared are "S". We don't just call them sales because they represent additional information that's important internally.
In summary, I'm simply needing 4 formulas that will go into P16, Q16, P17, Q17.
Thanks and if you have any questions I'll do my best to answer them.
Kind regards.
I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would.
http://we.tl/1n6sJdBRot
It's just a wetransfer.com link, since there's no "browse" to local file option here. Thanks for looking at that image now.
OK, you'll notice there are 2 data columns. Column A5:A85 (not all data shown on the screenshot) is simply "B" for "buy" and "S" for "Sell". The gain or loss from each of those is reflected in the NEXT line, and in the "D" column (first result is always blank, so don't be alarmed there).
What I'm hoping for would be 4 Formulas to Calculate the total Wins & total Losses for both Buys and Sales.
You'll see further down that screenshot, that the 2x2 table is located at O15 thru Q17
So, basically it goes like this:
You see in A1 that the first trade is a "B"uy, that results in a 1.25 loss, ie -1.25.
The next trade in A2 is a "S"ell that results in a 0.5 loss, it -0.5
etc
etc
There are 2 instances (in this example) of "SL&R" which is just an internal label. So hopefully you're asking, "but there's no SL&R header in your 2x2 table. How do you want us to treat those, as B or S? The answer is this: It's whatever the cell immediately above it is.
So, if A11 reads "SL&R", then because the cell above it is a "Sell" trade, you'll treat the SL&R trade result (-1.5 found in D12) as a "S"ell. It just so happens both instances in this screenshot I've shared are "S". We don't just call them sales because they represent additional information that's important internally.
In summary, I'm simply needing 4 formulas that will go into P16, Q16, P17, Q17.
Thanks and if you have any questions I'll do my best to answer them.
Kind regards.
