Spreadsheet: 23751d1213464061-calculating-gross-p-l-on-2007-worksheet-clientreportservlet
Sheet: ClientReportServlet

ACCOUNT STATEMENT
AccountN: |  | Beginning Balance:
Owner Name: |  | Period:
Address: |  | From:
Trader: |  | To:
 |  | Current Date:
OPERATION HISTORY
# | Date/Time | Operation | Ref# | Instrument | Lot | BS | Open Rate | Close Rate | DP/WD | Transfer | Adjust | Credit/ Debit | Gross P/L | Commis | Rebate | Interest | [NAME] | PayOff | Balance | Win/Loss
1 | 05/19/2008 10:27:22 | Deposit |  |  |  |  |  |  | $71.77 |  |  |  |  | $0.00 | $0.00 |  |  |  | $96.28
2 | 05/20/2008 15:06:25 | Open Trade | 4130979 | USDCHF | 0.1 | S | 1.0368 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $96.28
3 | 05/20/2008 16:14:25 | Close Trade | 4130979 | USDCHF | 0.1 | S | 1.0368 | 1.0364 |  |  |  |  | $3.86 | $0.00 | $0.00 |  |  |  | $100.14
4 | 05/20/2008 16:52:08 | Open Trade | 4133399 | NZDJPY | 0.1 | S | 80.19 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $100.14
5 | 05/20/2008 17:00:00 | Rollover | 4133399 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($1.90) |  |  | $98.24
6 | 05/20/2008 20:14:44 | Close Trade | 4133399 | NZDJPY | 0.1 | S | 80.19 | 80.05 |  |  |  |  | $13.52 | $0.00 | $0.00 |  |  |  | $111.76
7 | 05/23/2008 15:21:54 | Open Trade | 4230979 | GBPJPY | 0.1 | S | 204.46 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $111.76
8 | 05/23/2008 16:00:00 | Rollover | 4230979 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($2.97) |  |  | $108.80
9 | 05/26/2008 09:02:53 | Close Trade | 4230979 | GBPJPY | 0.1 | S | 204.46 | 204.83 |  |  |  |  | ($35.77) | $0.00 | $0.00 |  |  |  | $73.03
10 | 05/26/2008 12:01:36 | Open Trade | 4249369 | GBPJPY | 0.1 | B | 205.15 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $73.03
11 | 05/26/2008 17:00:00 | Rollover | 4249369 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | $2.41 |  |  | $75.44
12 | 05/27/2008 01:32:23 | Close Trade | 4249369 | GBPJPY | 0.1 | B | 205.15 | 205.21 |  |  |  |  | $5.80 | $0.00 | $0.00 |  |  |  | $81.23
13 | 05/27/2008 01:45:39 | Open Trade | 4261379 | EURUSD | 0.1 | B | 1.5808 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $81.23
14 | 05/27/2008 02:09:05 | Close Trade | 4261379 | EURUSD | 0.1 | B | 1.5808 | 1.5811 |  |  |  |  | $3.00 | $0.00 | $0.00 |  |  |  | $84.23
15 | 05/28/2008 13:47:06 | Open Trade | 4307979 | USDCAD | 0.1 | S | 0.9905 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $84.23
16 | 05/28/2008 17:00:00 | Rollover | 4307979 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | $0.14 |  |  | $84.38
17 | 05/28/2008 21:03:21 | Close Trade | 4307979 | USDCAD | 0.1 | S | 0.9905 | 0.9899 |  |  |  |  | $6.06 | $0.00 | $0.00 |  |  |  | $90.44
18 | 05/29/2008 13:51:00 | Open Trade | 4344269 | EURUSD | 0.1 | S | 1.5493 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $90.44
19 | 05/29/2008 17:00:00 | Rollover | 4344269 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($0.76) |  |  | $89.68
20 | 05/30/2008 02:04:13 | Close Trade | 4344269 | EURUSD | 0.1 | S | 1.5493 | 1.5486 |  |  |  |  | $7.00 | $0.00 | $0.00 |  |  |  | $96.68
21 | 05/30/2008 03:40:11 | Open Trade | 4359299 | EURUSD | 0.1 | S | 1.5472 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $96.68
22 | 05/30/2008 04:08:47 | Close Trade | 4359299 | EURUSD | 0.1 | S | 1.5472 | 1.5467 |  |  |  |  | $5.00 | $0.00 | $0.00 |  |  |  | $101.68
23 | 05/30/2008 11:35:15 | Open Trade | 4375029 | USDCHF | 0.1 | S | 1.0432 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $101.68
24 | 05/30/2008 16:00:00 | Rollover | 4375029 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($0.14) |  |  | $101.54
25 | 39453.73680555556 | Close Trade | 4375029 | USDCHF | 0.1 | S | 1.0432 | 1.0425 |  |  |  |  | $6.71 | $0.00 | $0.00 |  |  |  | $108.26
26 | 39453.74375 | Open Trade | 4381779 | USDCHF | 0.1 | S | 1.0417 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $108.26
27 | 39484.49166666667 | Close Trade | 4381779 | USDCHF | 0.1 | S | 1.0417 | 1.0379 |  |  |  |  | $36.61 | $0.00 | $0.00 |  |  |  | $144.87
28 | 39484.50902777778 | Open Trade | 4403969 | USDCHF | 0.1 | S | 1.0378 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $144.87
29 | 39484.52430555555 | Close Trade | 4403969 | USDCHF | 0.1 | S | 1.0378 | 1.0365 |  |  |  |  | $12.54 | $0.00 | $0.00 |  |  |  | $157.41
30 | 39484.52916666667 | Open Trade | 4404979 | USDJPY | 0.1 | S | 104.16 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $157.41
31 | 39484.70833333334 | Rollover | 4404979 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($0.74) |  |  | $156.67
32 | 39513.11597222222 | Close Trade | 4404979 | USDJPY | 0.1 | S | 104.16 | 104.02 |  |  |  |  | $13.46 | $0.00 | $0.00 |  |  |  | $170.13
33 | 39513.55486111111 | Open Trade | 4441579 | NZDUSD | 0.1 | S | 0.7816 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $170.13
34 | 39513.70833333334 | Rollover | 4441579 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($1.32) |  |  | $168.81
35 | 39513.79097222222 | Close Trade | 4441579 | NZDUSD | 0.1 | S | 0.7816 | 0.7808 |  |  |  |  | $8.00 | $0.00 | $0.00 |  |  |  | $176.81
36 | 39544.09166666667 | Open Trade | 4457449 | AUDUSD | 0.1 | B | 0.956 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $176.81
37 | 39544.14791666667 | Close Trade | 4457449 | AUDUSD | 0.1 | B | 0.956 | 0.9575 |  |  |  |  | $15.00 | $0.00 | $0.00 |  |  |  | $191.81
38 | 39574.55625 | Open Trade | 4519369 | USDCHF | 0.1 | S | 1.0389 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $191.81
39 | 39574.61041666667 | Close Trade | 4519369 | USDCHF | 0.1 | S | 1.0389 | 1.037 |  |  |  |  | $18.32 | $0.00 | $0.00 |  |  |  | $210.13
40 | 39574.61666666667 | Open Trade | 4521179 | [NAME] | 0.1 | B | 1.9589 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $210.13
41 | 39574.70833333334 | Rollover | 4521179 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | $1.21 |  |  | $211.34
42 | 39605.35416666666 | Close Trade | 4521179 | [NAME] | 0.1 | B | 1.9589 | 1.9607 |  |  |  |  | $18.00 | $0.00 | $0.00 |  |  |  | $229.34
43 | 39605.50763888889 | Open Trade | 4535839 | USDJPY | 0.1 | S | 105.33 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $229.34
44 | 39605.63541666666 | Close Trade | 4535839 | USDJPY | 0.1 | S | 105.33 | 105.2 |  |  |  |  | $12.36 | $0.00 | $0.00 |  |  |  | $241.70
45 | 39666.72638888889 | Open Trade | 4541979 | GBPJPY | 0.1 | S | 206.12 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $241.70
46 | 39666.73194444444 | Close Trade | 4541979 | GBPJPY | 0.1 | S | 206.12 | 205.86 |  |  |  |  | $24.89 | $0.00 | $0.00 |  |  |  | $266.58
47 | 39758.53125 | Open Trade | 4641439 | USDCHF | 0.1 | S | 1.0319 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $266.58
48 | 39758.70833333334 | Rollover | 4641439 |  |  |  |  |  |  |  |  |  |  | $0.00 | $0.00 | ($0.42) |  |  | $266.17
49 | 39758.89652777778 | Close Trade | 4641439 | USDCHF | 0.1 | S | 1.0319 | 1.0347 |  |  |  |  | ($27.07) | $0.00 | $0.00 |  |  |  | $239.09
50 | 06/13/2008 10:57:01 | Open Trade | 4701369 | EURAUD | 0.1 | S | 1.6341 |  |  |  |  |  |  | $0.00 | $0.00 |  |  |  | $239.09
 | Total |  |  |  |  |  |  |  | $71.77 | $0.00 | $0.00 |  | $147.29 |  |  | ($4.48) | $0.00 | $0.00
SETTLED TRADES
N/N | CloseDate/Time | TicketN | Instrument | BS | Lot | Open Rate | Open Date | Close Rate | Gross PL | Reason
1 | 05/20/2008 16:14:25 | 4130979 | USDCHF | S | 0.1 | 1.0368 | 05/20/2008 15:06:25 | 1.0364 | $3.86 | Close
2 | 05/20/2008 20:14:45 | 4133399 | NZDJPY | S | 0.1 | 80.19 | 05/20/2008 16:52:08 | 80.05 | $13.52 | LimitProfit
3 | 05/26/2008 09:02:53 | 4230979 | GBPJPY | S | 0.1 | 204.46 | 05/23/2008 15:21:54 | 204.83 | ($35.77) | StopLoss
4 | 05/27/2008 01:32:23 | 4249369 | GBPJPY | B | 0.1 | 205.15 | 05/26/2008 12:01:36 | 205.21 | $5.80 | LimitProfit
5 | 05/27/2008 02:09:05 | 4261379 | EURUSD | B | 0.1 | 1.5808 | 05/27/2008 01:45:39 | 1.5811 | $3.00 | Close
6 | 05/28/2008 21:03:21 | 4307979 | USDCAD | S | 0.1 | 0.9905 | 05/28/2008 13:47:06 | 0.9899 | $6.06 | StopLoss
7 | 05/30/2008 02:04:13 | 4344269 | EURUSD | S | 0.1 | 1.5493 | 05/29/2008 13:51:00 | 1.5486 | $7.00 | LimitProfit
8 | 05/30/2008 04:08:47 | 4359299 | EURUSD | S | 0.1 | 1.5472 | 05/30/2008 03:40:11 | 1.5467 | $5.00 | LimitProfit
9 | 39453.73680555556 | 4375029 | USDCHF | S | 0.1 | 1.0432 | 05/30/2008 11:35:15 | 1.0425 | $6.71 | StopLoss
10 | 39484.49166666667 | 4381779 | USDCHF | S | 0.1 | 1.0417 | 39453.74375 | 1.0379 | $36.61 | LimitProfit
11 | 39484.52430555555 | 4403969 | USDCHF | S | 0.1 | 1.0378 | 39484.50902777778 | 1.0365 | $12.54 | LimitProfit
12 | 39513.11597222222 | 4404979 | USDJPY | S | 0.1 | 104.16 | 39484.52916666667 | 104.02 | $13.46 | LimitProfit
13 | 39513.79097222222 | 4441579 | NZDUSD | S | 0.1 | 0.7816 | 39513.55486111111 | 0.7808 | $8.00 | Close
14 | 39544.14791666667 | 4457449 | AUDUSD | B | 0.1 | 0.956 | 39544.09166666667 | 0.9575 | $15.00 | LimitProfit
15 | 39574.61041666667 | 4519369 | USDCHF | S | 0.1 | 1.0389 | 39574.55625 | 1.037 | $18.32 | StopLoss
16 | 39605.35416666666 | 4521179 | [NAME] | B | 0.1 | 1.9589 | 39574.61666666667 | 1.9607 | $18.00 | LimitProfit
17 | 39605.63541666666 | 4535839 | USDJPY | S | 0.1 | 105.33 | 39605.50763888889 | 105.2 | $12.36 | StopLoss
18 | 39666.73194444444 | 4541979 | GBPJPY | S | 0.1 | 206.12 | 39666.72638888889 | 205.86 | $24.89 | LimitProfit
19 | 39758.89652777778 | 4641439 | USDCHF | S | 0.1 | 1.0319 | 39758.53125 | 1.0347 | ($27.07) | StopLoss
 | Total |  |  |  |  |  |  |  | $147.29
OPEN ORDERS
N/N | Date/Time | Order # | Type | Duration | Execution | Ticket | Instrument | Lot | B/S | Open Rate | OCO | If Done
1 | 06/13/2008 10:57:54 | 10999480 | Limit | GTC | Close | 4701369 | EURAUD | 0.1 | B | 1.6309
2 | 06/13/2008 11:02:34 | 10999690 | Stop | GTC | Close | 4701369 | EURAUD | 0.1 | B | 1.6415
OPEN POSITIONS
N/N | TicketN | Instrument | Lot | BS | Open Rate | Date/Time | Close Rate | Gross P/L | Commission | Rebate | Interest | Net P/L
1 | 4701369 | EURAUD | 0.1 | S | 1.6341 | 06/13/2008 10:57:01 | 1.639 | ($46.02) | $0.00 | $0.00 | $0.00 | ($46.02)
 | Total |  |  |  |  |  |  | ($46.02) |  |  | $0.00 | ($46.02)
Beginning Balance: | $24.51
Total Gross P/L from settled trades: | $147.29
Commission:
Rebate:
Premium: | ($4.48)
Net Deposit: | $71.77
Ending Balance: | $239.09
Total Gross P/L from open positions: | ($46.02)
Equity: | $193.08
Used Margin: | $25.00
[NAME] (Average Profit/Loss)
System Acurracy (% win Trds over all trades
Expectation  = (1+Pay off Ratio)x(System Accuracy)-1
Wins
Losses
Average Profit | 4.44
Average Loss | 3.3