1
1
Spot
OTHER
Bank
AMERICAS
98063673.2963549
1
2
68
Swap
LATAM
Bank
AMERICAS
92095496.6251977
1
3
111
Option
LATAM
Bank
AMERICAS
74601207.2795048
1
4
199
Metal
OTHER
Hedge Fund
AMERICAS
32732092.0634624
1
5
294
Outrights
G10
Real Money
EMEA
47219462.415872
1
6
315
Spot
LATAM
Bank
AMERICAS
70777456.6912632
1
7
323
Spot
LATAM
Hedge Fund
AMERICAS
88022499.9776014
1
8
403
Swap
OTHER
Real Money
AMERICAS
44565062.8202637
1
9
438
Metal
G10
Bank
EMEA
25134049.7363391
1
10
453
Spot
OTHER
Hedge Fund
EMEA
63451519.6201598
1
11
552
Spot
OTHER
Real Money
ASPAC
88573573.6270243
1
12
598
Outrights
G10
Bank
AMERICAS
57443741.2002105
1
13
668
Swap
G10
Bank
AMERICAS
77661745.9659599
1
14
719
Outrights
G10
Bank
EMEA
78962582.5947768
-1
15
736
Swap
G10
Hedge Fund
EMEA
61637944.7432494
-1
16
772
Option
LATAM
Real Money
ASPAC
61073920.6060166
-1
17
796
Swap
LATAM
Bank
AMERICAS
63712711.3384272
-1
18
889
Option
OTHER
Hedge Fund
AMERICAS
72462523.4096128
-1
19
962
Option
G10
Real Money
EMEA
5592521.98927644
-1
20
997
Metal
OTHER
Bank
EMEA
7540158.25773429
-1
21
1003
Spot
G10
Hedge Fund
ASPAC
47219462.415872
-1
22
1049
Spot
G10
Real Money
EMEA
70777456.6912632
1
23
1073
Outrights
G10
Bank
EMEA
88022499.9776014
1
24
1
Spot
G10
Hedge Fund
AMERICAS
44565062.8202637
1
25
68
Swap
G10
Real Money
AMERICAS
92095496.6251977
1
26
111
Option
G10
Bank
AMERICAS
74601207.2795048
1
27
719
Metal
LATAM
Hedge Fund
AMERICAS
32732092.0634624
1
28
736
Outrights
LATAM
Real Money
EMEA
47219462.415872
1
29
772
Spot
OTHER
Bank
AMERICAS
70777456.6912632
1
30
796
Spot
G10
Hedge Fund
AMERICAS
88022499.9776014
1
31
889
Swap
OTHER
Real Money
AMERICAS
44565062.8202637
1
32
962
Spot
G10
Bank
AMERICAS
25134049.7363391
1
33
997
Swap
G10
Hedge Fund
EMEA
63451519.6201598
1
34
1003
Metal
G10
Real Money
AMERICAS
88573573.6270243
1
35
598
Spot
OTHER
Bank
AMERICAS
57443741.2002105
1
36
668
Spot
LATAM
Real Money
AMERICAS
72462523.4096128
-1
37
719
Outrights
LATAM
Bank
EMEA
5592521.98927644
-1
38
736
Swap
G10
Hedge Fund
AMERICAS
7540158.25773429
1
39
199
Outrights
LATAM
Real Money
AMERICAS
47219462.415872
1
40
294
Option
LATAM
Bank
EMEA
70777456.6912632
1
41
315
Metal
OTHER
Hedge Fund
EMEA
88022499.9776014
1
42
323
Option
G10
Real Money
ASPAC
44565062.8202637
1
43
403
Metal
OTHER
Bank
EMEA
92095496.6251977
1
44
438
Outrights
G10
Hedge Fund
EMEA
74601207.2795048
1
45
453
Spot
G10
Bank
AMERICAS
32732092.0634624
1
46
1073
Swap
G10
Hedge Fund
EMEA
47219462.415872
1
47
323
Spot
G10
Real Money
EMEA
96597040.8492812
1
48
199
Swap
G10
Bank
EMEA
80755383.136124
1
49
294
Metal
G10
Real Money
ASPAC
84504181.1718547
1
50
315
Spot
G10
Bank
AMERICAS
88252979.2075853
1
51
323
Metal
LATAM
Hedge Fund
AMERICAS
92001777.243316
1
52
403
Spot
LATAM
Real Money
EMEA
95750575.2790467
1
53
438
Spot
OTHER
Bank
EMEA
99499373.3147774
1
54
453
Outrights
G10
Bank
ASPAC
103248171.350508
1
55
552
Swap
OTHER
Hedge Fund
AMERICAS
106996969.386239
1
56
598
Outrights
G10
Real Money
AMERICAS
110745767.421969
-1
57
668
Swap
G10
Bank
EMEA
114494565.4577
-1
58
719
Swap
G10
Hedge Fund
EMEA
118243363.493431
-1
59
736
Metal
G10
Real Money
ASPAC
121992161.529161
-1
60
719
Spot
G10
Bank
AMERICAS
125740959.564892
-1
61
736
Spot
LATAM
Hedge Fund
AMERICAS
129489757.600623
-1
62
772
Metal
LATAM
Real Money
EMEA
133238555.636354
-1
63
796
Outrights
OTHER
Bank
EMEA
136987353.672084
-1
64
889
Spot
G10
Hedge Fund
ASPAC
140736151.707815
1
65
962
Spot
OTHER
Bank
AMERICAS
144484949.743545
1
66
997
Swap
G10
Hedge Fund
AMERICAS
148233747.779276
1
67
962
Metal
G10
Real Money
EMEA
151982545.815007
1
68
997
Spot
G10
Bank
AMERICAS
155731343.850737
1
69
1003
Spot
G10
Real Money
EMEA
159480141.886468
1
70
1049
Outrights
LATAM
Bank
AMERICAS
163228939.922199
1
71
1073
Swap
LATAM
Hedge Fund
AMERICAS
166977737.957929
1
72
1
Swap
OTHER
Real Money
AMERICAS
170726535.99366
1
73
403
Metal
G10
Bank
EMEA
174475334.029391
1
74
438
Spot
OTHER
Bank
EMEA
178224132.065121
1
75
453
Spot
G10
Hedge Fund
EMEA
181972930.100852
1
76
1073
Outrights
G10
Real Money
ASPAC
185721728.136583
1
77
323
Swap
G10
Bank
AMERICAS
74601207.2795048
1
78
199
Swap
OTHER
Hedge Fund
AMERICAS
32732092.0634624
1
79
294
Option
LATAM
Hedge Fund
EMEA
47219462.415872
1
80
315
Metal
OTHER
Real Money
EMEA
70777456.6912632
1
81
719
Outrights
G10
Bank
ASPAC
47219462.415872
1
82
736
Spot
OTHER
Real Money
EMEA
70777456.6912632
1
83
772
Spot
G10
Bank
EMEA
88022499.9776014
-1
84
796
Swap
G10
Hedge Fund
ASPAC
44565062.8202637
1
85
889
Metal
G11
Hedge Fund
EMEA
445445062.820263
Data
AMERICAS
1
EMEA
2
ASPAC
3
All
0
Region Reference
Spot
1
Swap
2
Option
3
Metal
4
Outrights
5
All
0
less than 20
Product Group Reference
Output_Name = "Region"+tostring([Region Key])+"_"+"Product"+tostring([Product Ke...
.\output.csv
CRLF
,
False
True
28591
True
FileName
Output_Name
output.csv
Horizontal
challenge_38_RN