Need Help with Running Percentage!!

[Gillisj]

[TABLE="class: grid, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]#of trades[/TD]
[TD]total trades made[/TD]
[TD]won[/TD]
[TD]lost[/TD]
[TD]won/lost running percentage[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



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.