MSQL QUERY Client ID:
XXX-XXX21
MSQL QUERY Excal ID:
XXXX56
Go back

 

 

Client ID: XXXXX Date open: 2007.01.01 Excalibur Reg # XXXXX
Deposit: 3000.00
Balance:16339.00
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.01.01 12:01
Balance
16339.00
2007.01.03 14:47
sell
3.27
1.3221
1.3168
173.31
16512.31
2007.01.03 14:55
sell
3.27
1.3211
1.3168
140.61
16652.91
2007.01.03 15:13
sell
3.27
1.3201
1.3168
107.91
16760.83
2007.01.05 13:18
sell
3.35
1.3065
1.3019
154.10
16914.93
2007.01.05 13:24
sell
3.35
1.3055
1.3019
120.60
17035.53
2007.01.05 13:26
sell
3.35
1.3045
1.3019
87.10
17122.63
2007.01.11 12:02
buy
3.42
1.2986
1.2961
-85.50
17037.13
2007.01.11 12:08
buy
3.42
1.2996
1.2971
-85.50
16951.63
2007.01.11 12:14
buy
3.42
1.3006
1.2981
-85.50
16866.13
2007.01.11 08:15
sell
3.42
1.2944
1.2893
270.18
17136.31
2007.01.11 08:15
sell
3.42
1.2934
1.2892
239.40
17375.71
2007.01.11 08:15
sell
3.42
1.2924
1.2893
201.78
17857.49
2007.01.16 13:19
sell
3.52
1.2944
1.2921
80.96
17658.45
2007.01.16 14:19
sell
3.52
1.2934
1.2921
45.76
17704.21
2007.01.16 14:49
sell
3.52
1.2924
1.2921
10.56
17714.77
Client ID: XXXXX Date open: 2007.02.01 Excalibur Reg # XXXXX
Deposit: 3000.00I new
Balance:17714.77
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.02.01 14:56
buy
3.54
1.3041
1.3016
-88.50
17626.27
2007.02.01 15:06
buy
3.54
1.3051
1.3026
-88.50
17537.77
2007.02.02 13:19
buy
3.51
1.3043
1.3018
-87.75
17450.02
2007.02.02 13:31
buy
3.51
1.3053
1.3028
-87.75
17362.27
2007.02.02 13:36
buy
3.51
1.3063
1.3038
-87.75
17274.77
2007.02.02 12:15
sell
3.51
1.3001
1.2975
164.97
17439.74
2007.02.02 12:15
sell
3.51
1.2981
1.2976
94.77
17534.51
2007.02.02 12:15
sell
3.51
1.2991
1.2976
126.36
17660.87
2007.02.07 14:39
buy
3.53
1.3007
1.3010
10.59
17671.46
2007.02.07 15:24
buy
3.53
1.3017
1.3010
-24.71
17646.75
2007.02.08 13:39
buy
3.53
1.3011
1.3041
105.90
17752.65
2007.02.08 14:07
buy
3.53
1.3021
1.3041
70.60
17823.25
2007.02.08 14:24
buy
3.53
1.3031
1.3041
35.30
17858.55
2007.02.09 10:05
sell
3.57
1.2995
1.3000
-17.85
17840.70
2007.02.09 14:54
sell
3.57
1.2985
1.3000
-53.55
17787.15
Client ID: XXXXX Date open: 2007.03.01 Excalibur Reg # XXXXX
Deposit: 3000.00I new
Balance:17787.15
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.03.01 15:04
sell
3.56
1.3198
1.3189
32.04
17819.19
2007.03.01 15:07
sell
3.56
1.3188
1.3188
0.00
17819.19
2007.03.01 15:22
sell
3.56
1.3178
1.3188
-35.60
17783.59
2007.03.01 19:57
buy
3.56
1.3198
1.3186
-42.72
17740.87
2007.03.06 20:10
buy
3.55
1.3125
1.3127
7.10
17747.97
2007.03.08 13:30
buy
3.55
1.3165
1.3140
-88.75
17659.22
2007.03.08 14:09
sell
3.55
1.3129
1.3134
-17.75
17641.47
2007.03.08 14:15
sell
3.55
1.3119
1.3144
-88.75
17552.72
2007.03.09 13:34
sell
3.51
1.3126
1.3116
35.10
17587.82
2007.03.09 13:37
sell
3.51
1.3116
1.3116
0.00
17587.82
2007.03.09 13:37
sell
3.51
1.3106
1.3116
-35.10
17552.72
2007.03.13 11:15
buy
3.51
1.3185
1.3197
42.12
17594.84
2007.03.13 12:34
buy
3.51
1.3195
1.3197
7.02
17601.86
2007.03.13 12:39
buy
3.51
1.3205
1.3197
-28.08
17573.78
Client ID: XXXXX Date open: 2007.04.01 Excalibur Reg # XXXXX
Deposit: 3000.00I new
Balance:17573.78
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.04.05 13:01
buy
3.51
1.3390
1.3430
140.40
17714.18
2007.04.05 13:06
buy
3.51
1.3400
1.3430
105.30
17819.48
2007.04.05 13:10
buy
3.51
1.3410
1.3430
70.20
17889.68
2007.04.06 12:34
sell
3.58
1.3399
1.3372
96.66
17986.34
2007.04.06 12:37
sell
3.58
1.3389
1.3372
60.86
18047.20
2007.04.06 12:39
sell
3.58
1.3379
1.3372
25.06
18072.26
2007.04.12 09:00
sell
3.61
1.3444
1.3469
-90.25
17982.01
2007.04.12 13:52
buy
3.61
1.3482
1.3487
18.05
18000.06
2007.04.12 14:24
buy
3.61
1.3492
1.3486
-21.66
17978.84
2007.04.12 14:39
buy
3.61
1.3502
1.3477
-90.25
17887.90
2007.04.24 14:04
buy
3.58
1.3604
1.3639
125.30
18013.20
2007.04.24 14:08
buy
3.58
1.3614
1.3639
89.50
18102.70
2007.04.24 14:19
buy
3.58
1.3624
1.3639
53.70
18156.40
Client ID: XXXXX Date open: 2007.05.01 Excalibur Reg # XXXXX
Deposit: 3000.00I new
Balance:18156.40
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.05.01 14:06
sell
3.63
1.3648
1.3617
112.53
18268.93
2007.05.01 14:09
sell
3.63
1.3638
1.3617
76.23
18381.46
2007.05.01 14:22
sell
3.63
1.3628
1.3617
39.93
18421.39
2007.05.04 12:39
buy
3.68
1.3583
1.3586
11.04
18432.43
2007.05.04 12:49
buy
3.68
1.3593
1.3586
-25.76
18406.67
2007.05.04 13:34
buy
3.68
1.3603
1.3586
-62.56
18344.11
2007.05.10 09:24
sell
3.66
1.3521
1.3534
-47.58
18296.53
2007.05.10 12:52
sell
3.65
1.3510
1.3477
120.45
18416.98
2007.05.10 13:22
sell
3.65
1.3500
1.3477
83.95
18500.93
2007.05.10 11:30
buy
3.65
1.3572
1.3572
0.00
18500.93
2007.05.10 16:39
sell
3.65
1.3490
1.3477
47.45
18548.38
2007.05.29 14:22
sell
3.70
1.3489
1.3449
148.00
18696.38
2007.05.29 15:03
sell
3.70
1.3479
1.3449
111.00
18807.38
2007.05.29 17:30
sell
3.70
1.3469
1.3449
74.00
18881.38
Client ID: XXXXX Date open: 2007.06.01 Excalibur Reg # XXXXX
Deposit: 3000.00I new
Balance:18881.38
Time Type Size
Opened
Closed
Profit/Loss
Balance
2007.06.01 12:31
buy
3.77
1.3459
1.3434
-94.25
18787.13
2007.06.01 12:39
sell
3.77
1.3423
1.3428
-18.85
18768.28
2007.06.01 12:39
sell
3.77
1.3413
1.3428
-56.55
18711.73
2007.06.01 14:07
sell
3.74
1.3407
1.3432
-93.50
18618.23
2007.06.01 14:09
sell
3.74
1.3397
1.3422
-93.50
18524.73
2007.06.01 15:04
buy
3.74
1.3432
1.3407
26.18
18550.91
2007.06.01 15:24
buy
3.74
1.3442
1.3440
-7.48
18543.43
2007.06.06 12:46
sell
3.70
1.3496
1.3500
-14.80
18528.63
2007.06.06 15:54
sell
3.70
1.3486
1.3500
-51.80
18476.83
2007.06.07 14:46
sell
3.69
1.3452
1.3426
95.94
18572.77
2007.06.07 16:28
sell
3.69
1.3442
1.3426
59.04
18631.81
2007.06.07 16:45