I was super interested about your post and wanted to recreate it. While doing so there might be an error (or I might not be understanding). For step 3, using this formula =(1-$B$2)^C$3 for C5 and then using the longer one for the 1st column makes sense but wouldn't you need to do the same thing for each of the columns. So for example for 4 trades, with 4 consecutive losses it would be (1-WR)^4. Because I am not getting the same numbers as you.
Hey, thanks for your comment, and sorry about the slow reply - you caught me just as I am taking a short holiday.
Yes, you are correct - I did make the mistake as you said, and many thanks for pointing it out! I have now corrected the screenshots and step 3 of this stack :)
As soon as I get a chance, I'll also go through my other stacks that include screenshots of the calculator and correct them.
Glad it helped! Would love to hear how you get on with your own calculator, especially if you find new uses for it. As I always say, I'm here to learn too :)
Hey there,
I was super interested about your post and wanted to recreate it. While doing so there might be an error (or I might not be understanding). For step 3, using this formula =(1-$B$2)^C$3 for C5 and then using the longer one for the 1st column makes sense but wouldn't you need to do the same thing for each of the columns. So for example for 4 trades, with 4 consecutive losses it would be (1-WR)^4. Because I am not getting the same numbers as you.
Thanks :)
Hey, thanks for your comment, and sorry about the slow reply - you caught me just as I am taking a short holiday.
Yes, you are correct - I did make the mistake as you said, and many thanks for pointing it out! I have now corrected the screenshots and step 3 of this stack :)
As soon as I get a chance, I'll also go through my other stacks that include screenshots of the calculator and correct them.
Thanks again!
Not a problem! Thanks for replying! Appreciate it :)
To be honest, your post inspired me to write a blog series about losing streaks: https://retailtradersrepository.substack.com/p/series2-a-understanding-losing-streaks
If you ever want to collab on a piece I am always interested in new ideas.
Thanks :)
Glad to hear you found it useful! And I'll bear it in mind :)
Wasn’t expecting such wonderful reply! Much appreciated on sharing this 💎
Glad it helped! Would love to hear how you get on with your own calculator, especially if you find new uses for it. As I always say, I'm here to learn too :)