NexusFi: Find Your Edge


Home Menu

 





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


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 5 posts (13 thanks)
    2. looks_two Big Mike with 4 posts (5 thanks)
    3. looks_3 trendisyourfriend with 1 posts (1 thanks)
    4. looks_4 geott with 1 posts (1 thanks)
      Best Posters
    1. looks_one vvhg with 2.6 thanks per post
    2. looks_two dryg with 2 thanks per post
    3. looks_3 Big Mike with 1.3 thanks per post
    4. looks_4 geott with 1 thanks per post
    1. trending_up 14,497 views
    2. thumb_up 25 thanks given
    3. group 15 followers
    1. forum 17 posts
    2. attach_file 4 attachments




 
Search this Thread

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

  #11 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824

After having tried the above formula, it doesn't seem to produce correct results. So either the formula or my implementation is wrong. Maybe it is easier to get the desired values via the Monte Carlo.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Build trailing stop for micro index(s)
Psychology and Money Management
ZombieSqueeze
Platforms and Indicators
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
  #12 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,175
Thanks Received: 101,541


vvhg View Post
After having tried the above formula, it doesn't seem to produce correct results. So either the formula or my implementation is wrong. Maybe it is easier to get the desired values via the Monte Carlo.

vvhg

Thanks for your efforts @vvhg.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread Reply With Quote
Thanked by:
  #13 (permalink)
 
Rad4633's Avatar
 Rad4633 
Greensboro NC
 
Experience: Advanced
Platform: TOS/ NT Dorman
Trading: ES TF CL
Posts: 1,357 since Sep 2011
Thanks Given: 2,657
Thanks Received: 894


Thx @Big Mike and @vvhg I like numbers more than words in trading, so I ll be watching as you guys progress with this

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #14 (permalink)
 geott 
France
 
Experience: Advanced
Platform: MT4/NT
Trading: YM, DAX, Fx, CFD
Posts: 25 since Oct 2010
Thanks Given: 18
Thanks Received: 40


trendisyourfriend View Post
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.

yes i would take the same way but with a serie with a range of [0;100] to condition his W/L probability.

Reply With Quote
Thanked by:
  #15 (permalink)
jerrick
Singapore
 
Posts: 1 since Jan 2013
Thanks Given: 0
Thanks Received: 1

hi,

I wasn't able to download the stuff. Does anyone knows where I can get a spreadsheet to run the figures (risk/reward, winning percentage etc?)

Reply With Quote
Thanked by:
  #16 (permalink)
 Fatfish 
South Africa
 
Experience: Beginner
Platform: Jigsaw
Broker: AMP, CQG
Trading: ES
Posts: 18 since Oct 2013
Thanks Given: 55
Thanks Received: 22

Hi, just recently joint the group, so although a late, I thought I'd post my version of an Excel Monte Carlo here.

It generates 1000 random numbers (with the Excel function) and generates trade results from these.

There is a macro included to write and plot 50 iterations over 1000 trades.
Plots for single iteration equity curves and underwater lines are drawn for 100, 250, 500 and 100 trades.
Envelopes for 50 iterations of 100, 250, 500 and 1000 trades are plotted.

It has fields for the following:

1. Initial account balance,
2. Maximum allowed gearing (which determines the number of contracts if fractional position sizing is selected)
3. No of winning trades from your trading / backtesting records
4. No of losing trades
5. No of break-even trades
6. Average winning trade (ticks)
7. Average losing trade (ticks)

I also incorporated inputs for trading costs, as these can take big bites out of the pie:
8. Bid / ask spread
9. Slippage
10. Brokerage fees
11. Exchange fees
12. Platform fees

Note that break even trades will show up as losses because of points 8 to 12.

I'd appreciate any feed back especially with regards to points 8 to 12.

Attached Files
Elite Membership required to download: Monte Carlo_rev1 - Copy.rar
Reply With Quote
Thanked by:
  #17 (permalink)
 
alejo's Avatar
 alejo 
madrid spain
 
Experience: Beginner
Platform: nt
Trading: None.
Posts: 1,311 since Apr 2013
Thanks Given: 16,557
Thanks Received: 646


Fatfish View Post
Hi, just recently joint the group, so although a late, I thought I'd post my version of an Excel Monte Carlo here.

It generates 1000 random numbers (with the Excel function) and generates trade results from these.

There is a macro included to write and plot 50 iterations over 1000 trades.
Plots for single iteration equity curves and underwater lines are drawn for 100, 250, 500 and 100 trades.
Envelopes for 50 iterations of 100, 250, 500 and 1000 trades are plotted.

It has fields for the following:

1. Initial account balance,
2. Maximum allowed gearing (which determines the number of contracts if fractional position sizing is selected)
3. No of winning trades from your trading / backtesting records
4. No of losing trades
5. No of break-even trades
6. Average winning trade (ticks)
7. Average losing trade (ticks)

I also incorporated inputs for trading costs, as these can take big bites out of the pie:
8. Bid / ask spread
9. Slippage
10. Brokerage fees
11. Exchange fees
12. Platform fees

Note that break even trades will show up as losses because of points 8 to 12.

I'd appreciate any feed back especially with regards to points 8 to 12.

i try to running but on contracts always say 0
any help?
thanks

alejo

Visit my NexusFi Trade Journal Reply With Quote
  #18 (permalink)
 
DNFX's Avatar
 DNFX 
Plovdiv Bulgaria
 
Experience: None
Platform: NinjaTrader , TradeStation
Trading: Forex
Posts: 3 since Nov 2013
Thanks Given: 9
Thanks Received: 2

@Big Mike I'd like to share my point of view about the subject. Copule of months ago I did same research, and you are right. I make 4 trading sistems, 2 with compound and 2 without. I use R-multiples so I can use a ROI formula for seek of simplicity(ROI = win% in decimals*R, if subtract 1 you'll get your edge in percents), which is same as M(E) with R:R ratio. So i just set up system A for 80% win and R= 1.5 which is equal to ROI = 1.2, and system B with parameters 30% win rate and R= 4 with the same ROI of 1.2. The outcome was that 2 systems with same edge and compound with same amount (1% of actual capital), more profitable is the system with higher win rate. It's all about how high frequently compound. I make Excel sheet to proof that statement. I don't add spread and commissions in math, but I think it's no need, if you measure the moves in money not in pips. I'll be happy if I help.

Attached Files
Elite Membership required to download: Proof.xlsx
Reply With Quote




Last Updated on November 26, 2013


© 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