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 3 posts (3 thanks)
    3. looks_3 ssp729 with 2 posts (1 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
      Best Posters
    1. looks_one matthew28 with 2 thanks per post
    2. looks_two xplorer with 1 thanks per post
    3. looks_3 ssp729 with 0.5 thanks per post
    4. looks_4 SidewalkAerobics with 0.2 thanks per post
    1. trending_up 2,158 views
    2. thumb_up 7 thanks given
    3. group 3 followers
    1. forum 9 posts
    2. attach_file 0 attachments




 
Search this Thread

Monte Carlo Worksheet - Predict Worst Case Drawdown

  #1 (permalink)
 SidewalkAerobics 
Los Angels
 
Experience: Intermediate
Platform: MultiChart
Trading: Emini ES
Posts: 115 since Aug 2018
Thanks Given: 173
Thanks Received: 71

Does anyone have a worksheet to predict worst case drawdown using Monet Carlo analysis?

For example, a system that trades 150 times per year, profits $19,000 per year with $7,000 drop down would require $X of capital for margin.

Monte Carlo Analysis will predict how much capital is needed to avoid a margin call.

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
REcommedations for programming help
Sierra Chart
MC PL editor upgrade
MultiCharts
Better Renko Gaps
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
43 thanks
Just another trading journal: PA, Wyckoff & Trends
30 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
21 thanks
  #3 (permalink)
 SidewalkAerobics 
Los Angels
 
Experience: Intermediate
Platform: MultiChart
Trading: Emini ES
Posts: 115 since Aug 2018
Thanks Given: 173
Thanks Received: 71




Thank you for the links. Do you know of a free Excel spreadsheet that would do the job?

Started this thread Reply With Quote
  #4 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,973 since Sep 2015
Thanks Given: 15,494
Thanks Received: 15,387


SidewalkAerobics View Post
Thank you for the links. Do you know of a free Excel spreadsheet that would do the job?

Yes, check in the webinar section and look for "monte carlo". You will find a great webinar by Kevin Davey on the subject, with also links to his own free spreadsheet.

Reply With Quote
Thanked by:
  #5 (permalink)
 
matthew28's Avatar
 matthew28 
United Kingdom
Elite_Member
 
Experience: Beginner
Platform: Bookmap
Broker: Stage 5, Rithmic
Trading: US Equity Index Futures
Posts: 1,250 since Sep 2013
Thanks Given: 3,500
Thanks Received: 2,532


SidewalkAerobics View Post
Do you know of a free Excel spreadsheet that would do the job?



Probably worth watching the webinar as you are interested. In his screen notes he gives the link for the Excel sheet he is using.

You do not win as a trader, you just get to play again the next day. If that game doesn’t appeal to you then you should not trade. Gary Norden
Reply With Quote
Thanked by:
  #6 (permalink)
 SidewalkAerobics 
Los Angels
 
Experience: Intermediate
Platform: MultiChart
Trading: Emini ES
Posts: 115 since Aug 2018
Thanks Given: 173
Thanks Received: 71


xplorer View Post
Yes, check in the webinar section and look for "monte carlo". You will find a great webinar by Kevin Davey on the subject, with also links to his own free spreadsheet.

Thanks! I watched the Kevin Davey video (good video) and he said to email him for the worksheet.

Email to [email protected] bounced.

Does Kevin Davey have a new email?

Started this thread Reply With Quote
Thanked by:
  #7 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,973 since Sep 2015
Thanks Given: 15,494
Thanks Received: 15,387


SidewalkAerobics View Post
Thanks! I watched the Kevin Davey video (good video) and he said to email him for the worksheet.

Email to [email protected] bounced.

Does Kevin Davey have a new email?

Kevin has a handle here at FIO and is active virtually every day.


This will alert him to your request: @kevinkdog

Reply With Quote
Thanked by:
  #8 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,973 since Sep 2015
Thanks Given: 15,494
Thanks Received: 15,387


SidewalkAerobics View Post
Thanks! I watched the Kevin Davey video (good video) and he said to email him for the worksheet.

Email to kdavey@ tradingsystems.com bounced.

Does Kevin Davey have a new email?

Also, the email address you used is incorrect - the domain should read kjtradingsystems.com.

Reply With Quote
Thanked by:
  #9 (permalink)
 SidewalkAerobics 
Los Angels
 
Experience: Intermediate
Platform: MultiChart
Trading: Emini ES
Posts: 115 since Aug 2018
Thanks Given: 173
Thanks Received: 71


xplorer View Post
Also, the email address you used is incorrect - the domain should read kjtradingsystems.com.

I appreciate your help.

Thank you for the domain correction.

Started this thread Reply With Quote
  #10 (permalink)
 SidewalkAerobics 
Los Angels
 
Experience: Intermediate
Platform: MultiChart
Trading: Emini ES
Posts: 115 since Aug 2018
Thanks Given: 173
Thanks Received: 71



ssp729 View Post
Hi *SidewalkAerobics. Have you manage to use Monte Carlo?

Yes, I used the Monte Carlo worksheet. Thanks to Kevin for the free worksheet.

My risk tolerance is less than the Monte Carlo predicted. So, following the advice of an old trader, I created my own worksheet to test draw downs after:
  • 10 consecutive losses
  • Every other trade as a loss (for 30 trades)
  • 2 out of three trade losses (for 30 trades)
The conclusion that I reached was much more conservative than the Monte Carlo.

Because I trade multiple contracts, I can find a scale back ratio that will bring me to down to a low enough number of contracts that the margin can survive a worst-worst case scenario and still have a remainder to continue trading.

In hind sight I don't think I would execute the last trade in any of the scenarios above.

Started this thread Reply With Quote




Last Updated on February 26, 2019


© 2024 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 - Privacy Policy - Downloads - Top
no new posts