Spreadsheet: 735347d1622880468-create-a-new-data-series-using-existing-data-in-a-pivot-table-book2
Sheet: Sheet1

Date | T | date | Days | ImpVol1545c | IV | [NAME] | Spot1545c | CallBid | CallAsk | CallVolume | risk free | t | D1 | DIV | DELTA | GAMMA | 365 | moneyness
2004-01-02 00:00:00 | 11 |  |  | 0.1439 |  | 1150 | 1107.23 | 1.25 | 1.5 | 1932 | 0.009300000071525573 |  |  | 0
 |  |  |  | 0.1454 |  | 1140 | 1107.23 | 2.3 | 3 | 1924 | 0.009300000071525573 |  |  | 0
 |  |  |  | 0.1467 |  | 1135 | 1107.23 | 3.2 | 4 | 1511 | 0.009300000071525573 |  |  | 0
 |  |  |  | 0.1497 |  | 1125 | 1107.23 | 6 | 6.5 | 3836 | 0.009300000071525573 |  |  | 0
 |  |  |  | 0.1598 |  | 1100 | 1107.23 | 17.3 | 18.9 | 1363 | 0.009300000071525573 |  |  | 0
2004-01-05 00:00:00 | 10 |  |  | 0.1428 |  | 1150 | 1120.34 | 1.95 | 2.1 | 4171 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1465 |  | 1125 | 1120.34 | 9.2 | 9.6 | 5396 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1554 |  | 1120 | 1120.34 | 11.9 | 13 | 1537 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1602 |  | 1110 | 1120.34 | 18.2 | 18.8 | 3818 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1691 |  | 1100 | 1120.34 | 25.4 | 26.5 | 1752 | 0.009100000262260438 |  |  | 0
2004-01-06 00:00:00 | 34 |  |  | 0.1287 |  | 1150 | 1120.72 | 9.4 | 10.4 | 2396 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1498 |  | 1100 | 1120.72 | 35.9 | 37.9 | 354 | 0.009100000262260438 |  |  | 0
 |  |  |  | 0.1591 |  | 1090 | 1120.72 | 43.9 | 45.9 | 1 | 0.009100000262260438 |  |  | 0
2004-01-08 00:00:00 | 32 |  |  | 0.1263 |  | 1140 | 1125.82 | 13.8 | 15.6 | 1167 | 0.008799999952316284 |  |  | 0
2004-01-09 00:00:00 | 31 |  |  | 0.1257 |  | 1175 | 1119.14 | 3.4 | 3.7 | 514 | 0.008700000047683716 |  |  | 0
 |  |  |  | 0.1306 |  | 1150 | 1119.14 | 9 | 9.5 | 3363 | 0.008700000047683716 |  |  | 0
 |  |  |  | 0.1345 |  | 1140 | 1119.14 | 12.2 | 13.8 | 352 | 0.008700000047683716 |  |  | 0
 |  |  |  | 0.1382 |  | 1130 | 1119.14 | 16.7 | 18.3 | 100 | 0.008700000047683716 |  |  | 0
 |  |  |  | 0.1507 |  | 1100 | 1119.14 | 34.6 | 36.6 | 99 | 0.008700000047683716 |  |  | 0
2004-01-12 00:00:00 | 30 |  |  | 0.136 |  | 1160 | 1122.9 | 7 | 8 | 69 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1381 |  | 1150 | 1122.9 | 10 | 11 | 2599 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1382 |  | 1140 | 1122.9 | 13.4 | 14.5 | 100 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1449 |  | 1130 | 1122.9 | 18.3 | 19.9 | 31 | 0.008899999856948853 |  |  | 0
2004-01-13 00:00:00 | 29 |  |  | 0.1412 |  | 1150 | 1116.39 | 8.2 | 9 | 983 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1444 |  | 1140 | 1116.39 | 11.3 | 12.9 | 658 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1457 |  | 1130 | 1116.39 | 15.5 | 16.5 | 649 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1761 |  | 1075 | 1116.39 | 51.7 | 53.7 | 164 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.2204 |  | 1025 | 1116.39 | 96.7 | 98.7 | 154 | 0.008899999856948853 |  |  | 0
2004-01-15 00:00:00 | 27 |  |  | 0.133 |  | 1150 | 1128.25 | 10.1 | 11.7 | 4830 | 0.008799999952316284 |  |  | 0
 |  |  |  | 0.1477 |  | 1115 | 1128.25 | 28.7 | 30.7 | 77 | 0.008799999952316284 |  |  | 0
2004-01-16 00:00:00 | 26 |  |  | 0.1207 |  | 1175 | 1135.53 | 4.4 | 5 | 2560 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1213 |  | 1170 | 1135.53 | 5.5 | 6 | 583 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1221 |  | 1160 | 1135.53 | 8.2 | 8.8 | 1872 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1348 |  | 1125 | 1135.53 | 25.2 | 26.9 | 6111 | 0.008899999856948853 |  |  | 0
 |  |  |  | 0.1675 |  | 1075 | 1135.53 | 66 | 68 | 6116 | 0.008899999856948853 |  |  | 0