TradeReport

[mobthehop]

Hi Rene,

first of all thanks for sharing your indicators.... Question: Would it be possible to add the ability filter group by OrderComment?

I would like to be able to separate the Trend/ Counter-Trend of the latest NB EA's to check their respective profitability over time (I am actually using 4 different order comments).

Thanks in advance for your consideration / Mop

[renexxxx]

Hi Rene,

first of all thanks for sharing your indicators.... Question: Would it be possible to add the ability filter group by OrderComment?

I would like to be able to separate the Trend/ Counter-Trend of the latest NB EA's to check their respective profitability over time (I am actually using 4 different order comments).

Thanks in advance for your consideration / Mop

I thought you'd never ask! This has already been done, as I have been filtering my trades also by "Trend" and "CT". Great minds think alike! Update in post 1.

[Pedigree]

Hi Rene,

Well, the requests are coming thick and fast now! That’s the thanks you get for sharing a great tool! And this is a great tool you’ve shared here……it’s interesting that it comes up just now.

I have been searching for a tool that calculates the %Change in Equity for a given period using just the displayed platform Equity. Now, you can calculate %Change in 2 ways:

(Profits from closed trades for period / Equity at start of period) * 100

And:

(Current Equity – Equity at start of period) / Equity at start of period * 100

iProfit Tracker, an indi that many of us use bases its calculation on the first approach; but this gives grossly inaccurate figures in a hedge situation in which pseudo-profits have accrued from opening up a hedge (closing one of the trades in profit). The first method will show a %increase in the account even though there has been no increase at all and the displayed platform Equity (Dashboard Equity or Dash Equity for short) remains the same.

The second method of calculation reflects the situation more accurately (even though it may not include swap and commissions as does the first).

Is there any chance Rene, of also displaying in this tool the Dash Equity at the start of any selected period and a calculation of %Change for the period based on it as in the second above approach? It will be a great and unique addition to an already very decent tool.

Thank you.

[renexxxx]

Is there any chance Rene, of also displaying in this tool the Dash Equity at the start of any selected period and a calculation of %Change for the period based on it as in the second above approach? It will be a great and unique addition to an already very decent tool.

Thank you.

Everything is possible, as long as it can be formulated properly. Therefore, I need to understand exactly what it is you're proposing.

There is no function in MQL4 to get the Account Equity for a certain historic date and time. You can approximate the Account Equity at the start of the report period, as Current Account Equity - (The sum of the Order Profits, Commissions and Swaps of all the closed orders during the reporting period + the sum of the currently open order Profits, Commissions and Swaps). You'd miss (or ignore) account deposits and account withdrawals, as well as contributions to the account from other EAs and manual trading.

This way, we measuring the effect this EA (with the given magic number and comment filter) has had to the bottom line of the account.

The information would have to be displayed underneath the current report, as this is a summary figure. At the same time we can add the Profit Factor (Gross Profit/Gross Loss) and may be some other stuff.

Also, as a side-note, , it is important to know that you must have included the date range, you're creating your report for, on the "Account History"-tab. MQL can not list orders from before the start date on the "Account History".

So, let me know what you want and I will consider.

[Pedigree]

Is there any chance Rene, of also displaying in this tool the Dash Equity at the start of any selected period and a calculation of %Change for the period based on it as in the second above approach? It will be a great and unique addition to an already very decent tool.

Thank you.

There is no function in MQL4 to get the Account Equity for a certain historic date and time. You can approximate the Account Equity at the start of the report period, as Current Account Equity - (The sum of the Order Profits, Commissions and Swaps of all the closed orders during the reporting period + the sum of the currently open order Profits, Commissions and Swaps). You'd miss (or ignore) account deposits and account withdrawals, as well as contributions to the account from other EAs and manual trading.

This way, we measuring the effect this EA (with the given magic number and comment filter) has had to the bottom line of the account.

The information would have to be displayed underneath the current report, as this is a summary figure. At the same time we can add the Profit Factor (Gross Profit/Gross Loss) and may be some other stuff.

Also, as a side-note, , it is important to know that you must have included the date range, you're creating your report for, on the "Account History"-tab. MQL can not list orders from before the start date on the "Account History".

So, let me know what you want and I will consider.

The idea is to be able to obtain a fairly accurate %change estimate of the account in a given period in which any unreal profits have been generated - such as in the opening of a hedge. The method used will have to exclude such profits from the estimate.

The Equity displayed at the bottom of the Empty4 platform at the start of any set period is the quantity I am suggesting we use as the start equity. It's value at the end of the set period will also determine the "true" profit for the period, and it is on this we will then base our %change estimation. This way, any pseudo-profits are eliminated.

We can let the periods for estimation be standard ones such as:

Current Day
Current Week
Current Month
Current Quarter
Current Year

The value of the dash equity at the start of each period will be derived by any method you consider the best. One method could be to routinely at the start of each period write the value of the Dash Equity to a csv file from which the indi will later read for its calculation of %change.

What do you think?

The idea of being able to estimate in isolation the sole contribution of a particular ea to the %change by the use of a magic number will be nice and would simply increase the versatility of the indi, but it is not what I am referring to primarily. I am speaking of the total "real" increase of the account in the set period.

[renexxxx]

The value of the dash equity at the start of each period will be derived by any method you consider the best. One method could be to routinely at the start of each period write the value of the Dash Equity to a csv file from which the indi will later read for its calculation of %change.

Ok, I now understand what you're after. This has nothing to do with TradeReport though, but that doesn't make it any less relevant. However, it should be considered in its own right.

You just want to record the Account Equity (not balance) over time -- irrespective and independent of what EAs or what manual strategies are being used to alter that equity.

The easiest way to do this -- which unfortunately can not look back -- is to just create a little indicator that adds a line in the format <datetime>, <account equity> to a file, every x minutes or hours. This file can than later be read and interpreted. This is not unlike how the ProfitPlot indicator does its job. Problems are: (1) You can not look back in time (2) The indicator must always be running on some chart.

If you do need the option to go back in time than things get very complicated. For each time in the past we must work out what trades are open at the time (by looking at the OrderOpenTime and OrderCloseTime), how many PIPs they are up or down since opening, and using the trade's lotsize how this converts to a $-figure. This is inaccurate, but gives you a rough idea of the equity at the time.

In any case, we are talking about another (but also important) indicator.

[Pedigree]

The value of the dash equity at the start of each period will be derived by any method you consider the best. One method could be to routinely at the start of each period write the value of the Dash Equity to a csv file from which the indi will later read for its calculation of %change.

You just want to record the Account Equity (not balance) over time -- irrespective and independent of what EAs or what manual strategies are being used to alter that equity.

Correct.

The easiest way to do this -- which unfortunately can not look back -- is to just create a little indicator that adds a line in the format <datetime>, <account equity> to a file, every x minutes or hours. This file can than later be read and interpreted. This is not unlike how the ProfitPlot indicator does its job. Problems are: (1) You can not look back in time (2) The indicator must always be running on some chart.

Yes Rene, this will be fine.

If you do need the option to go back in time than things get very complicated. For each time in the past we must work out what trades are open at the time (by looking at the OrderOpenTime and OrderCloseTime), how many PIPs they are up or down since opening, and using the trade's lotsize how this converts to a $-figure. This is inaccurate, but gives you a rough idea of the equity at the time.

This would be a very valuable tool indeed Rene, but I don't dare to ask for so much of your time. But please indulge me with a few answers here:

I have in the past week or so trawled through a lot of code in indis and EAs that have to do with equity, in an attempt to write this function into the iProfitTracker indi. I got to learn that, as you said, MQL4 does not link Equity to orders as it does other parameters such as OrderOpenTime, OrderCloseTime etc., including the profit on closure from the order. So it is impossible to obtain equity from some point in the past by querying an order opened or closed at about that time for it.

I saw a method that appeared to derive equity at some point in the past by looking at a bar representing that time. Is it the case that equity is linked with and recorded at every bar open/close? At the end of each broker's day, a statement is sent out detailing the day's trading. This statement includes the equity at the end of that day. My impression is that it is possible to retrieve this statement for any day in the past, which would mean that the equity value at the end of each day is indeed stored somewhere in the system. Is this really the case?

Wherever and however it is stored, if some tool could fetch equity at some point in the past (even if not with deadly accuracy) and obtain account %increase by comparing it to the present dash equity, that would be wonderful indeed.

Are you up for this Rene? There is certainly no urgency about it, but if in time you could take a look at it at your convenience, it will be really appreciated.

Thank you for the attention you've given to this already to this point.

[Bogie6953]

Thanks, Renee!

When I saw this in your post over in SBB, I knew it was exactly what I was looking for.

As we know, determining which pairs are the most profitable for any given EA can be a moving target. The pairs that are most profitable this week or this month may shift over time. This can be an invaluable tool for keeping a finger on the pulse of the market.

Thanks again! I tip my hat to you! :hi:

[Aussiedoc]

Thanks, mate!

Much appreciated. Just what I needed. :hi:

Cheers

[Bruster400]

Renee,

Thanks, this is a great tool which is already proving its worth in my trading. I have one request though....

I was hoping it might be possible to have a placement input that would allow me to put the table in other places rather than just in the top left corner. Essentially an x and y (or just y) input to adjust the position of the top corner.

The idea is that this would allow me to have one table for my performance month to date, one for week to date and one for the current day. I don't trade many symbols so this would easily fit on one chart. I am assuming of course that it's possible to have more than one instance of this indicator running at the same time which may not be the case.

Not sure if anyone else would find this useful and I certainly don't pretend to know how difficult it is to do so I'll leave it with you to decide if it's worth / possible to do.

Thanks

Bruster.