forked from robcarver17/reports
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDuplicate_markets_report
405 lines (273 loc) · 31.2 KB
/
Duplicate_markets_report
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
********************************************************************************
Duplicate markets report report produced on 2022-11-14 21:21:31.648957
********************************************************************************
List of duplicate markets eg mini and micro, or dual listing; recommendations as to which to trade
** CHANGE ** Replace CORN_mini with CORN Current list of included markets ['CORN_mini'], excluded markets ['CORN'] Best market CORN, current included market(s) ['CORN_mini']
** CHANGE ** Replace EU-DJ-UTIL with EU-UTILS Current list of included markets ['EU-DJ-UTIL'], excluded markets ['EU-UTILS'] Best market EU-UTILS, current included market(s) ['EU-DJ-UTIL']
** CHANGE ** Replace JPY with JPY_mini Current list of included markets ['JPY'], excluded markets ['JPY-SGX-TITAN', 'JPY-SGX', 'JPY_mini'] Best market JPY_mini, current included market(s) ['JPY']
** CHANGE ** Replace CAD_micro with CAD Current list of included markets ['CAD_micro'], excluded markets ['CAD'] Best market CAD, current included market(s) ['CAD_micro']
** CHANGE ** Replace CHF_micro with CHF Current list of included markets ['CHF_micro'], excluded markets ['CHF'] Best market CHF, current included market(s) ['CHF_micro']
** CHANGE ** Replace VIX with VIX_mini Current list of included markets ['VIX'], excluded markets ['VIX_mini'] Best market VIX_mini, current included market(s) ['VIX']
==============================================================================================================================================================================
** CHANGE ** Replace CORN_mini with CORN Current list of included markets ['CORN_mini'], excluded markets ['CORN'] Best market CORN, current included market(s) ['CORN_mini']
==============================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
CORN_mini 0.006998 808.0 0.88 1086.0
CORN 0.003624 68733.0 361.58 5261.0
======================================================================================================================================================================
No change required Current list of included markets ['GASOILINE'], excluded markets ['GASOILINE_mini'] Best market GASOILINE, current included market(s) ['GASOILINE']
======================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
GASOILINE_mini NaN NaN NaN NaN
GASOILINE 0.00197 13950.0 437.28 31346.0
========================================================================================================================================================================================
No change - no good markets Current list of included markets ['EU-FINANCE'], excluded markets ['EU-DJ-FINANCE'] Best market <No good markets>, current included market(s) ['EU-FINANCE']
========================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-FINANCE NaN NaN NaN NaN
EU-DJ-FINANCE NaN NaN NaN NaN
=============================================================================================================================================================================================
** CHANGE ** Replace EU-DJ-UTIL with EU-UTILS Current list of included markets ['EU-DJ-UTIL'], excluded markets ['EU-UTILS'] Best market EU-UTILS, current included market(s) ['EU-DJ-UTIL']
=============================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-UTILS 0.004985 476.0 1.61 3378.0
EU-DJ-UTIL 0.006180 424.0 1.30 3073.0
================================================================================================================================================================
No change required Current list of included markets ['KOSPI_mini'], excluded markets ['KOSPI'] Best market KOSPI_mini, current included market(s) ['KOSPI_mini']
================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
KOSPI_mini 0.006236 6521.0 13.06 2003.0
KOSPI 0.004676 270201.0 2867.59 10613.0
================================================================================================================================================================================
No change required Current list of included markets ['JGB-SGX-mini'], excluded markets ['JGB_mini', 'JGB'] Best market JGB-SGX-mini, current included market(s) ['JGB-SGX-mini']
================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
JGB 0.003039 18550.0 408.87 22042.0
JGB_mini NaN NaN NaN NaN
JGB-SGX-mini 0.006129 1444.0 3.10 2148.0
==========================================================================================================================================================================
No change required Current list of included markets ['COPPER'], excluded markets ['COPPER-mini', 'COPPER_micro'] Best market COPPER, current included market(s) ['COPPER']
==========================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
COPPER-mini 0.007802 59.0 0.77 13116.0
COPPER_micro NaN NaN NaN NaN
COPPER 0.000777 29394.0 819.99 27896.0
====================================================================================================================================================================
No change required Current list of included markets ['GAS_US_mini'], excluded markets ['GAS_US'] Best market GAS_US_mini, current included market(s) ['GAS_US_mini']
====================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
GAS_US 0.000913 45835.0 1705.98 37220.0
GAS_US_mini 0.002348 4690.0 44.24 9432.0
===================================================================================================================================================================
No change required Current list of included markets ['SP500_micro'], excluded markets ['SP500'] Best market SP500_micro, current included market(s) ['SP500_micro']
===================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
SP500_micro 0.000442 1299015.0 6067.12 4671.0
SP500 0.000298 1697503.0 79250.32 46686.0
================================================================================================================================================================================
No change - no good markets Current list of included markets ['INR'], excluded markets ['INR-mini', 'INR-SGX'] Best market <No good markets>, current included market(s) ['INR']
================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
INR 0.004892 374.0 1.27 3401.0
INR-SGX NaN NaN NaN NaN
INR-mini NaN NaN NaN NaN
============================================================================================================================================================================
No change required Current list of included markets ['GOLD_micro'], excluded markets ['GOLD', 'GOLD_mini'] Best market GOLD_micro, current included market(s) ['GOLD_micro']
============================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
GOLD_mini NaN NaN NaN NaN
GOLD 0.000544 89716.0 2488.8 27741.0
GOLD_micro 0.000991 20666.0 57.0 2758.0
==============================================================================================================================================
No change required Current list of included markets ['DOW'], excluded markets ['DOW_mini'] Best market DOW, current included market(s) ['DOW']
==============================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
DOW 0.000557 115212.0 351.99 3055.0
DOW_mini 0.000261 160466.0 4905.44 30570.0
================================================================================================================================================================
No change required Current list of included markets ['ETHEREUM'], excluded markets ['ETHER-micro'] Best market ETHEREUM, current included market(s) ['ETHEREUM']
================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
ETHEREUM 0.001108 4012.0 299.60 74685.0
ETHER-micro 0.010071 11412.0 1.76 154.0
====================================================================================================================================================================================================
** CHANGE ** Replace JPY with JPY_mini Current list of included markets ['JPY'], excluded markets ['JPY-SGX-TITAN', 'JPY-SGX', 'JPY_mini'] Best market JPY_mini, current included market(s) ['JPY']
====================================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
JPY_mini 0.007182 436.0 2.51 5748.0
JPY 0.000797 73757.0 845.74 11466.0
JPY-SGX NaN NaN NaN NaN
JPY-SGX-TITAN NaN NaN NaN NaN
=======================================================================================================================================================================
No change required Current list of included markets ['NASDAQ_micro'], excluded markets ['NASDAQ'] Best market NASDAQ_micro, current included market(s) ['NASDAQ_micro']
=======================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
NASDAQ 0.000184 542599.0 40291.77 74257.0
NASDAQ_micro 0.000213 1002521.0 7449.98 7431.0
==============================================================================================================================================
No change required Current list of included markets ['AEX'], excluded markets ['AEX_mini'] Best market AEX, current included market(s) ['AEX']
==============================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
AEX 0.001146 19439.0 459.64 23646.0
AEX_mini 0.033935 12.0 0.03 2493.0
==============================================================================================================================================================
No change required Current list of included markets ['RUSSELL'], excluded markets ['RUSSELL_mini'] Best market RUSSELL, current included market(s) ['RUSSELL']
==============================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
RUSSELL 0.000732 87583.0 222.18 2537.0
RUSSELL_mini 0.000363 194482.0 4922.35 25310.0
====================================================================================================================================================================
No change required Current list of included markets ['KRWUSD_mini'], excluded markets ['KRWUSD'] Best market KRWUSD_mini, current included market(s) ['KRWUSD_mini']
====================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
KRWUSD_mini 0.005027 4363.0 10.36 2374.0
KRWUSD 0.020590 6.0 0.06 9849.0
==================================================================================================================================================================================
No change - no good markets Current list of included markets ['EU-MEDIA'], excluded markets ['EU-DJ-MEDIA'] Best market <No good markets>, current included market(s) ['EU-MEDIA']
==================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-DJ-MEDIA NaN NaN NaN NaN
EU-MEDIA 0.005236 101.0 0.3 2972.0
====================================================================================================================================================================
No change required Current list of included markets ['EU-INSURE'], excluded markets ['EU-DJ-INSURE'] Best market EU-INSURE, current included market(s) ['EU-INSURE']
====================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-INSURE 0.006675 935.0 2.05 2194.0
EU-DJ-INSURE NaN NaN NaN NaN
=================================================================================================================================================
No change required Current list of included markets ['CNH'], excluded markets ['CNH-onshore'] Best market CNH, current included market(s) ['CNH']
=================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
CNH-onshore 0.019333 1.0 0.01 6273.0
CNH 0.001256 76970.0 548.82 7130.0
=========================================================================================================================================================
No change required Current list of included markets ['NIKKEI'], excluded markets ['NIKKEI-JPY'] Best market NIKKEI, current included market(s) ['NIKKEI']
=========================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
NIKKEI-JPY NaN NaN NaN NaN
NIKKEI 0.001203 721285.0 2139.55 2966.0
===============================================================================================================================================================================
No change - no good markets Current list of included markets ['EU-FOOD'], excluded markets ['EU-DJ-FOOD'] Best market <No good markets>, current included market(s) ['EU-FOOD']
===============================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-DJ-FOOD NaN NaN NaN NaN
EU-FOOD 0.004554 147.0 0.78 5291.0
===========================================================================================================================================================================
** CHANGE ** Replace CAD_micro with CAD Current list of included markets ['CAD_micro'], excluded markets ['CAD'] Best market CAD, current included market(s) ['CAD_micro']
===========================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
CAD 0.001362 49068.0 327.48 6674.0
CAD_micro 0.003387 1763.0 1.18 667.0
========================================================================================================================================================
No change required Current list of included markets ['EU-OIL'], excluded markets ['EU-DJ-OIL'] Best market EU-OIL, current included market(s) ['EU-OIL']
========================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-DJ-OIL 0.009759 143.0 0.44 3060.0
EU-OIL 0.005265 7178.0 24.09 3356.0
==========================================================================================================================================================
No change required Current list of included markets ['SILVER'], excluded markets ['SILVER_mini'] Best market SILVER, current included market(s) ['SILVER']
==========================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
SILVER 0.001345 3413.0 22.57 6612.0
SILVER_mini NaN NaN NaN NaN
=====================================================================================================================================================================
No change - no good markets Current list of included markets ['TWD'], excluded markets ['TWD-mini'] Best market <No good markets>, current included market(s) ['TWD']
=====================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
TWD-mini 0.015041 15.0 0.03 1796.0
TWD 0.005677 40.0 0.35 8671.0
================================================================================================================================================================
No change required Current list of included markets ['WHEAT_mini'], excluded markets ['WHEAT'] Best market WHEAT_mini, current included market(s) ['WHEAT_mini']
================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
WHEAT 0.003306 27568.0 303.65 11014.0
WHEAT_mini 0.004120 710.0 2.03 2860.0
===========================================================================================================================================================================
** CHANGE ** Replace CHF_micro with CHF Current list of included markets ['CHF_micro'], excluded markets ['CHF'] Best market CHF, current included market(s) ['CHF_micro']
===========================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
CHF 0.000990 10666.0 161.22 15116.0
CHF_micro 0.001861 326.0 0.49 1507.0
===============================================================================================================================================================================
No change - no good markets Current list of included markets ['EU-CHEM'], excluded markets ['EU-DJ-CHEM'] Best market <No good markets>, current included market(s) ['EU-CHEM']
===============================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-DJ-CHEM NaN NaN NaN NaN
EU-CHEM 0.0038 86.0 0.89 10330.0
========================================================================================================================================================================
No change required Current list of included markets ['SOYBEAN_mini'], excluded markets ['SOYBEAN'] Best market SOYBEAN_mini, current included market(s) ['SOYBEAN_mini']
========================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
SOYBEAN 0.002745 43275.0 428.21 9895.0
SOYBEAN_mini 0.004417 939.0 2.42 2582.0
=============================================================================================================================================
No change required Current list of included markets ['AUD'], excluded markets ['AUD-SGX'] Best market AUD, current included market(s) ['AUD']
=============================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
AUD-SGX NaN NaN NaN NaN
AUD 0.000964 44547.0 434.5 9754.0
========================================================================================================================================================================
** CHANGE ** Replace VIX with VIX_mini Current list of included markets ['VIX'], excluded markets ['VIX_mini'] Best market VIX_mini, current included market(s) ['VIX']
========================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
VIX_mini 0.009639 2595.0 2.18 839.0
VIX 0.005813 47532.0 361.33 7602.0
=======================================================================================================================================================================
No change required Current list of included markets ['EUR_micro'], excluded markets ['EUR', 'EUR_mini'] Best market EUR_micro, current included market(s) ['EUR_micro']
=======================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EUR_micro 0.002272 17007.0 24.54 1443.0
EUR_mini 0.001506 3510.0 25.36 7225.0
EUR 0.000698 101388.0 1460.38 14404.0
==============================================================================================================================================================
No change required Current list of included markets ['HEATOIL'], excluded markets ['HEATOIL_mini'] Best market HEATOIL, current included market(s) ['HEATOIL']
==============================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
HEATOIL_mini NaN NaN NaN NaN
HEATOIL 0.001788 14488.0 575.06 39691.0
=====================================================================================================================================================================================
No change - no good markets Current list of included markets ['EU-RETAIL'], excluded markets ['EU-DJ-RETAIL'] Best market <No good markets>, current included market(s) ['EU-RETAIL']
=====================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-DJ-RETAIL NaN NaN NaN NaN
EU-RETAIL 0.003597 90.0 0.37 4124.0
============================================================================================================================================================
No change required Current list of included markets ['EU-TECH'], excluded markets ['EU-DJ-TECH'] Best market EU-TECH, current included market(s) ['EU-TECH']
============================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-TECH 0.002904 700.0 6.39 9116.0
EU-DJ-TECH 0.004378 366.0 4.26 11631.0
===========================================================================================================================================================
No change required Current list of included markets ['GBP_micro'], excluded markets ['GBP'] Best market GBP_micro, current included market(s) ['GBP_micro']
===========================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
GBP 0.000896 57025.0 646.17 11331.0
GBP_micro 0.002017 2617.0 2.96 1132.0
=================================================================================================================================================================================================
No change required Current list of included markets ['CRUDE_W_micro'], excluded markets ['CRUDE_W_mini', 'CRUDE_W_micro'] Best market CRUDE_W_micro, current included market(s) ['CRUDE_W_micro']
=================================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
CRUDE_W_micro 0.001544 41517.0 117.58 2832.0
CRUDE_W_mini 0.002159 8673.0 124.48 14353.0
==============================================================================================================================================
No change required Current list of included markets ['SGD'], excluded markets ['SGD_mini'] Best market SGD, current included market(s) ['SGD']
==============================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
SGD_mini 0.005357 183.0 0.29 1562.0
SGD 0.003840 550.0 3.11 5654.0
===========================================================================================================================================================================================================
No change - no good markets Current list of included markets ['thing_we_want'], excluded markets ['bad_thing', 'Another_thing'] Best market <No good markets>, current included market(s) ['thing_we_want']
===========================================================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
thing_we_want NaN NaN NaN NaN
Another_thing NaN NaN NaN NaN
bad_thing NaN NaN NaN NaN
====================================================================================================================================================================
No change required Current list of included markets ['EU-HEALTH'], excluded markets ['EU-DJ-HEALTH'] Best market EU-HEALTH, current included market(s) ['EU-HEALTH']
====================================================================================================================================================================
SR_cost volume_contracts volume_risk contract_size
EU-HEALTH 0.004093 487.0 3.64 7480.0
EU-DJ-HEALTH NaN NaN NaN NaN
********************************************************************************
END OF REPORT
********************************************************************************