I'm stuck at something, and I'd really appreciate if someone could help me out of this.

So, it's a betting problem. If win rate is 90% - from an online calculator available I calculated odds of 6 losses happening in a row in 1,000 occurrences is 0.090%. (The online calculator might be unreliable, so please feel free to correct me if the math is wrong)

But the calculator says nothing about wins & losses showing up randomly one after another. Say there're 5 losses in a row, then a win, then another 4 losses, followed by 2 wins, then another 5 losses, and so on.

I want to know the probabilities of such different instances showing up with both wins & losses mixed up. An idea about the

*grey area of betting*.

So that I'll have a better idea of suited starting bankroll. I'm much more concerned about losing streaks showing up suddenly & frequently in between the wins - so in a sense, it's a bit like preparation for the worst case scenarios.

And if there's some

*excel spreadsheet or calculator*anyone knows of where I can calculate about such different scenarios, and point me toward it - that'd be really helpful.

Thank you for taking the time to read through my lengthy post, and also thank you in advance for any kind of suggestion/solution/tip you can give me on this.

Have a lovely day!