Win Percentage and Expectancy example, Excel equity curve graph with Monte Carlo - Psychology and Money Management | futures io social day trading
futures io futures trading


Win Percentage and Expectancy example, Excel equity curve graph with Monte Carlo
Updated: Views / Replies:6,789 / 17
Created: by Big Mike Attachments:4

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 4  
 
Thread Tools Search this Thread
 

Win Percentage and Expectancy example, Excel equity curve graph with Monte Carlo

  #1 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,240 since Jun 2009
Thanks: 29,352 given, 83,231 received

Win Percentage and Expectancy example, Excel equity curve graph with Monte Carlo

Hi guys,

I have a request for the math and Excel guys please. I would like to have an Excel spreadsheet put together that can easily graph an equity curve over a period of trades, and the inputs would allow for examining different trading scenarios based on win percentage vs risk. The monte carlo aspect would show us the variation from run to run.

We all know that high win rates appeal to the majority of traders, but unfortunately most of these traders stop right there and focus solely on win percentage without considering the risk per trade (R-multiple, or win/loss dollar).

That said, there can be some statistical advantages to higher win rate systems when using compounded position sizing.

What I would like to do is have an Excel spreadsheet that quickly demonstrates this. I believe the inputs would simply be:

1) Number of trades [and use monte carlo simulations on top of this], I am thinking 1,000 is a nice number.
2) Win percentage, ie 60%.
3) Amount risked per trade, ie $150.00 = 1R
4) Profit target per trade, ie $200.00 = 1.33R
5) Per trade expenses, ie commission and slippage say $4.00 + $12.50 = $16.50 per round turn.

Each trade will either win or lose.

In my head, what I picture is the monte carlo giving us the ability to see how different cycles of the trade run/path will result in different end results or products, or equity curves.

In addition to the equity curve plot distribution over the trades, we should have a simple end result graph as well that shows us our maximum drawdown as well as our high-water mark, and our total expectancy.

What I wanted was for someone to be able to quickly punch in different scenarios for win percentage and see how it can change the outcomes.

I hope I am not asking too much?

Any takers? I am going to mention @vvhg only because he is the best Excel guy I know, but there are many of you guys on the forum, so I hope I can ask this favor for you guys to come together and make this.

Thx.

Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following 2 users say Thank You to Big Mike for this post:
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


I found this with a quick search: Risk of Ruin

But I guess it's not exactly what you mean. What should be reasonably easy is to hook that up with the Monte Carlo engine in the journal. So this generates the "original" trades and the engine from the journal makes the iterations and graphs...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #4 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received

Here is a quick and dirty version.

On Sheet1 fill out the red cells, hit recalc. Then switch over to the Monte Carlo tab, functionality of it is unchanged.
Please be aware that the trades are calculated as percentage of account balance (account balance can be changed in cell C3).

The file is rather large as I didn't bother to delete all the other tabs of the journal (would require lots of fiddling with the VB code behind the scenes). They are still there as I only hid them, if this causes any problems, give me a shout...

vvhg

P.S.

Big Mike View Post
Any takers? I am going to mention @vvhg only because he is the best Excel guy I know, but there are many of you guys on the forum, so I hope I can ask this favor for you guys to come together and make this.

I'm sorry that I have to correct you, I'm not that good with Excel at all. I'm just really good with Google and copy/paste

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Monte Carlo standalone2.rar (1.77 MB, 176 views)

Last edited by vvhg; October 7th, 2012 at 10:11 AM.
Reply With Quote
The following 6 users say Thank You to vvhg for this post:
 
  #5 (permalink)
Trading Apprentice
France
 
Futures Experience: Intermediate
Platform: Metastock
Favorite Futures: ES, EC, QM, GLD, SPY, QQQ
 
Posts: 32 since May 2012
Thanks: 5 given, 15 received


Big Mike View Post
We all know that high win rates appeal to the majority of traders, but unfortunately most of these traders stop right there and focus solely on win percentage without considering the risk per trade (R-multiple, or win/loss dollar).

Mike you may want to take a look at this simulator from the web archives (not available on the website any longer):

Random Equity Curve Simulator of a trading system. Learn it before you trade

I think it does what you are looking for.

Also, check out Michael Harris' work:

The Most Important Performance Measure of Trading Strategies | Price Action Lab Blog

Reply With Quote
The following 2 users say Thank You to dryg for this post:
 
  #6 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,240 since Jun 2009
Thanks: 29,352 given, 83,231 received


vvhg View Post
Here is a quick and dirty version.

Excellent @vvhg, it looks to have most of what I was wanting. I will spend some time with it.

Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following user says Thank You to Big Mike for this post:
 
  #7 (permalink)
Site Administrator
Manta, Ecuador
 
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
 
Big Mike's Avatar
 
Posts: 46,240 since Jun 2009
Thanks: 29,352 given, 83,231 received

@vvhg,

Here is an example:

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


In this example, there were 21 consecutive losers in a string of trades. How can I get a graph that shows me this in some sort of distribution so I know that there is a 90% chance of a certain figure, for example? And 80% chance of a different value, 70% chance, etc.

Also an example of what I was speaking to earlier in post 1 --- but here is a 50% win rate system, with 12 losers in a row. How many traders would take all 12 of those losing trades without starting to wonder if their system was broken... the exact reason behind analysis of this nature.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Mike

Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
6)
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following user says Thank You to Big Mike for this post:
 
  #8 (permalink)
Elite Member
Quebec
 
Futures Experience: Intermediate
Platform: NinjaTrader wt Rancho Dinero's profiling tools
Broker/Data: Stage 5 trading/AMP/CQG
Favorite Futures: ES, NQ, YM
 
trendisyourfriend's Avatar
 
Posts: 3,697 since Oct 2009
Thanks: 3,041 given, 4,496 received

Why don't you go at RANDOM.ORG - True Random Number Service and request a series of 1,0 etc. in the % that interests you to evaluate the max. number of consecutive 0 or 1 you can get? This way you'll be able to test different drawdown in terms of % very quickly.

Reply With Quote
The following user says Thank You to trendisyourfriend for this post:
 
  #9 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


Big Mike View Post
@vvhg,

Here is an example:

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


In this example, there were 21 consecutive losers in a string of trades. How can I get a graph that shows me this in some sort of distribution so I know that there is a 90% chance of a certain figure, for example? And 80% chance of a different value, 70% chance, etc.

Also an example of what I was speaking to earlier in post 1 --- but here is a 50% win rate system, with 12 losers in a row. How many traders would take all 12 of those losing trades without starting to wonder if their system was broken... the exact reason behind analysis of this nature.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


Mike

Well, that is a relatively simple probability question...
There is a thread about coin toss, I think there was also a formula in that thread for an unfair coin toss. I'm not at my computer, but I'll have a look in a few hours...if @Fat Tails has not pulled the formula out of his hat by then...

In the real world max draw down would probably be more important than string probabilities. These are easier to simulate, hence the Monte Carlo engine. The lower right graph shows the drawdown probabilities over the selected number of trades.(i think it's that one, but its named draw down so it's not hard to find.

As to how many traders would take the 12 losers without flinching, it is much more complicated to calculate, but the answer is 42

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 3 users say Thank You to vvhg for this post:
 
  #10 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 received


I have found the formula for it, but I haven't implemented it yet.


N being the number of trades.
K being the number of consecutive losses
p being the probability of a loss on any single trade

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:

Reply



futures io > > > Win Percentage and Expectancy example, Excel equity curve graph with Monte Carlo

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
monte carlo simulation interpretation help needed wallsteetking NinjaTrader Programming 2 October 21st, 2011 07:36 AM
Ninja Trader Monte Carlo Xeno NinjaTrader 8 April 12th, 2011 12:10 PM
Check out this equity curve! MXASJ NinjaTrader Programming 5 May 29th, 2010 02:09 PM
Monte Carlo Simulation Big Mike Psychology and Money Management 3 February 7th, 2010 12:06 PM
NinjaTrader 7 to include Monte Carlo Simulator Big Mike Traders Hideout 1 June 14th, 2009 02:41 AM


All times are GMT -4. The time now is 11:33 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts
Page generated 2017-12-14 in 0.15 seconds with 20 queries on phoenix via your IP 54.227.51.103