NexusFi: Find Your Edge


Home Menu

 





Monte Carlo Worksheet - Predict Worst Case Drawdown


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one SidewalkAerobics with 5 posts (1 thanks)
    2. looks_two xplorer with 4 posts (3 thanks)
    3. looks_3 ssp729 with 2 posts (1 thanks)
    4. looks_4 propdesk with 2 posts (0 thanks)
      Best Posters
    1. looks_one matthew28 with 2 thanks per post
    2. looks_two kevinkdog with 1 thanks per post
    3. looks_3 xplorer with 0.8 thanks per post
    4. looks_4 SidewalkAerobics with 0.2 thanks per post
    1. trending_up 4,520 views
    2. thumb_up 9 thanks given
    3. group 5 followers
    1. forum 14 posts
    2. attach_file 0 attachments




 
Search this Thread
  #11 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 6,372 since Sep 2015
Thanks Given: 16,076
Thanks Received: 16,266

@kevinkdog

Hi Kevin,

A post by @Symple today reminded me I wanted to ask:

I have used it your Montecarlo analysis for years (freemc) and I find it an excellent aid to my trading decisions.


Recently I noticed you added an upgraded version (KJTradingSystems-MCandPC) which somehow I can't get to work.


I tried using it in the same way I use the prior one - Copied and pasted the trades, adjusted start equity, ruin point and # of trades and clicked 'Calculate!'.

The prior version (freemc) takes under 3 mins to run.

The newer version (KJTradingSystems-MCandPC) seems to keep going indefinitely - I think once I let it run for over 3 hours. Eventually I stopped it manually.


Same machine, same parameters, same inputs.

Any ideas, i.e. am I missing anything obvious?

Thanks


Reply With Quote
  #12 (permalink)
propdesk
Los Angeles, CA
 
Posts: 8 since Nov 2026
Thanks Given: 0
Thanks Received: 0

For anyone landing here now with a prop evaluation, the simple version of this question has helped me most: how many losers in a row can I take before the account is done?

Quick example. If your max loss is $2,000 and you risk $200 a trade, that's 10 straight losers. Sounds like plenty. But with a coin-flip win rate over 150 trades, a streak of about 7 is normal, and roughly 1 time in 15 you'll hit 10 or more. So $200 a trade on that account is closer to the edge than it feels.

Two prop rules change the math:
- If the drawdown trails, a good run moves the line up too, so your real room after winning is smaller than where you started.
- A daily loss limit stops a bad day before the whole streak can play out. That saves the account, but it can also cut off the recovery your edge needs.

Steven


Reply With Quote
  #13 (permalink)
 kevinkdog   is a Vendor
 
Posts: 3,746 since Jul 2012
Thanks Given: 1,920
Thanks Received: 7,497


xplorer View Post
@kevinkdog

Hi Kevin,

A post by @Symple today reminded me I wanted to ask:

I have used it your Montecarlo analysis for years (freemc) and I find it an excellent aid to my trading decisions.


Recently I noticed you added an upgraded version (KJTradingSystems-MCandPC) which somehow I can't get to work.


I tried using it in the same way I use the prior one - Copied and pasted the trades, adjusted start equity, ruin point and # of trades and clicked 'Calculate!'.

The prior version (freemc) takes under 3 mins to run.

The newer version (KJTradingSystems-MCandPC) seems to keep going indefinitely - I think once I let it run for over 3 hours. Eventually I stopped it manually.


Same machine, same parameters, same inputs.

Any ideas, i.e. am I missing anything obvious?

Thanks

Sorry, just saw this, feel free to email me details. It might be an Excel conversion issue.


Follow me on X Reply With Quote
Thanked by:
  #14 (permalink)
 kevinkdog   is a Vendor
 
Posts: 3,746 since Jul 2012
Thanks Given: 1,920
Thanks Received: 7,497


propdesk View Post
For anyone landing here now with a prop evaluation, the simple version of this question has helped me most: how many losers in a row can I take before the account is done?

Quick example. If your max loss is $2,000 and you risk $200 a trade, that's 10 straight losers. Sounds like plenty. But with a coin-flip win rate over 150 trades, a streak of about 7 is normal, and roughly 1 time in 15 you'll hit 10 or more. So $200 a trade on that account is closer to the edge than it feels.

Two prop rules change the math:
- If the drawdown trails, a good run moves the line up too, so your real room after winning is smaller than where you started.
- A daily loss limit stops a bad day before the whole streak can play out. That saves the account, but it can also cut off the recovery your edge needs.

Steven

But what about losers not in a row? Instead of 10 consec losers, you get 5 losers, 2 winners, then 4 losers, 1 winner, etc? You need to know when that type situation will kill you, not just consec losers.


Follow me on X Reply With Quote
Thanked by:
  #15 (permalink)
propdesk
Los Angeles, CA
 
Posts: 8 since Nov 2026
Thanks Given: 0
Thanks Received: 0

Fair point, and you're right. The streak is just the easy version to explain to someone new. What actually ends an account is the deepest dip from your high point, and that usually looks like your example: 5 losers, 2 winners, 4 more losers. No single streak looks scary, but the hole adds up.

That's really the case for running the full Monte Carlo instead of counting streaks. It shuffles the real sequence of wins and losses, so those choppy stretches show up on their own. On a prop account I'd take the worst drawdown it shows and compare it to the max loss, not the longest losing streak.

Thanks for putting the worksheet out there for free, by the way.

Steven


Reply With Quote




Last Updated on November 16, 2026


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts