End of File
18 records are only in our position file and not in eod file for date 2024-10-01
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 @APACO1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.2e-03 -1000 0 -1000 5.3e-02 1.9e-02 0.0 0.0 0.0 0.0 0.0 -2.0e-01 2.0e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 3.2
1 @BORAP2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 5.2e-01 0 0 0 -3.0e-03 -2.3e-03 0.0 -0.0 0.0 0.0 0.0 -1.2e-01 1.2e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 -0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 23.5
2 @CHANG120 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 5.4e-02 -200 0 -200 -1.7e-03 4.1e-02 0.0 -0.0 0.0 0.0 0.0 -3.3e-01 3.3e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 10.1
3 @CUORI1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 8.9e-02 -100 0 -100 4.0e-04 -1.4e-02 0.0 0.0 0.0 0.0 0.0 -3.7e-01 3.7e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 64.3
4 @FOSIT1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.1e-01 0 0 0 1.5e-02 7.4e-03 0.0 0.0 0.0 0.0 0.0 -7.7e-01 7.7e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 26.6
5 @GALLA19 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 2.5e-02 0 0 0 1.2e-02 8.9e-03 0.0 0.0 0.0 0.0 0.0 -1.1e-01 1.1e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 28.6
6 @HDREN1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 6.1e-02 0 0 0 1.8e-02 -1.2e-02 0.0 0.0 0.0 0.0 0.0 -2.5e-01 2.5e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 8.3
7 @ISECH1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 2.4e-02 0 0 0 1.5e-01 3.0e-03 0.0 0.0 0.0 0.0 0.0 -1.4e+00 1.4e+00 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 155.6
8 @JVENE1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.0e-01 0 0 0 -8.3e-03 -2.1e-02 0.0 -0.0 0.0 0.0 0.0 -3.4e-01 3.4e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 -0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 7.3
9 @KEYEN4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.0e+00 0 0 0 1.6e-02 -5.7e-04 0.0 0.0 0.0 0.0 0.0 -3.0e+00 3.0e+00 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 483.2
10 @LANDM16 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 5.8e-02 0 0 0 7.2e-02 2.6e-02 0.0 0.0 0.0 0.0 0.0 -2.2e+00 2.2e+00 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 10.2
11 @MEDIA42 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.0e+00 0 0 0 2.9e-02 5.1e-04 0.0 0.0 0.0 0.0 0.0 -2.8e+00 2.8e+00 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 38.1
12 @NPCIN1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 -4.6e-04 -4.6e-04 1.0 1.3e-01 -1500 0 -1500 1.2e-02 -2.8e-03 0.0 0.0 0.0 0.0 0.0 -9.5e-02 9.5e-02 -4.6e-04 -4.6e-04 -10409.2 -4.6e-04 1.3 6.1 7.4 -10409.2 -4.6e-04 29.1 -10380.1 -5.2e-13 29.1 -5.2e-13 21.6 -4.6e-04 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 6.9
13 @PHOEN55 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 2.6e-02 0 0 0 1.7e-03 -5.6e-03 0.0 0.0 0.0 0.0 0.0 -1.9e-01 1.9e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 3.9
14 @SUNWE2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 2.2e-01 -300 0 -300 -2.4e-02 -9.4e-03 0.0 -0.0 0.0 0.0 0.0 -1.6e-01 1.6e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 -0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 10.9
15 @TOYOS3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 1.0e+00 0 0 0 1.4e-02 -5.2e-05 0.0 0.0 0.0 0.0 0.0 -2.8e-01 2.8e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 -0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 66.0
16 @WORKM1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 6.5e-01 0 0 0 -2.4e-02 1.7e-03 0.0 -0.0 0.0 0.0 0.0 -1.0e-01 1.0e-01 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 30.4
17 @ZILLT1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0e+00 0.0e+00 1.0 2.3e-02 0 0 0 -3.0e-03 6.0e-03 0.0 -0.0 0.0 0.0 0.0 -1.7e-02 1.7e-02 0.0e+00 0.0e+00 0.0 0.0e+00 0.0 0.0 0.0 0.0 0.0e+00 0.0 0.0 0.0e+00 0.0 0.0e+00 0.0 0.0e+00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN left_only 10.6