End of File
14 records are only in our position file and not in eod file for date 2024-09-30
|
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.0e+00 |
0.0e+00 |
1.0 |
5.2e-01 |
0 |
0 |
0 |
-4.9e-03 |
-4.3e-03 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-2.2e-01 |
2.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.7 |
| 1 |
@CUORI1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0e+00 |
0.0e+00 |
1.0 |
1.2e-01 |
-100 |
0 |
-100 |
-3.7e-02 |
-2.2e-02 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-4.2e-01 |
4.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 |
65.8 |
| 2 |
@DISCO14 |
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 |
-6.3e-02 |
-1.7e-02 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-1.8e+01 |
1.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 |
263.7 |
| 3 |
@FUJIS12 |
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.7e-03 |
4.9e-03 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-2.4e-01 |
2.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 |
63.4 |
| 4 |
@ISECH1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0e+00 |
0.0e+00 |
1.0 |
3.1e-02 |
0 |
0 |
0 |
-4.5e-02 |
-1.7e-02 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-2.1e-01 |
2.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 |
136.6 |
| 5 |
@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 |
-3.2e-02 |
-6.4e-03 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-4.5e+00 |
4.5e+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 |
480.7 |
| 6 |
@KOBED1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0e+00 |
0.0e+00 |
1.0 |
3.6e-03 |
-100 |
0 |
-100 |
-6.2e-02 |
-8.8e-03 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-5.7e-02 |
5.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 |
29.7 |
| 7 |
@KYUSH10 |
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 |
-9.3e-03 |
4.0e-03 |
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 |
29.1 |
| 8 |
@LOONG1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-7.6e-04 |
-7.6e-04 |
1.0 |
2.2e-03 |
-1200 |
0 |
-1200 |
1.4e-01 |
5.3e-02 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-1.5e+00 |
1.5e+00 |
-7.6e-04 |
-7.6e-04 |
-19450.8 |
-8.6e-04 |
26.4 |
6.6 |
33.0 |
-19450.8 |
-8.6e-04 |
-1023.2 |
-20474.0 |
1.0e-12 |
-1023.2 |
1.0e-12 |
-1056.2 |
-9.2e-04 |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
left_only |
17.1 |
| 9 |
@NITOR1 |
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.9e-02 |
-9.1e-03 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-2.4e+00 |
2.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 |
153.3 |
| 10 |
@NPCIN1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0e+00 |
0.0e+00 |
1.0 |
1.4e-01 |
-900 |
0 |
-900 |
-4.6e-02 |
-1.7e-02 |
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 |
6.9 |
| 11 |
@SHINE6 |
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 |
-5.6e-02 |
-1.4e-03 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-4.5e+00 |
4.5e+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 |
42.0 |
| 12 |
@SUNWE2 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0e+00 |
0.0e+00 |
1.0 |
2.4e-01 |
-200 |
0 |
-200 |
-3.4e-02 |
-2.8e-02 |
0.0 |
-0.0 |
0.0 |
0.0 |
0.0 |
-1.7e-01 |
1.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 |
11.4 |
| 13 |
@TENCE1 |
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.8e-02 |
-2.7e-03 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
-4.8e+01 |
4.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 |
57.2 |