Tool for analyzing trader's operations: 92 markers, 260 diagrams and graphs + user reports on transaction properties
In our opinion, we shall start with the most interesting and useful - with user reports. In any case, it's as useful as the Sortino or Sharpe ratio.
User reports (reports on properties of transactions)
For example, we added 2 properties:
- 'Market area'with values: 'Trend', 'Flat', 'Uncertain'
- 'Pattern'with values: 'Head and shoulders', 'Double top', 'Double bottom', 'Wedge' etc.
You can create different properties on your own.
In transactions, we set values for each property (we'll give more details on this subject below).
What does it give us? After adding a new property, a new report type with the same name appears in the reports. Open the report form and select 'Market area' as the report type. Let's see what we get:
Let's draw up the second report with the 'Pattern' property:
What conclusion can we make? Using our trading system you should not work with 'Indefinite' area of the market, as well as withfigures 'Wedge', since according to statistics we bear losses using them. It is better to refrain from working with such area and finalize our strategy.
Let's see how we added properties. To do this, we opened the 'Properties' directory (Menu --> Directories --> Properties), clicked the 'Add' button and filled out the forms as follows:
After we created new properties, new columns were added to the Trading journal and this allowed us to set values for each property in transactions
Transaction properties make up a powerful tool for every trader, allowing you to analyze your trade as profoundly as possible and get detailed statistics on your trading systems. Be sure to use them in your work, without them statistics look inferior.
Report: Result table
Traders express different opinions and constantly argue about what should markers of successful trade be like, what should be their maximum or minimum level, and we do not intend to give here a specific and clear answer for each value. Our task is to reflect real markers in statistics, i.e. correctly calculate them based on your data using common formulas, and to show formulas we use.
The 'Result table' report contains values for 92 different markers. Let us consider only some of the most important ones.
Report: Profit factor
Profit factor = Amount sum of profitable transactions / Amount sum of unprofitable transactions
Beginners are usually told that the profit factor should be at least 2 to 1. Professionals are not satisfied even with 5 to 1.
Profit factor can be calculated both for the entire period of trade and for a certain period of time. Let's consider an example. In January, the amount sum of all profitable transactions was $1000. For the same period of time, the amount of all unprofitable transactions was $400. So profit factor = 1000 / 400 = 2.5 or 2.5 to 1.
If you have not set a date filter in the report, the profit factor will be calculated for the entire period of time
Since we're talking about profit factor, we should take a look at another graph with the same name 'Profit factor'
The above graph was built 'By day'. I.e. it shows how that marker has changed day by day. Now let's draw it up by month
Let's look at one more graph, but this time in the marker field we choose 'Points' instead of 'Net profit'. Usually no one calculates the profit factor in points, but in fact they should. You can get interesting information from this. So, what do we see? 2 different profit factors. The first one is equal to 1.51, the second is 1.64. I.e. a profit factor drawn up by points has a higher value. How can this be? Most likely when trading we incorrectly calculated a lot. It often happens that by points we benefit and by sum we loose. To avoid this it is essential to calculate a lot at all times. The calculation formula is almost the same:
Profit factor = Sum of profitable transaction points / Sum of unprofitable transaction points
Report: Actual profit factor
Actual profit factor = (Amount sum of profitable transactions - Result of the most profitable transaction) / Amount sum of unprofitable transactions
It is believed that, by deducting the result of the most profitable transaction from the amount sum of profitable transactions, we get more accurate and reliable result.
Report: Expected payoff
Exp. payoff = (1 + (Average profit / Average loss)) * (Number of profitable transactions / Total transactions) - 1
Most importantly, this marker must be positive. If it is negative, it means that we will lose the entire deposit soon, if we continue to trade in the same strain. The higher it is, the better. Let's substitute values in this formula.
Average profitable transaction = $80
Average unprofitable transaction = $30
The number of profitable transactions = 40
Total transactions = 100
Exp. payoff = (1 + ($80 / $30)) * (40 / 100) - 1 = 0,46
For a more visual example and in order to understand how the expected payoff changes over time we can construct a graph with the same name. It can be constructed using different periodicity: By transactions, by days, by weeks and by months. We will construct it by days and see how the expected payoff has been changing day by day
Report: Maximum drawdown
Maximum drawdown = Maximum difference between the maximum and minimum account balance
For better understanding let's look at the 'Capital curve' graph
In the 'Result table' table we show the Maximum drawdown in currency, in points and in percents
Report: Recovery factor
Recovery factor = Net profit / Maximum drawdown
It is believed that the higher the recovery factor is, the faster our trade is recovering from drawdowns. If you compare 2 trading system (TS), the one with the smaller recovery factor will be worse. Assume that the TS No. 1 has earned us 150% at a drawdown of 50%, its profit factor will be 3. And TS No. 2 has given us just 50% at a drawdown of 10%. Its profit factor will equal to 5, and therefore it will be better than TS No. 1. The profitability of TS No. 2 can be easily increased to 100% through the use of higher leverage.
Report: Complex. Units = Instruments, Period = By weeks
Report: Complex. Units = Strategies, Period = By days
Report: Complex. Units = Accounts, Period = By months
Report: Balance dynamics. Units = Net profit, Period = By weeks
Report: Balance dynamics. Units = Pips, Period = By months
Report: Profit/loss. Units = Net profit, Period = By weekdays
Report: Profit/loss. Units = Pips, Period = By hours
Report: Profit/loss. Units = Number of records, Period = By months
Report: Profit/loss. Units = Percents, Period = By weekdays
Report: Trade dynamics. Units = Net profit, Period = By weeks
Report: Trade dynamics. Units = Pips, Period = By months
Report: Trade dynamics. Units = Percents, Period = By records
Report: Revenue in %. Units = Net profit, Period = By weeks
Report: Revenue in %. Units = Gross profit, Period = By months
Report: Instruments. Units = Net profit
Report: Instruments. Units = Percents
Report: Strategies. Units = Net profit
Report: Strategies. Units = Number of records
Report: Short/long. Units = Net profit
Report: Short/long. Units = Number of records
Report: Weight ranges. Units = Net profit, Range size = 10
Report: Duration. Units = Net profit, Range size = 180