14 records deleted from our previous date position file<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th>assetKey</th>
      <th>bodValUSD</th>
      <th>bodWeights</th>
      <th>fcost</th>
      <th>fcostUSD</th>
      <th>bcost</th>
      <th>bcostUSD</th>
      <th>preOptWeights</th>
      <th>postOptWeights</th>
      <th>optTradeWeights</th>
      <th>longBoundHard</th>
      <th>shortBoundHard</th>
      <th>trade_qty</th>
      <th>preOptQty</th>
      <th>target_contracts</th>
      <th>cvret</th>
      <th>vcret</th>
      <th>fxretd</th>
      <th>preTradePnLHoldUSD</th>
      <th>preTradeValUSD</th>
      <th>preTradePnLFxUSD</th>
      <th>preTradeWeights</th>
      <th>tradeBoundLo</th>
      <th>tradeBoundHi</th>
      <th>execWeights</th>
      <th>postExecWeights</th>
      <th>tradeValUSD</th>
      <th>tradeWeights</th>
      <th>linearCostUSD</th>
      <th>impactCostUSD</th>
      <th>tcostUSD</th>
      <th>postTradeValUSD</th>
      <th>postTradeWeights</th>
      <th>postTradePnLHoldUSD</th>
      <th>eodValUSD</th>
      <th>postTradePnLFxUSD</th>
      <th>pnlHoldUSD</th>
      <th>pnlFxUSD</th>
      <th>totalPnLUSD</th>
      <th>eodWeights</th>
      <th>ric</th>
      <th>position</th>
      <th>modifiedRic</th>
      <th>_merge</th>
      <th>priceCloseUSD</th>
      <th>numGQRShares</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>@ANHUI35</td>
      <td>4134.2</td>
      <td>2.6e-04</td>
      <td>7.7e-03</td>
      <td>8.8e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>2.6e-04</td>
      <td>0.0e+00</td>
      <td>-2.6e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-3400</td>
      <td>3400</td>
      <td>0</td>
      <td>-2.3e-02</td>
      <td>1.3e-03</td>
      <td>0.0</td>
      <td>-95.9</td>
      <td>4038.3</td>
      <td>-1.6e-13</td>
      <td>2.5e-04</td>
      <td>-1.3e-01</td>
      <td>1.3e-01</td>
      <td>-2.5e-04</td>
      <td>-1.0e-06</td>
      <td>-3980.1</td>
      <td>-2.5e-04</td>
      <td>5.4</td>
      <td>0.7</td>
      <td>6.1</td>
      <td>58.2</td>
      <td>3.7e-06</td>
      <td>7.4e-02</td>
      <td>58.3</td>
      <td>2.5e-16</td>
      <td>-95.9</td>
      <td>-1.6e-13</td>
      <td>-102.0</td>
      <td>3.7e-06</td>
      <td>600971.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>1.2</td>
      <td>4.9e+01</td>
    </tr>
    <tr>
      <td>@CHINA127</td>
      <td>2416.7</td>
      <td>1.5e-04</td>
      <td>7.7e-03</td>
      <td>5.1e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>1.5e-04</td>
      <td>0.0e+00</td>
      <td>-1.5e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-1400</td>
      <td>1400</td>
      <td>0</td>
      <td>5.1e-04</td>
      <td>-1.3e-03</td>
      <td>0.0</td>
      <td>1.2</td>
      <td>2418.0</td>
      <td>2.2e-13</td>
      <td>1.5e-04</td>
      <td>-1.7e-01</td>
      <td>1.7e-01</td>
      <td>-1.5e-04</td>
      <td>8.4e-07</td>
      <td>-2418.0</td>
      <td>-1.5e-04</td>
      <td>3.3</td>
      <td>0.3</td>
      <td>3.6</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>1.2</td>
      <td>2.2e-13</td>
      <td>-2.4</td>
      <td>0.0e+00</td>
      <td>000902.ZK</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>1.7</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@CHINA3053</td>
      <td>7980.6</td>
      <td>5.0e-04</td>
      <td>7.7e-03</td>
      <td>1.7e-01</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>5.0e-04</td>
      <td>0.0e+00</td>
      <td>-5.0e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-16600</td>
      <td>16600</td>
      <td>0</td>
      <td>-7.4e-03</td>
      <td>-1.4e-03</td>
      <td>0.0</td>
      <td>-59.0</td>
      <td>7921.6</td>
      <td>6.4e-14</td>
      <td>5.0e-04</td>
      <td>-5.7e-02</td>
      <td>5.7e-02</td>
      <td>-5.0e-04</td>
      <td>-1.0e-06</td>
      <td>-7918.5</td>
      <td>-5.0e-04</td>
      <td>10.8</td>
      <td>1.7</td>
      <td>12.5</td>
      <td>3.1</td>
      <td>1.9e-07</td>
      <td>-4.3e-03</td>
      <td>3.1</td>
      <td>-8.8e-17</td>
      <td>-59.0</td>
      <td>6.4e-14</td>
      <td>-71.7</td>
      <td>1.9e-07</td>
      <td>688425.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>0.5</td>
      <td>6.5e+00</td>
    </tr>
    <tr>
      <td>@SANTO10</td>
      <td>28479.2</td>
      <td>1.8e-03</td>
      <td>3.5e-03</td>
      <td>2.7e-01</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>1.8e-03</td>
      <td>0.0e+00</td>
      <td>-1.8e-03</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-6179</td>
      <td>6179</td>
      <td>0</td>
      <td>-1.2e-02</td>
      <td>2.0e-03</td>
      <td>0.0</td>
      <td>-340.2</td>
      <td>28139.0</td>
      <td>7.4e-13</td>
      <td>1.8e-03</td>
      <td>-5.3e-01</td>
      <td>5.3e-01</td>
      <td>-1.8e-03</td>
      <td>-1.0e-06</td>
      <td>-27958.9</td>
      <td>-1.8e-03</td>
      <td>6.3</td>
      <td>4.8</td>
      <td>11.1</td>
      <td>180.1</td>
      <td>1.1e-05</td>
      <td>3.7e-01</td>
      <td>180.5</td>
      <td>4.6e-15</td>
      <td>-339.8</td>
      <td>7.4e-13</td>
      <td>-351.2</td>
      <td>1.1e-05</td>
      <td>STO.AX</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>4.6</td>
      <td>4.0e+01</td>
    </tr>
    <tr>
      <td>@SHANG121</td>
      <td>8608.1</td>
      <td>5.4e-04</td>
      <td>7.7e-03</td>
      <td>1.8e-01</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>5.4e-04</td>
      <td>0.0e+00</td>
      <td>-5.4e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-2100</td>
      <td>2100</td>
      <td>0</td>
      <td>-3.0e-03</td>
      <td>2.4e-03</td>
      <td>0.0</td>
      <td>-26.1</td>
      <td>8582.0</td>
      <td>4.9e-13</td>
      <td>5.4e-04</td>
      <td>-5.8e-02</td>
      <td>5.8e-02</td>
      <td>-5.4e-04</td>
      <td>1.1e-06</td>
      <td>-8582.0</td>
      <td>-5.4e-04</td>
      <td>11.7</td>
      <td>2.5</td>
      <td>14.2</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-26.1</td>
      <td>4.9e-13</td>
      <td>-40.5</td>
      <td>0.0e+00</td>
      <td>300236.ZK</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>4.1</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@SHENZ257</td>
      <td>11069.3</td>
      <td>6.9e-04</td>
      <td>7.7e-03</td>
      <td>2.4e-01</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>6.9e-04</td>
      <td>0.0e+00</td>
      <td>-6.9e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-6800</td>
      <td>6800</td>
      <td>0</td>
      <td>2.0e-02</td>
      <td>2.8e-03</td>
      <td>0.0</td>
      <td>216.6</td>
      <td>11285.9</td>
      <td>-2.8e-13</td>
      <td>7.1e-04</td>
      <td>-1.7e-01</td>
      <td>1.7e-01</td>
      <td>-6.9e-04</td>
      <td>1.7e-05</td>
      <td>-11285.9</td>
      <td>-7.1e-04</td>
      <td>15.3</td>
      <td>3.9</td>
      <td>19.2</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>216.6</td>
      <td>-2.8e-13</td>
      <td>197.1</td>
      <td>0.0e+00</td>
      <td>603063.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>1.7</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@SZTOP2</td>
      <td>2123.4</td>
      <td>1.3e-04</td>
      <td>7.7e-03</td>
      <td>4.5e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>1.3e-04</td>
      <td>0.0e+00</td>
      <td>-1.3e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-5300</td>
      <td>5300</td>
      <td>0</td>
      <td>4.4e-03</td>
      <td>-8.4e-04</td>
      <td>0.0</td>
      <td>9.2</td>
      <td>2132.6</td>
      <td>-1.3e-13</td>
      <td>1.3e-04</td>
      <td>-5.2e-02</td>
      <td>5.2e-02</td>
      <td>-1.3e-04</td>
      <td>1.2e-06</td>
      <td>-2132.6</td>
      <td>-1.3e-04</td>
      <td>2.9</td>
      <td>0.5</td>
      <td>3.4</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>9.2</td>
      <td>-1.3e-13</td>
      <td>5.8</td>
      <td>0.0e+00</td>
      <td>002218.ZK</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>0.4</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@TIANR1</td>
      <td>3634.7</td>
      <td>2.3e-04</td>
      <td>7.7e-03</td>
      <td>7.7e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>2.3e-04</td>
      <td>0.0e+00</td>
      <td>-2.3e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-6400</td>
      <td>6400</td>
      <td>0</td>
      <td>-2.6e-03</td>
      <td>-2.4e-03</td>
      <td>0.0</td>
      <td>-9.4</td>
      <td>3625.3</td>
      <td>1.9e-13</td>
      <td>2.3e-04</td>
      <td>-4.9e-02</td>
      <td>4.9e-02</td>
      <td>-2.3e-04</td>
      <td>5.6e-07</td>
      <td>-3625.3</td>
      <td>-2.3e-04</td>
      <td>4.9</td>
      <td>0.8</td>
      <td>5.7</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-9.4</td>
      <td>1.9e-13</td>
      <td>-15.1</td>
      <td>0.0e+00</td>
      <td>002283.ZK</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>0.6</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@TOYOS3</td>
      <td>6476.2</td>
      <td>4.0e-04</td>
      <td>3.0e-03</td>
      <td>5.3e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>4.0e-04</td>
      <td>0.0e+00</td>
      <td>-4.0e-04</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-100</td>
      <td>100</td>
      <td>0</td>
      <td>-8.3e-03</td>
      <td>-2.3e-03</td>
      <td>0.0</td>
      <td>-53.8</td>
      <td>6422.5</td>
      <td>-2.9e-13</td>
      <td>4.0e-04</td>
      <td>-5.9e-01</td>
      <td>5.9e-01</td>
      <td>-4.0e-04</td>
      <td>-1.0e-06</td>
      <td>-6417.1</td>
      <td>-4.0e-04</td>
      <td>0.8</td>
      <td>1.0</td>
      <td>1.8</td>
      <td>5.3</td>
      <td>3.4e-07</td>
      <td>-1.2e-02</td>
      <td>5.3</td>
      <td>-2.6e-16</td>
      <td>-53.8</td>
      <td>-2.9e-13</td>
      <td>-55.7</td>
      <td>3.4e-07</td>
      <td>2875.T</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>64.4</td>
      <td>8.3e-02</td>
    </tr>
    <tr>
      <td>@CHINA639</td>
      <td>72653.7</td>
      <td>4.5e-03</td>
      <td>7.7e-03</td>
      <td>1.5e+00</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>4.5e-03</td>
      <td>0.0e+00</td>
      <td>-4.5e-03</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-70800</td>
      <td>70800</td>
      <td>0</td>
      <td>-2.1e-02</td>
      <td>-3.5e-03</td>
      <td>0.0</td>
      <td>-1544.6</td>
      <td>71109.0</td>
      <td>-1.4e-12</td>
      <td>4.5e-03</td>
      <td>-2.0e+00</td>
      <td>2.0e+00</td>
      <td>-4.5e-03</td>
      <td>-1.0e-06</td>
      <td>-69963.9</td>
      <td>-4.4e-03</td>
      <td>95.1</td>
      <td>13.8</td>
      <td>108.9</td>
      <td>1145.2</td>
      <td>7.2e-05</td>
      <td>-4.0e+00</td>
      <td>1141.2</td>
      <td>6.9e-14</td>
      <td>-1548.6</td>
      <td>-1.3e-12</td>
      <td>-1659.1</td>
      <td>7.2e-05</td>
      <td>601939.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>1.0</td>
      <td>1.1e+03</td>
    </tr>
    <tr>
      <td>@KEISE2</td>
      <td>19158.4</td>
      <td>1.2e-03</td>
      <td>3.0e-03</td>
      <td>1.6e-01</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>1.2e-03</td>
      <td>0.0e+00</td>
      <td>-1.2e-03</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>-600</td>
      <td>600</td>
      <td>0</td>
      <td>-1.9e-02</td>
      <td>2.6e-03</td>
      <td>0.0</td>
      <td>-363.0</td>
      <td>18795.4</td>
      <td>1.5e-12</td>
      <td>1.2e-03</td>
      <td>-4.0e-01</td>
      <td>4.0e-01</td>
      <td>-1.2e-03</td>
      <td>-1.0e-06</td>
      <td>-18548.0</td>
      <td>-1.2e-03</td>
      <td>2.3</td>
      <td>4.7</td>
      <td>7.0</td>
      <td>247.4</td>
      <td>1.6e-05</td>
      <td>6.4e-01</td>
      <td>248.1</td>
      <td>-1.1e-14</td>
      <td>-362.4</td>
      <td>1.5e-12</td>
      <td>-369.5</td>
      <td>1.6e-05</td>
      <td>9009.T</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>31.6</td>
      <td>7.9e+00</td>
    </tr>
    <tr>
      <td>@CHINA255</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>14100</td>
      <td>0</td>
      <td>14100</td>
      <td>-1.1e-02</td>
      <td>-2.0e-03</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>-1.0e+00</td>
      <td>1.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>-0.0</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>600050.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>0.6</td>
      <td>0.0e+00</td>
    </tr>
    <tr>
      <td>@CNOOC17</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>2.7e-03</td>
      <td>2.7e-03</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>11900</td>
      <td>0</td>
      <td>11900</td>
      <td>-4.5e-02</td>
      <td>2.6e-02</td>
      <td>0.0</td>
      <td>-0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>-3.7e+00</td>
      <td>3.7e+00</td>
      <td>2.7e-03</td>
      <td>2.7e-03</td>
      <td>41265.5</td>
      <td>2.6e-03</td>
      <td>14.8</td>
      <td>6.0</td>
      <td>20.8</td>
      <td>41265.5</td>
      <td>2.6e-03</td>
      <td>1.1e+03</td>
      <td>42322.3</td>
      <td>3.4e-12</td>
      <td>1056.7</td>
      <td>3.4e-12</td>
      <td>1035.9</td>
      <td>2.7e-03</td>
      <td>600938.SH</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>3.6</td>
      <td>1.2e+04</td>
    </tr>
    <tr>
      <td>@LARGA1</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>1.0</td>
      <td>1.0e-06</td>
      <td>0</td>
      <td>0</td>
      <td>0</td>
      <td>2.3e-02</td>
      <td>5.1e-03</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>-1.2e+00</td>
      <td>1.2e+00</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>0.0</td>
      <td>0.0e+00</td>
      <td>3008.TW</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>left_only</td>
      <td>83.7</td>
      <td>0.0e+00</td>
    </tr>
  </tbody>
</table>End of file