Formulas for trading analysis needed

[fxmasterind]

Dear community,

I have a few formulas that I cannot solve on my own and would need your help. Attached a picture

Winrate: I would need to calculate M7 - M120 (all positive and negative values) to find out the winrate.

Average win: I believe I need to use a formula average or average if select M7:M120 and then put a criteria ;">0".

Average loss: Vice versa to average win

Winning streak: Should calculate the winning trades in a row based on the Profit /Loss in M

Loosing streak: Same but only the loosing streak in a row

Looking forward to hear from you and thank you for your help.

Thank you.

Best,
fxmasterind

 

[fxmasterind]

Winrate solved so far.
=COUNTIF(M7:M106;">0")/COUNT(M7:M106)

 

[fxmasterind]

For Winning strreak I tried the following but it is not working

=MAX(FREQUENCY(IF(M7:M130;">0";ROW(M7:M130));IF(M7:M130;"<=0";ROW(M7:M130))))

 

[Fluff]

You can use the Averageif function for the two averages.

 

[fxmasterind]

You can use the Averageif function for the two averages.

Hi @Fluff, thanks solved that with:

=AVERAGEIF(L7:L130;">=0")
and
==AVERAGEIF(L7:L130;"<=0")

Any Idea what I can do on the winning and loosing streak formula?

The winning streak formula is: =MAX(FREQUENCY(IF(M7:M130;">0";ROW(M7:M130));IF(M7:M130;"<=0";ROW(M7:M130))))

But something is wrong...

 

[fxmasterind]

Hi there,

Can someone help me on the formula for the winning and loosing streak. I did the following:

The winning streak formula is: =MAX(FREQUENCY(IF(M7:M130;">0";ROW(M7:M130));IF(M7:M130;"<=0";ROW(M7:M130))))

But something is wrong...

Thanks a lot

 

[Fluff]

It should be

=MAX(FREQUENCY(IF(M7:M130>0;ROW(M7:M130));IF(M7:M130<=0;ROW(M7:M130))))

 

[fxmasterind]

Thanks this is solved!

 

[Fluff]

You're welcome & thanks for the feedback.