End of File
36 records are only in our position file and not in eod file for date 2024-09-27
assetKey bodValUSD bodWeights fcost fcostUSD bcost bcostUSD preOptWeights postOptWeights optTradeWeights longBoundHard shortBoundHard trade_qty preOptQty target_contracts cvret vcret fxretd preTradePnLHoldUSD preTradeValUSD preTradePnLFxUSD preTradeWeights tradeBoundLo tradeBoundHi execWeights postExecWeights tradeValUSD tradeWeights linearCostUSD impactCostUSD tcostUSD postTradeValUSD postTradeWeights postTradePnLHoldUSD eodValUSD postTradePnLFxUSD pnlHoldUSD pnlFxUSD totalPnLUSD eodWeights ric position quantity_bought avg_buy_price_lccy avg_buy_price_pccy quantity_sold avg_sell_price_lccy avg_sell_price_pccy totalpl modifiedRic _merge priceCloseUSD
0 @BORAP2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 5.6e-01 0 0 0 1.6e-02 -6.6e-03 0.0 0.0 0.0 0.0 0.0 -5.2e-01 5.2e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 23.9
1 @CHINA1492 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e-06 1600 0 1600 2.9e-02 8.3e-03 0.0 0.0 0.0 0.0 0.0 -1.8e-01 1.8e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 2.5
2 @CUORI1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 3.0e-01 -100 0 -100 6.0e-02 2.7e-02 0.0 0.0 0.0 0.0 0.0 -9.7e-01 9.7e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 68.6
3 @DEXER1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 4.3e-02 3.9e-03 0.0 0.0 0.0 0.0 0.0 -2.8e-01 2.8e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 15.0
4 @DRONE3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 -5067 0 -5067 -3.8e-03 1.1e-02 0.0 -0.0 0.0 0.0 0.0 -1.7e-01 1.7e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 0.9
5 @FUJIS12 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -1.1e-02 2.0e-03 0.0 -0.0 0.0 0.0 0.0 -6.1e-01 6.1e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 62.2
6 @GNILT1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 5.1e-01 0 0 0 2.6e-02 1.4e-02 0.0 0.0 0.0 0.0 0.0 -8.2e-01 8.2e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 20.6
7 @GUNGH1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -4.0e-03 -2.7e-03 0.0 -0.0 0.0 0.0 0.0 -6.5e-02 6.5e-02 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 21.7
8 @HDREN1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 8.7e-02 0 0 0 -4.9e-03 6.7e-03 0.0 -0.0 0.0 0.0 0.0 -7.1e-01 7.1e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 8.7
9 @HENGY1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 2.6e-04 -2900 0 -2900 1.6e-02 9.0e-03 0.0 0.0 0.0 0.0 0.0 -6.2e-01 6.2e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 1.3
10 @HIKAR2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -1.6e-02 2.6e-03 0.0 -0.0 0.0 0.0 0.0 -3.6e-01 3.6e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 225.3
11 @HIROS5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.7e-02 6.2e-03 0.0 0.0 0.0 0.0 0.0 -2.9e-01 2.9e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 132.1
12 @HITAC26 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.8e-03 8.5e-03 0.0 0.0 0.0 0.0 0.0 -9.7e+00 9.7e+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 27.8
13 @HOYMI1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 3.4e-02 100 0 100 6.9e-02 4.7e-02 0.0 0.0 0.0 0.0 0.0 -6.7e-01 6.7e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 19.8
14 @ISECH1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 2.1e-02 0 0 0 2.8e-02 6.2e-03 0.0 0.0 0.0 0.0 0.0 -4.6e-01 4.6e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 143.0
15 @JINCO1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 8.7e-03 8.4e-03 0.0 0.0 0.0 0.0 0.0 -6.2e-02 6.2e-02 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 36.9
16 @JVENE1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.2e-01 0 0 0 6.1e-03 4.5e-03 0.0 0.0 0.0 0.0 0.0 -8.2e-01 8.2e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 7.5
17 @KINKI3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.2e-02 7.8e-03 0.0 0.0 0.0 0.0 0.0 -8.8e-01 8.8e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 25.0
18 @KOKUS12 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -8.3e-03 -1.0e-02 0.0 -0.0 0.0 0.0 0.0 -2.3e+00 2.3e+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 23.5
19 @KONAM10 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.2e-02 5.7e-03 0.0 0.0 0.0 0.0 0.0 -1.3e+00 1.3e+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 105.5
20 @KURIT2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.2e-02 4.9e-03 0.0 0.0 0.0 0.0 0.0 -3.4e-01 3.4e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 43.6
21 @KYUDE1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -1.3e-03 7.1e-04 0.0 -0.0 0.0 0.0 0.0 -1.2e-01 1.2e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 47.4
22 @NIFCO1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.8e-02 6.5e-03 0.0 0.0 0.0 0.0 0.0 -1.5e-01 1.5e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 26.2
23 @NITOR1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 1.0e-03 6.5e-03 0.0 0.0 0.0 0.0 0.0 -3.1e+00 3.1e+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 149.0
24 @NOMUR26 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 2.0e-02 1.1e-02 0.0 0.0 0.0 0.0 0.0 -4.4e-01 4.4e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 28.3
25 @NPCIN1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.6e-01 -400 0 -400 3.3e-02 7.2e-03 0.0 0.0 0.0 0.0 0.0 -2.0e-01 2.0e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 7.2
26 @QUANT100 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.1e-04 0 0 0 4.0e-02 3.1e-02 0.0 0.0 0.0 0.0 0.0 -4.7e-01 4.7e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 24.7
27 @SANBI3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 3.1e-01 -500 0 -500 1.4e-02 -1.4e-02 0.0 0.0 0.0 0.0 0.0 -3.6e-01 3.6e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 8.2
28 @SANKE4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 -100 0 -100 2.1e-02 1.5e-03 0.0 0.0 0.0 0.0 0.0 -2.0e-01 2.0e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 46.7
29 @SHIMA9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 7.6e-03 1.4e-03 0.0 0.0 0.0 0.0 0.0 -5.9e-01 5.9e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 33.8
30 @SUMIT43 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 3.8e-02 1.4e-02 0.0 0.0 0.0 0.0 0.0 -1.2e+00 1.2e+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 36.1
31 @SUNWE2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 3.3e-01 -100 0 -100 3.1e-03 2.7e-03 0.0 0.0 0.0 0.0 0.0 -2.4e-01 2.4e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 11.9
32 @TOHOP1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 -2.3e-02 3.1e-03 0.0 -0.0 0.0 0.0 0.0 -2.4e-01 2.4e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 32.1
33 @TOKYO29 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e+00 0 0 0 7.4e-03 2.3e-03 0.0 0.0 0.0 0.0 0.0 -2.1e-01 2.1e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 28.5
34 @ZHEJI297 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 1.0e-06 100 0 100 5.2e-03 2.1e-02 0.0 0.0 0.0 0.0 0.0 -6.3e-01 6.3e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 21.5
35 @ZILLT1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 5.6e-02 0 0 0 5.8e-03 -1.4e-02 0.0 0.0 0.0 0.0 0.0 -1.4e-01 1.4e-01 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -0.0 0.0 0.0 0.0 0.0 0.0 0.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 10.8