Forex Blog

First-hand Forex trading experience and information about foreign exchange market that will be useful to traders


Forex Report Analysis Tool (BETA)

April 22, 2011 (Last updated on July 11, 2018) by

I’ve launched a beta version of a new online Forex report analysis tool that can show a lot of different metrics based on MT4/MT5/Oanda account reports (and MT4/MT5 Strategy Tester reports):

This tool is completely free and will always remain such. As I have already said, it’s still in beta-testing period, but is already quite functional. It can calculate the following metrics:

  • Gross profit/loss
  • Net profit in $ and pips
  • Total/lost/won positions
  • Short/long trades — total/lost/won
  • Positions with TP/SL
  • Triggered TP/SL
  • Average TP/SL outcome
  • Profit factor
  • Expected payoff
  • Recovery factor (Calmar ratio)
  • Maximum consecutive profit/loss
  • Average winning/losing streaks
  • Absolute/maximum/relative drawdown
  • Commission/swap
  • Largest/average loss/profit
  • Reward-risk ratio
  • Sharpe ratio
  • Sortino ratio
  • Ulcer index
  • AHPR
  • GHPR
  • Standard deviation
  • Z-Score (and Probability)
  • Total/average duration of trades
  • R-Multiples
  • Losses in a row
  • Risk of ruin

It displays the following charts:

  • Balance on time
  • Profit on trades (with Linear Regression and Correlation)
  • Losses in a row
  • Pie charts for winning/losing/total positions, short/long trades, gross profit/loss and duration of winning/losing positions if report is for more than 1 currency pair

This online tool can calculate its metrics for 4 main periods:

  • Daily
  • Weekly
  • Monthly
  • Yearly

Works with the HTML (no .csv sorry) reports of the following platforms:

  • MetaTrader 4
  • MetaTrader 5
  • Oanda
  • MT4 Strategy Tester
  • MT5 Strategy Tester
  • MT4 Strategy Tester report merged by MQLsoft’s ReportManager

It’s a great tool if you want to measure the efficiency of your Forex strategy, especially if you are using demo account trading on multiple currency pairs or want to assess different time periods of your trading results. A deeper analysis of the strategy tester results are also quite helpful for further optimization.

I’d like to hear your opinions and suggestions — is it a useful tool? What should be added? What features are the most useful? What report types should be supported?

Update 2011-04-23:

  • Fixed starting balance display format.
  • Fixed balance chart display for some MT4 reports.
  • Fixed pie charts display (particularly when more than 10 trading instruments are analyzed).

Update 2011-04-24:

  • Fixed problems with analysis and display for reports with either only winning or only losing positions.
  • Fixed minor Risk of Ruin calculation bug.
  • Fixed pie charts bug when no data to display.
  • Fixed minor flow in Losses in Row chart display.
  • Fixed minor problem with HTML markup.
  • Fixed Main Data table display for reports containing only one currency pair.
  • Fixed problem with recognizing MT4 Strategy Tester reports in languages other than English.
  • Fixed negative Linear Regression chart display.

Update 2011-04-26:

  • Fixed Ulcer index and GHPR calculation for reports with only one currency pair.

Update 2011-04-27:

  • Fixed issues with exotic character encoding types.
  • Fixed pie charts displaying zero values in some cases.

Update 2011-05-06:

  • Added metric breakdown by weekdays.
  • Fixed Oanda position volume display.

Update 2011-05-09:

  • Added annualized ROI calculation.

Update 2011-05-10:

  • Added 3 different types of ROI and modified the way it’s calculated.

Update 2011-05-11:

  • Added Summary table with the basic report statistics.

Update 2011-07-10:

If you want to make a suggestion for the report analysis tool or report a bug in it, please feel free to submit them using the commentary form below.

Leave a Reply

required (will not be published)