End of File
5 records are only in our position file and not in eod file for date 2024-10-04
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 @CUORI1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 2.1e-01 0 0 0 5.2e-03 -1.3e-02 0.0 0.0 0.0 0.0 0.0 -0.2 0.2 0.0 0.0 0.0 0.0 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 59.7
1 @FASTR4 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.4e-02 1.2e-03 0.0 0.0 0.0 0.0 0.0 -5.4 5.4 0.0 0.0 0.0 0.0 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 334.9
2 @FOSIT1 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 1.7e-02 1.1e-02 0.0 0.0 0.0 0.0 0.0 -1.3 1.3 0.0 0.0 0.0 0.0 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.1
3 @ISECH1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 3.7e-02 0 0 0 -2.3e-02 -1.0e-02 0.0 -0.0 0.0 0.0 0.0 -0.2 0.2 0.0 0.0 0.0 0.0 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 145.4
4 @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 -2.0e-02 -1.0e-02 0.0 -0.0 0.0 0.0 0.0 -1.1 1.1 0.0 0.0 0.0 0.0 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 93.1