How to calculate probability of losing x trades in a row in 50 days.

[VBA KILLER]

Hi all, so im trying to make a excel spreadsheet to calculate the highest percentage of losses in a row.

somewhat like this

The only thing is that I want to have loss percentage and i want to be able to start at 1 percent rather than 5

 

[mrshl9898]

Try =1-POWER($A3,B$2)

Eg 40% win *40% = 16% chance win so 84% chance loss.

I see the maths there is quite different though, hard to think why that would be.