Sum consecutive losses and equity Drawdown

[Trie1977]

Hi,

Can I get some help with the formula?
Thank anyways!

ConsDD.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1				Sum of consecutive losses per combi (symbol&strategy), Reset/Start from 0 after a winner. Formula checks back in history		Actual Drawdown in Equity per combi (symbol&strategy). Formula checks back in history
2
3	Symbol	Strategy	Date	Formula Sum of consecutive losses	Expected Sum of consecutive losses	Formula Equity Drawdown	Expected Equity Drawdown	NetProfit
4	NZDJPY	Strategy 1	22-jan		-61		-61	-52
5	CADJPY	Strategy 1	21-jan		0		0	93
6	NZDJPY	Strategy 1	20-jan		-9		-9	-9
7	AUDJPY	Strategy 1	19-jan		0		-73	60		TRUE	(-133+60=-73)
8	NZDJPY	Strategy 1	18-jan		0		0	71		2 losses in a row
9	CADJPY	Strategy 1	17-jan		0		-2	60
10	NZDJPY	Strategy 1	16-jan		-70		-70	-70
11	AUDJPY	Strategy 1	15-jan		-133		-133	-70
12	NZDJPY	Strategy 1	14-jan		0		0	63
13	CADJPY	Strategy 1	13-jan		-62		-62	-62
14	NZDJPY	Strategy 2	12-jan		-26		-26	-26		first loss stratgey 2
15	AUDJPY	Strategy 2	11-jan		-63		-63	-63		2 losses in a row
16	NZDJPY	Strategy 2	10-jan		0		0	88
17	CADJPY	Strategy 2	9-jan		0		0	77
18	NZDJPY	Strategy 3	8-jan		0		0	82
19	AUDJPY	Strategy 3	7-jan		0		0	0
20	NZDJPY	Strategy 2	6-jan		0		0	87
21	AUDJPY	Strategy 2	5-jan		-31		-31	-31
22	NZDJPY	Strategy 2	4-jan		0		0	47
23	CADJPY	Strategy 2	3-jan		0		0	22
24	NZDJPY	Strategy 3	2-jan		-51		-51	-51
25	AUDJPY	Strategy 3	1-jan		0		0	85		0 because not a loss
26
Sheet1

Cell Formulas
Range	Formula
J7	J7	=-133+60=-73

 

[Trie1977]

Anyone please? Maybe only focus on Equity Drawdown. I still fail whatever I try. If the solution lies in Power Query, I will take it.