Need Help with Running Percentage!!

[Gillisj]

	a	b	c	d	e
1	#of trades	total trades made	won	lost	won/lost running percentage
2	1	1	1	0
3	1	2	1	0
4	2	4	1	1
5	1	5	0	1
6	2	7	2	0
7	0	7	0	0
8	1	8	1	0

<tbody>
</tbody>

Thank you for your help first off. I am a day trader and I am trying to get my log together with all of this data.

Here is what I have so far formula wise.
Total Trades = b2+a3

What I need is a running won/lost percentage formula that omits cells where I dont trade that day for example row 7.

Any help would be much appreciated as I am totally lost on this right now

 

[circledchicken]

Hi,

Perhaps like this (although I'm not sure this is exactly what you want in column E):

Excel Workbook
	A	B	C	D	E
1	#of trades	total trades made	won	lost	won/lost running percentage
2	1	1	1	0	100%
3	1	2	1	0	100%
4	2	4	1	1	75%
5	1	5	0	1	60%
6	2	7	2	0	71%
7	0	7	0	0
8	1	8	1	0	75%
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B2	=SUM(A$2:A2)
E2	=IF(A2=0,"",SUM(C$2:C2)/B2)

 

[lrobbo314]

How about this?
=SUMIF($C$2:C2,">0",$C$2:C2)/SUMIF($C$2:D2,">0",$C$2:D2)

 

[Gillisj]

Circled Chicken Thanks for the help that worked out for me perfectly!!

 

[Gillisj]

That worked out perfectly thanks for the help

 

[circledchicken]

Circled Chicken Thanks for the help that worked out for me perfectly!!

Your welcome - thanks for the feedback.