| MSQL
QUERY Client ID: |
|
| MSQL
QUERY Excal ID: |
|
| QUERY |
FromDate: |
2006.01.01
|
TDate: |
2006.12.31
|
Currency |
EUR/USD |
Total |
94650.00
|
| QUERY |
FromDate: |
2006.01.01
|
TDate: |
2006.12.31
|
Currency |
USD/CHF |
Total |
104825.56
|
Based on
the stats from this database we would be furtur ahead over the entire year if
we had placed hedge trades on both currencies. The difference in profit would
have been $ 83,397.35 with the hedge trades.
| Client
ID: XXXXX |
Date
open: 2005.12.15 |
Excalibur
Reg # XXXXX |
Deposit:
21400.00 new
|
Balance:21400.00
|
| Time |
Type
|
Size
|
Opened
|
Closed
|
Profit/Loss
|
Balance
|
|
2006.01.06
12:25
|
buy
EUR/USD
|
50.00
|
1.2099
|
1.2149
|
2500.00
|
23900.00
|
|
2006.01.06
12:25
|
sell EUR/USD
|
50.00
|
1.2097
|
1.2122
|
-1250.00
|
22650.00
|
|
2006.01.06
12:25
|
buy USD/CHF
|
50.00
|
1.2781
|
1.2731
|
1963.71
|
24614.42
|
|
2006.01.06
12:25
|
buy
USD/CHF
|
50.00
|
1.2785
|
1.2760
|
-979.62
|
23634.09
|
|
2006.01.06
12:25
|
sell USD/CHF
|
50.00
|
1.2771
|
1.2721
|
1965.25
|
25599.25
|
|
2006.01.06
12:25
|
sell USD/CHF
|
50.00
|
1.2761
|
1.2711
|
1966.80
|
27566.05
|
|
2006.01.06
12:25
|
sell USD/CHF
|
50.00
|
1.2751
|
1.2701
|
1968.35
|
29534.40
|
|
2006.01.06
13:12
|
sell EUR/USD
|
50.00
|
1.2087
|
1.2122
|
-1250.00
|
28284.40
|
|
2006.01.06
13:16
|
buy
EUR/USD
|
50.00
|
1.2109
|
1.2159
|
2500.00
|
30784.40
|
|
2006.01.06
13:17
|
buy
EUR/USD
|
50.00
|
1.2119
|
1.2169
|
2500.00
|
33284.40
|
|
2006.01.06
13:18
|
buy
EUR/USD
|
50.00
|
1.2129
|
1.2179
|
2500.00
|
35784.40
|
|
2006.01.06
13:26
|
sell USD/CHF
|
50.00
|
1.2741
|
1.2691
|
1969.90
|
37754.30
|
|
2006.01.06
13:26
|
buy
EUR/USD
|
50.00
|
1.2139
|
1.2170
|
1550.00
|
39304.30
|
| Client
ID: XXXXX |
Date
2006.02.01 |
Excalibur
Reg # XXXXX |
Deposit:
0
|
Balance:39304.30
|
|
2006.02.03
12:25
|
buy
EUR/USD
|
50.00
|
1.2068
|
1.2043
|
-1250.00
|
38054.30
|
|
2006.02.03
12:25
|
sell EUR/USD
|
50.00
|
1.2066
|
1.2016
|
2500.00
|
40554.30
|
|
2006.02.03
12:25
|
sell USD/CHF
|
50.00
|
1.2891
|
1.2916
|
-967.72
|
39586.58
|
|
2006.02.03
13:03
|
buy
EUR/USD
|
50.00
|
1.2078
|
1.2053
|
-1250.00
|
38336.58
|
|
2006.02.03
13:12
|
sell USD/CHF
|
50.00
|
1.2871
|
1.2896
|
-969.22
|
37367.36
|
|
2006.02.03
13:14
|
buy
EUR/USD
|
50.00
|
1.2088
|
1.2063
|
-1250.00
|
36117.36
|
|
2006.02.03
13:17
|
buy
USD/CHF
|
50.00
|
1.2895
|
1.2945
|
1931.25
|
38048.61
|
|
2006.02.03
13:18
|
buy
USD/CHF
|
50.00
|
1.2905
|
1.2955
|
1929.76
|
39978.37
|
|
2006.02.03
13:19
|
sell EUR/USD
|
50.00
|
1.2056
|
1.2006
|
2500.00
|
42478.37
|
|
2006.02.03
13:20
|
buy
USD/CHF
|
50.00
|
1.2915
|
1.2965
|
1928.27
|
44406.64
|
|
2006.02.03
13:27
|
sell EUR/USD
|
50.00
|
1.2046
|
1.2015
|
1550.00
|
45956.64
|
|
2006.02.03
13:27
|
buy
USD/CHF
|
50.00
|
1.2925
|
1.2957
|
1234.85
|
47191.49
|
|
2006.02.03
13:28
|
buy
USD/CHF
|
50.00
|
1.2935
|
1.2957
|
848.96
|
48040.45
|
|
2006.02.03
13:28
|
sell EUR/USD
|
50.00
|
1.2036
|
1.2015
|
1050.00
|
49090.45
|
|
2006.02.03
13:36
|
sell EUR/USD
|
50.00
|
1.2026
|
1.2015
|
550.00
|
49640.45
|
|
2006.02.14
12:25
|
buy
EUR/USD
|
50.00
|
1.1902
|
1.1877
|
-1250.00
|
48390.45
|
|
2006.02.14
12:25
|
sell EUR/USD
|
50.00
|
1.1900
|
1.1876
|
1200.00
|
49590.45
|
|
2006.02.14 12:25
|
sell USD/CHF
|
50.00
|
1.3089
|
1.3114
|
-953.18
|
48637.27
|
|
2006.02.14 12:25
|
buy
USD/CHF
|
50.00
|
1.3093
|
1.3126
|
1257.05
|
49894.32
|
|
2006.02.14 12:29
|
sell USD/CHF
|
50.00
|
1.3079
|
1.3104
|
-953.91
|
48940.41
|
|
2006.02.14
12:38
|
buy
EUR/USD
|
50.00
|
1.1912
|
1.1887
|
-1250.00
|
47690.41
|
|
2006.02.14
13:18
|
buy
USD/CHF
|
50.00
|
1.3103
|
1.3126
|
876.12
|
48566.53
|
|
2006.02.14
13:18
|
sell EUR/USD
|
50.00
|
1.1890
|
1.1876
|
700.00
|
49266.53
|
|
2006.02.14
13:26
|
buy
USD/CHF
|
50.00
|
1.3113
|
1.3126
|
495.20
|
49761.73
|
|
2006.02.14
13:28
|
buy
USD/CHF
|
50.00
|
1.3123
|
1.3126
|
114.28
|
49876.01
|
|
2006.02.14
13:28
|
sell EUR/USD
|
50.00
|
1.1880
|
1.1876
|
200.00
|
50076.01
|
|
2006.02.14
13:36
|
sell EUR/USD
|
50.00
|
1.1870
|
1.1895
|
-1250.00
|
48826.01
|
|
2006.02.14
13:36
|
buy
USD/CHF
|
50.00
|
1.3133
|
1.3108
|
-953.62
|
47872.39
|
|
2006.02.14
13:38
|
sell EUR/USD
|
50.00
|
1.1860
|
1.1885
|
-1250.00
|
46622.39
|
|
2006.02.14
21:05
|
buy
EUR/USD
|
50.00
|
1.1922
|
1.1916
|
-300.00
|
46322.39
|
|
| Client
ID: XXXXX |
Date
2006.03.01 |
Excalibur
Reg # XXXXX |
Deposit:
0
|
Balance:46322.39
|
| Time |
Type
|
Size
|
Opened
|
Closed
|
Profit/Loss
|
Balance
|
|
2006.03.10
12:25
|
buy
EUR/USD
|
50.00
|
1.1920
|
1.1895
|
-1250.00
|
45072.39
|
|
2006.03.10
12:25
|
sell EUR/USD
|
50.00
|
1.1918
|
1.1900
|
900.00
|
45972.39
|
|
2006.03.10 12:25
|
sell CHF/USD
|
50.00
|
1.3146
|
1.3171
|
-949.05
|
45023.34
|
|
2006.03.10 12:25
|
buy EUR/USD
|
50.00
|
1.3150
|
1.3179
|
1100.24
|
46123.58
|
|
2006.03.10
13:26
|
sell EUR/USD
|
50.00
|
1.1908
|
1.1900
|
400.00
|
46523.58
|
|
2006.03.10
13:26
|
buyUSD/CHF
|
50.00
|
1.3160
|
1.3179
|
720.84
|
47244.42
|
|
2006.03.10
13:26
|
buy
USD/CHF
|
50.00
|
1.3170
|
1.3179
|
341.45
|
47585.87
|
|
2006.03.10
13:36
|
buy
USD/CHF
|
50.00
|
1.3190
|
1.3165
|
-949.49
|
46636.38
|
|
2006.03.10
13:29
|
sell EUR/USD
|
50.00
|
1.1898
|
1.1876
|
1100.00
|
47736.38
|
|
2006.03.10
13:38
|
sell EUR/USD
|
50.00
|
1.1888
|
1.1876
|
600.00
|
48336.38
|
|
2006.03.14
12:25
|
buy
EUR/USD
|
50.00
|
1.1947
|
1.1961
|
700.00
|
49036.38
|
|
2006.03.14
12:25
|
sell EUR/USD
|
50.00
|
1.1945
|
1.1970
|
-1250.00
|
47786.38
|
|
2006.03.14
12:25
|
buy CHF/USD
|
50.00
|
1.3120
|
1.3095
|
-954.56
|
46831.82
|
|
2006.03.14
12:25
|
sell
CHF/USD
|
50.00
|
1.3116
|
1.3103
|
495.88
|
47327.70
|
|
2006.03.14
12:38
|
buy CHF/USD
|
50.00
|
1.3130
|
1.3105
|
-953.83
|
46373.87
|
|
2006.03.14
13:17
|
buyE
UR/USD
|
50.00
|
1.1957
|
1.1961
|
200.00
|
46573.87
|
|
2006.03.14
13:20
|
sell CHF/USD
|
50.00
|
1.3106
|
1.3103
|
114.43
|
46688.30
|
|
2006.03.14
13:36
|
sell CHF/USD
|
50.00
|
1.3096
|
1.3072
|
917.99
|
47606.29
|
|
2006.03.14
13:39
|
sell CHF/USD
|
50.00
|
1.3086
|
1.3111
|
-953.40
|
46652.89
|
|
2006.03.14
13:39
|
buy
EUR/USD
|
50.00
|
1.1957
|
1.1985
|
400.00
|
47052.89
|
|
2006.03.28
18:10
|
sell CHF/USD
|
50.00
|
1.3007
|
1.3032
|
-959.18
|
46093.71
| | |