Tools to analyse trades | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Analyse MT4 trades executed by trailing stop and Stop Loss 0 replies

How would YOU analyse this chart? 13 replies

Please analyse and let me know 9 replies

Using Meta Trader to analyse stocks? 6 replies

anyone recommend a broker which allow perfect technical analyse 4 replies

Tools to analyse trades

  • #1
  • First Post: Edited Oct 10, 2014 4:50am Oct 9, 2014 6:09am | Edited Oct 10, 2014 4:50am
Just wondering if anyone here analyses their trades and anlayses their journal.
Can anyone help me with these calculations.
I want to know the calculations if I was calculating these by hand.
Where can I obtain these calculations from?
I am interested in doing the following calculations:

Average P/L in $
Average P/L %
Average time in trade
Average Profit (winners)
Average Loss (losers)
Win %
P/L in $
Wins
Losses
Short trades
Long trades
Total weeks traded
starting balance
current balance

Recentl P/L
Last week
last 2 weeks
last 3 weeks
last month
Last month in $

Recent P/L %
Last week
last 2 weeks
last 3 weeks
last month

Average % return
Per week
Per month
Per year

Month on Month Analysis
Swing trading %
Day trading %
P/L in $
Total %

Thanks very much for your time and assistance

Tom
  • #2
  • Edited 4:52am Oct 10, 2014 4:31am | Edited 4:52am
Quoting tom82
Just wondering if anyone here analyses their trades and anlayses their journal. Can anyone help me with these calculations. I want to know the calculations if I was calculating these by hand. Where can I obtain these calculations from? I am interested in doing the following calculations: Average P/L in $ Average P/L % Average time in trade Average Profit (winners) Average Loss (losers) Win % P/L in $ Wins Losses Short trades Long trades Total weeks traded starting balance current balance Recentl P/L Last week last 2 weeks last 3 weeks last month...
I am not sure what you exactly want here. You just export your trades into an excel format and can calculate everything in excel with simple formulas. And if you just want to calculate these ratios then let me tell you right now that this is wayyyyyyy too basic. You need to go much more in depth.
  • #3
  • Oct 10, 2014 4:54am Oct 10, 2014 4:54am
Quoting Custos
{quote} I am not sure what you exactly want here. You just export your trades into an excel format and can calculate everything in excel with simple formulas. And if you just want to calculate these ratios then let me tell you right now that this is wayyyyyyy to basic. You need to go much more in depth.
But when you transfer the information to excel you need to know the formulas to be able to calculate them. That is what I am asking for, how to calculate these things.
If I know how to calculate these then I can create a spreadsheet to add my trades to, to be calculated, but one has to know how to calculate to be able to do this.
  • #4
  • Oct 10, 2014 5:10am Oct 10, 2014 5:10am
Quoting tom82
{quote} But when you transfer the information to excel you need to know the formulas to be able to calculate them. That is what I am asking for, how to calculate these things. If I know how to calculate these then I can create a spreadsheet to add my trades to, to be calculated, but one has to know how to calculate to be able to do this.
well, I can give you some examples: but it's really just a matter of structuring information.
average P/L: =average(G:G) (assuming your profit/loss column is column G)
historical win-rate: in column H write the following formula: if(G1>0;"profit";"loss"), drag that down to the last row - Now you can calculate your historical win-rate: countif(H:H;"profit")/count(H:H)
win-rate of the last week: type into a blank cell (e.g. A1): today()-7. Then if you have your closing dates in column I, you just write in column J: if(I1>A$1$;"last week";""), drag that down. now you can calculate the win-rate of the last week: countifs(J:J;"last week";H:H;"profit)/countif(J:J;"last week")

you get the idea. not too difficult - this is basic excel; if you don't know how to do this, then I suggest doing excel courses online.
  • #5
  • Oct 10, 2014 5:20am Oct 10, 2014 5:20am
Quoting Custos
{quote} well, I can give you some examples: but it's really just a matter of structuring information. average P/L: =average(G:G) (assuming your profit/loss column is column G) historical win-rate: in column H write the following formula: if(G1>0;"profit";"loss"), drag that down to the last row - Now you can calculate your historical win-rate: countif(H:H;"profit")/count(H:H) win-rate of the last week: type into a blank cell (e.g. A1): today()-7. Then if you have your closing dates in column I, you just write in column J: if(I1>A$1$;"last week";""),...
I'm not sure you fully understand what I am asking for. I don't actually want the formulas formatted for excel straight off the bat, I actually want to know the mathematical calculations of how to do these calculations, just as if I was doing them by hand.

I know its not difficult, I just don't know how to do the calculations.

After I know how to do them by hand will I move onto creating the spreadsheet.
  • #6
  • Oct 10, 2014 5:26am Oct 10, 2014 5:26am
Quoting tom82
{quote} I'm not sure you fully understand what I am asking for. I don't actually want the formulas formatted for excel straight off the bat, I actually want to know the mathematical calculations of how to do these calculations, just as if I was doing them by hand. I know its not difficult, I just don't know how to do the calculations. After I know how to do them by hand will I move onto creating the spreadsheet.
sorry I really don't understand.
you don't know how to build averages? and make percentage calculations? are you for real?
  • #7
  • Oct 10, 2014 5:34am Oct 10, 2014 5:34am
I only know the basic part of percentages and averages and thats about it.
I can find the percent of a number eg 5% of 75 is 75 * 0.05 = 3.75
And an average is add up and divide by however many there is.
If they are so easy, then it shouldn't be a problem for anyone to type out one or two calculations.
  • #8
  • Oct 10, 2014 5:39am Oct 10, 2014 5:39am
Quoting tom82
I only know the basic part of percentages and averages and thats about it. I can find the percent of a number eg 5% of 75 is 75 * 0.05 = 3.75 And an average is add up and divide by however many there is. If they are so easy, then it shouldn't be a problem for anyone to type out one or two calculations.
So then let's assume you have 5 trades: 3 are in profit, 2 are in a loss - 3/5 = win-rate; 2/5 = loss-rate
the 3 profit trades made 100$, 200$, 50$, the 2 loss trades made -50$ and -100$, average P/L = (100 + 200 +50 - 50 -100)/5

same goes for all other calculations you want to perform.
  • #9
  • Oct 10, 2014 5:50am Oct 10, 2014 5:50am
Quoting Custos
{quote} So then let's assume you have 5 trades: 3 are in profit, 2 are in a loss - 3/5 = win-rate; 2/5 = loss-rate the 3 profit trades made 100$, 200$, 50$, the 2 loss trades made -50$ and -100$, average P/L = (100 + 200 +50 - 50 -100)/5 same goes for all other calculations you want to perform.
Is this for Average P/L % or for Win % or Average Profit?
So you are saying the win rate = 3 / 5 = 0.60 or 60%

Is this for average loss?
loss rate = 2 / 5 = 0.40 or 40%

And with the average P/L you are saying to add up all the positive trades them minus each negative and divide by how many trades there were?

You are also saying the same equations are for all the calculations?
  • #10
  • Oct 10, 2014 7:02am Oct 10, 2014 7:02am
Quoting tom82
{quote} Is this for Average P/L % or for Win % or Average Profit? So you are saying the win rate = 3 / 5 = 0.60 or 60% Is this for average loss? loss rate = 2 / 5 = 0.40 or 40% And with the average P/L you are saying to add up all the positive trades them minus each negative and divide by how many trades there were? You are also saying the same equations are for all the calculations?
This is win% and loss%.

Sorry, but I am not here to teach basic high school maths. If you can't do such basic calculations then maybe trading is not for you.
  • #11
  • Oct 10, 2014 8:29am Oct 10, 2014 8:29am
Quoting Custos
{quote} This is win% and loss%. Sorry, but I am not here to teach basic high school maths. If you can't do such basic calculations then maybe trading is not for you.
I posted because I thought there might be some members wiling to help out with some of these but not necessarily all of them and other members might help with others.
If you are not willing to help or add to a topic then there is no point you responding to it.
As for my trading calculations (which there aren't many one needs to know) such as position sizing, I have all my trading calculations down to a T and my brokers have said they are spot on.
These aren't really trading calculations, they are really for analysing the trades.
  • #12
  • Oct 11, 2014 5:24am Oct 11, 2014 5:24am
the less indicators in your chart the more profit .


keep it simple as the above statement
  • #13
  • Oct 11, 2014 5:28am Oct 11, 2014 5:28am
Quoting ericnyamu
the less indicators in your chart the more profit . keep it simple as the above statement
I'm not sure what this has to do with journals.
  • #14
  • Oct 11, 2014 5:50am Oct 11, 2014 5:50am
Some free ones:

http://www.earnforex.com/report-analysis/
https://www.myfxbook.com/
http://www.fxblue.com/appstore/app.aspx?id=20

Not recommendations from me, please check for suitability.
It never gets easier, you just get better
  • #15
  • Oct 22, 2014 10:27pm Oct 22, 2014 10:27pm
Average P/L in $ = Sum of each trade profit & loss $ / Total number of trades

Average P/L in % = sum of each trade % profit & loss / total number of trades

Average profit = Sum of profitable trades $ / Number of win trades

Average Loss = sum of losing trades $ / number of losing trades

Win % = Number of win trades / total number of trades * 100

Average % return (per week, month etc) = % profit / number of weeks

Forecast full year % = weekly % * 52

weekly percent % * 4 weeks = % for month

Average return per trade = (Ending Equity - Starting Equity) / number of trades

Gain % = (Gain$ / Buy Price) * 100

Loss % = (Loss$ / Buy Price) * 100

Gain% or Loss% = 100 * (End Equity - Start Equity) / Start Equity

To average this over a number of trades you divide the result by the number of trades.

Profit / starting balance x 100

Turns dollar profit into percentage profit

Weekly profit percent = profit for the week / balance at the start of the week x 100

P/L for each trade

P/L % = P&L / Account size

Change weekly percent % * 4 weeks = % for month to the following:

weekly percent % * 4.348 = % for month

In business and reporting: there is not 4 weeks in a month, its 4.348
  • #16
  • Oct 22, 2014 11:09pm Oct 22, 2014 11:09pm
Quoting Shabs19
Some free ones: http://www.earnforex.com/report-analysis/ https://www.myfxbook.com/ http://www.fxblue.com/appstore/app.aspx?id=20 Not recommendations from me, please check for suitability.
myfxbook is what I use to analyze my account trades and performance.
The only problem I have an issue with is their highest DD%.
Striving to Develop & Implement Innovative Ideas
  • #17
  • Last Post: Oct 23, 2014 4:04am Oct 23, 2014 4:04am
Quoting ericnyamu
the less indicators in your chart the more profit . keep it simple as the above statement
Agree, use 2-3 indicators, it's enough for my strategy
0 traders viewing now