• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 6:17pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 6:17pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

cAlgo Optimisation 1 reply

Trade Size Optimisation 6 replies

Optimisation of trading systems 0 replies

My backtest - optimisation - trade plan 0 replies

Optimisation of a system issue 8 replies

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 1
Attachments: Optimisation Results Calculator
Exit Attachments

Optimisation Results Calculator

  • Post #1
  • Quote
  • First Post: Nov 13, 2015 10:51pm Nov 13, 2015 10:51pm
  •  Chrisian
  • | Joined Sep 2015 | Status: Member | 22 Posts
Hi Fellow Traders,

During Optimisation, I often used to find it hard to pick which result might produce the best results. As there is some results that MT4 strategy tester simply does not include.

So I created a google sheets calculator to find:

 

  1. The result with the highest profit and least drawdown. (Profit/Drawdown Ratio)

But then I found that this result is often smaller found in smaller profits.

So I then decided to find

  1. which is the highest profit result, with the highest Profit/Drawdown Ratio.


I made it in google sheets format, but it should work fine in excel.
It is fairly simple to use. Simply cut and paste profit into the profit column and cut and paste drawdown into the drawdown column. The sheet will auto calculate.

Then you can filter 'smallest to largest' the 'profit drawdown ratio as a percent column' to find the highest probability. If the profit result is not high enough.
Filter 'smallest to largest' the 'highest profit balance to profit drawdown ratio" column. Your profit result will go up but P/D will go down a little.

Note: The data in the sheet is example data.

Hope someone finds it useful.
-Chrisian

Attached File
File Type: xlsx OptResults Calc.xlsx   252 KB | 329 downloads
  • Platform Tech
  • /
  • Optimisation Results Calculator
  • Reply to Thread
0 traders viewing now
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2022