Excel Formula - Count or Sum All Positive or Negative Numbers in a Row or Column
As mentioned in Pro Stock Trading Tips #1, it is essential for the trader to let gains run and cut losses.
One way of tracking whether or not you are doing this is by actually looking at your trading results. If you track your results in excel, there are simple formulas you can employ to count the number of winners or losers you have and how much the total of your winners or losers is.
Counting number of positive or negative numbers use:
a) Number of all positive numbers
b) Number of negative numbers
Replace D5:D20 with your actual data set.
Summing all the positive or negative numbers separately use:
a) Sum of all positive numbers
b) Sum of negative numbers
Again, replace D5:D20 with your actual data set.