Spreadsheet: 767939d1644751241-problem-in-countifs-with-date-field-criteria-trade-log-sample
Sheet: Details

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
check | TID | Exhg. Seg | Account Id | Buy/Sell | Symbol | Strike Price | Option Type | ExpiryDate | Lots | Trade Qty | Trade Price | Trade Amount | Trade Date | Trade Time | [NAME] | ExchangeOrderNo | Order Source | BrokerId | Nr
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 37700 | PE | 10Feb2022 | 1 | 25 | 50.35 | 1258.75 | 09-Feb-2022 | 10:41:59 | BANKNIFTY2221037700PE | 1700000028153614 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 37700 | PE | 10Feb2022 | 3 | 75 | 50.35 | 3776.25 | 09-Feb-2022 | 10:41:59 | BANKNIFTY2221037700PE | 1700000028153614 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 37700 | PE | 10Feb2022 | 4 | 100 | 38.75 | 3875 | 09-Feb-2022 | 10:56:24 | BANKNIFTY2221037700PE | 1700000031031024 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 37700 | PE | 10Feb2022 | 1 | 25 | 52.45 | 1311.25 | 09-Feb-2022 | 11:10:31 | BANKNIFTY2221037700PE | 1700000027519849 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 37700 | PE | 10Feb2022 | 2 | 50 | 52.45 | 2622.5 | 09-Feb-2022 | 11:10:31 | BANKNIFTY2221037700PE | 1700000027519849 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 37700 | PE | 10Feb2022 | 1 | 25 | 52.45 | 1311.25 | 09-Feb-2022 | 11:10:31 | BANKNIFTY2221037700PE | 1700000027519849 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 37700 | PE | 10Feb2022 | 4 | 100 | 22.35 | 2235 | 09-Feb-2022 | 14:07:10 | BANKNIFTY2221037700PE | 1700000068766544 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 375 | 9375 | 09-Feb-2022 | 09:15:10 | BANKNIFTY2221038000CE | 1400000000069845 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 390 | 9750 | 09-Feb-2022 | 09:15:49 | BANKNIFTY2221038000CE | 1400000000179646 | TWS | R7M | 3
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38000 | CE | 10Feb2022 | 2 | 50 | 430 | 21500 | 09-Feb-2022 | 09:19:18 | BANKNIFTY2221038000CE | 1400000000872498 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 430 | 10750 | 09-Feb-2022 | 09:19:33 | BANKNIFTY2221038000CE | 1400000002121529 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 428 | 10700 | 09-Feb-2022 | 09:19:33 | BANKNIFTY2221038000CE | 1400000002090067 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 425 | 10625 | 09-Feb-2022 | 09:20:03 | BANKNIFTY2221038000CE | 1400000002187162 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 425 | 10625 | 09-Feb-2022 | 09:20:03 | BANKNIFTY2221038000CE | 1400000002058568 | TWS | R7M | 3
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38000 | CE | 10Feb2022 | 4 | 100 | 467.95 | 46795 | 09-Feb-2022 | [NAME] | BANKNIFTY2221038000CE | 1400000004112832 | TWS | R7M | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 502 | 12550 | 09-Feb-2022 | 09:41:09 | BANKNIFTY2221038000CE | 1400000010891835 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 500 | 12500 | 09-Feb-2022 | 09:41:11 | BANKNIFTY2221038000CE | 1400000010814122 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 498 | 12450 | 09-Feb-2022 | 09:41:11 | BANKNIFTY2221038000CE | 1400000010487807 | TWS | VNS | 1
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38000 | CE | 10Feb2022 | 2 | 50 | 566.65 | 28332.5 | 09-Feb-2022 | [NAME] | BANKNIFTY2221038000CE | 1400000014884248 | TWS | VNS | 1
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38000 | CE | 10Feb2022 | 1 | 25 | 566.6 | 14165 | 09-Feb-2022 | [NAME] | BANKNIFTY2221038000CE | 1400000014884248 | TWS | VNS | 1
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38700 | CE | 10Feb2022 | 2 | 50 | 452.45 | 22622.5 | 10-Feb-2022 | 13:22:54 | BANKNIFTY2221038700CE | 1500000095867415 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38700 | CE | 10Feb2022 | 1 | 25 | 422.9 | 10572.5 | 10-Feb-2022 | 13:21:34 | BANKNIFTY2221038700CE | 1500000095326557 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38700 | CE | 10Feb2022 | 1 | 25 | 424 | 10600 | 10-Feb-2022 | 13:21:20 | BANKNIFTY2221038700CE | 1500000095245159 | TWS | VNS | 5
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 3 | 75 | 436.85 | 32763.75 | 10-Feb-2022 | 12:23:19 | BANKNIFTY2221038600CE | 1400000077426033 | TWS | VNS | 4
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 437.1 | 10927.5 | 10-Feb-2022 | 12:23:19 | BANKNIFTY2221038600CE | 1400000077426033 | TWS | VNS | 4
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 415 | 10375 | 10-Feb-2022 | 12:21:23 | BANKNIFTY2221038600CE | 1400000076376621 | TWS | VNS | 4
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 430 | 10750 | 10-Feb-2022 | 12:20:51 | BANKNIFTY2221038600CE | 1400000075897505 | TWS | VNS | 4
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 435 | 10875 | 10-Feb-2022 | 12:20:49 | BANKNIFTY2221038600CE | 1400000076089524 | TWS | VNS | 4
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 436.15 | 10903.75 | 10-Feb-2022 | 12:19:46 | BANKNIFTY2221038600CE | 1400000075848877 | TWS | VNS | 4
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 475.75 | 11893.75 | 10-Feb-2022 | 11:30:59 | BANKNIFTY2221038600CE | 1400000061018299 | TWS | VNS | 3
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 475.75 | 11893.75 | 10-Feb-2022 | 11:30:59 | BANKNIFTY2221038600CE | 1400000061018299 | TWS | VNS | 3
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 2 | 50 | 475.75 | 23787.5 | 10-Feb-2022 | 11:30:59 | BANKNIFTY2221038600CE | 1400000061018299 | TWS | VNS | 3
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 2 | 50 | 475.75 | 23787.5 | 10-Feb-2022 | 11:30:59 | BANKNIFTY2221038600CE | 1400000061018299 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 450.95 | 11273.75 | 10-Feb-2022 | 11:22:53 | BANKNIFTY2221038600CE | 1400000057891475 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 461 | 11525 | 10-Feb-2022 | 11:22:21 | BANKNIFTY2221038600CE | 1400000057053528 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 468 | 11700 | 10-Feb-2022 | 11:21:40 | BANKNIFTY2221038600CE | 1400000057151657 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 478.75 | 11968.75 | 10-Feb-2022 | [NAME] | BANKNIFTY2221038600CE | 1400000056956428 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 478 | 11950 | 10-Feb-2022 | 11:20:02 | BANKNIFTY2221038600CE | 1400000056919072 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 465 | 11625 | 10-Feb-2022 | 11:18:14 | BANKNIFTY2221038600CE | 1400000056261054 | TWS | VNS | 3
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 5 | 125 | 405 | 50625 | 10-Feb-2022 | 10:37:10 | BANKNIFTY2221038600CE | 1400000037442745 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 371.4 | 9285 | 10-Feb-2022 | 10:35:08 | BANKNIFTY2221038600CE | 1400000036336434 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 385.2 | 9630 | 10-Feb-2022 | 10:35:04 | BANKNIFTY2221038600CE | 1400000036284440 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 396.65 | 9916.25 | 10-Feb-2022 | 10:34:58 | BANKNIFTY2221038600CE | 1400000036212668 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 400.15 | 10003.75 | 10-Feb-2022 | 10:34:55 | BANKNIFTY2221038600CE | 1400000036174471 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 400.8 | 10020 | 10-Feb-2022 | 10:34:53 | BANKNIFTY2221038600CE | 1400000036157294 | TWS | VNS | 2
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 5 | 125 | 414.75 | 51843.75 | 10-Feb-2022 | 09:23:43 | BANKNIFTY2221038300CE | 1500000004647866 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 375 | 9375 | 10-Feb-2022 | 09:22:26 | BANKNIFTY2221038300CE | 1500000003851879 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 380 | 9500 | 10-Feb-2022 | 09:21:49 | BANKNIFTY2221038300CE | 1500000003654231 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 382.15 | 9553.75 | 10-Feb-2022 | 09:21:49 | BANKNIFTY2221038300CE | 1500000003679468 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 382.45 | 9561.25 | 10-Feb-2022 | 09:21:43 | BANKNIFTY2221038300CE | 1500000003619278 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 392.8 | 9820 | 10-Feb-2022 | 09:21:37 | BANKNIFTY2221038300CE | 1500000003569794 | TWS | VNS | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 465.35 | 11633.75 | 10-Feb-2022 | 09:17:42 | BANKNIFTY2221038300CE | 1500000001371045 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 436.15 | 10903.75 | 10-Feb-2022 | 09:18:27 | BANKNIFTY2221038300CE | 1500000001770993 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 435 | 10875 | 10-Feb-2022 | 09:18:27 | BANKNIFTY2221038300CE | 1500000001710562 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 423 | 10575 | 10-Feb-2022 | 09:19:37 | BANKNIFTY2221038300CE | 1500000002426621 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 410 | 10250 | 10-Feb-2022 | 09:20:00 | BANKNIFTY2221038300CE | 1500000002227867 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 411.95 | 10298.75 | 10-Feb-2022 | 09:20:12 | BANKNIFTY2221038300CE | 1500000002772196 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 406 | 10150 | 10-Feb-2022 | 09:20:21 | BANKNIFTY2221038300CE | 1500000002715237 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 401 | 10025 | 10-Feb-2022 | 09:21:18 | BANKNIFTY2221038300CE | 1500000003024144 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 2 | 50 | 438.6 | 21930 | 10-Feb-2022 | 09:25:01 | BANKNIFTY2221038300CE | 1500000005177478 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 438.45 | 10961.25 | 10-Feb-2022 | 09:25:01 | BANKNIFTY2221038300CE | 1500000005177478 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 2 | 50 | 438.65 | 21932.5 | 10-Feb-2022 | 09:25:01 | BANKNIFTY2221038300CE | 1500000005177478 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 2 | 50 | 438.85 | 21942.5 | 10-Feb-2022 | 09:25:01 | BANKNIFTY2221038300CE | 1500000005177478 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 438.65 | 10966.25 | 10-Feb-2022 | 09:25:01 | BANKNIFTY2221038300CE | 1500000005177478 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 451.8 | 11295 | 10-Feb-2022 | 10:07:45 | BANKNIFTY2221038300CE | 1500000020220663 | TWS | R7M | 4
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38300 | CE | 10Feb2022 | 1 | 25 | 498.25 | 12456.25 | 10-Feb-2022 | 10:08:34 | BANKNIFTY2221038300CE | 1500000020903376 | TWS | R7M | 4
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38400 | PE | 10Feb2022 | 1 | 25 | 106.55 | 2663.75 | 10-Feb-2022 | 09:31:57 | BANKNIFTY2221038400PE | 1600000008250135 | TWS | R7M | 3
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38400 | PE | 10Feb2022 | 1 | 25 | 105 | 2625 | 10-Feb-2022 | [NAME] | BANKNIFTY2221038400PE | 1600000008572493 | TWS | R7M | 3
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38400 | PE | 10Feb2022 | 3 | 75 | 108 | 8100 | 10-Feb-2022 | 09:33:13 | BANKNIFTY2221038400PE | 1600000008404959 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38400 | PE | 10Feb2022 | 3 | 75 | 113.75 | 8531.25 | 10-Feb-2022 | 09:59:03 | BANKNIFTY2221038400PE | 1600000017590272 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38400 | PE | 10Feb2022 | 1 | 25 | 113.7 | 2842.5 | 10-Feb-2022 | 09:59:03 | BANKNIFTY2221038400PE | 1600000017590272 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38400 | PE | 10Feb2022 | 1 | 25 | 113.75 | 2843.75 | 10-Feb-2022 | 09:59:03 | BANKNIFTY2221038400PE | 1600000017590272 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 309.95 | 7748.75 | 10-Feb-2022 | 09:15:27 | BANKNIFTY2221038500CE | 1500000000227764 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 299.95 | 7498.75 | 10-Feb-2022 | 09:15:29 | BANKNIFTY2221038500CE | 1500000000208682 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 298 | 7450 | 10-Feb-2022 | 09:15:32 | BANKNIFTY2221038500CE | 1500000000268242 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 300 | 7500 | 10-Feb-2022 | 09:15:43 | BANKNIFTY2221038500CE | 1500000000335466 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 290 | 7250 | 10-Feb-2022 | [NAME] | BANKNIFTY2221038500CE | 1500000000309831 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 287.85 | 7196.25 | 10-Feb-2022 | 09:15:52 | BANKNIFTY2221038500CE | 1500000000186192 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 305.4 | 7635 | 10-Feb-2022 | 09:16:53 | BANKNIFTY2221038500CE | 1500000000955742 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 3 | 75 | 305.15 | 22886.25 | 10-Feb-2022 | 09:16:53 | BANKNIFTY2221038500CE | 1500000000955742 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 2 | 50 | 305.4 | 15270 | 10-Feb-2022 | 09:16:53 | BANKNIFTY2221038500CE | 1500000000955742 | TWS | R7M | 1
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 413.6 | 10340 | 10-Feb-2022 | 10:30:22 | BANKNIFTY2221038500CE | 1500000031897078 | TWS | R7M | 6
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 413.7 | 10342.5 | 10-Feb-2022 | 10:30:27 | BANKNIFTY2221038500CE | 1500000031947580 | TWS | R7M | 6
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 407.8 | 10195 | 10-Feb-2022 | 10:30:30 | BANKNIFTY2221038500CE | 1500000031969860 | TWS | R7M | 6
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 408 | 10200 | 10-Feb-2022 | 10:30:30 | BANKNIFTY2221038500CE | 1500000031933989 | TWS | R7M | 6
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 405 | 10125 | 10-Feb-2022 | 10:30:32 | BANKNIFTY2221038500CE | 1500000031880690 | TWS | R7M | 6
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 469.1 | 11727.5 | 10-Feb-2022 | 10:32:25 | BANKNIFTY2221038500CE | 1500000032485739 | TWS | R7M | 6
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 469.25 | 11731.25 | 10-Feb-2022 | 10:32:25 | BANKNIFTY2221038500CE | 1500000032485739 | TWS | R7M | 6
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 469.2 | 11730 | 10-Feb-2022 | 10:32:25 | BANKNIFTY2221038500CE | 1500000032485739 | TWS | R7M | 6
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 2 | 50 | 469.25 | 23462.5 | 10-Feb-2022 | 10:32:25 | BANKNIFTY2221038500CE | 1500000032485739 | TWS | R7M | 6
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 516.4 | 12910 | 10-Feb-2022 | 11:25:20 | BANKNIFTY2221038500CE | 1500000056650581 | TWS | R7M | 9
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 513.85 | 12846.25 | 10-Feb-2022 | 11:25:24 | BANKNIFTY2221038500CE | 1500000056675756 | TWS | R7M | 9
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 509.15 | 12728.75 | 10-Feb-2022 | 11:25:30 | BANKNIFTY2221038500CE | 1500000056721168 | TWS | R7M | 9
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | CE | 10Feb2022 | 1 | 25 | 506 | 12650 | 10-Feb-2022 | 11:25:41 | BANKNIFTY2221038500CE | 1500000056791179 | TWS | R7M | 9
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | CE | 10Feb2022 | 4 | 100 | 537.25 | 53725 | 10-Feb-2022 | 11:27:40 | BANKNIFTY2221038500CE | 1500000057422008 | TWS | R7M | 9
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | PE | 10Feb2022 | 4 | 100 | 53.1 | 5310 | 10-Feb-2022 | 10:13:44 | BANKNIFTY2221038500PE | 1700000025012491 | TWS | R7M | 5
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | PE | 10Feb2022 | 3 | 75 | 58.65 | 4398.75 | 10-Feb-2022 | 10:19:22 | BANKNIFTY2221038500PE | 1700000024285745 | TWS | R7M | 5
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | PE | 10Feb2022 | 1 | 25 | 58.65 | 1466.25 | 10-Feb-2022 | 10:19:22 | BANKNIFTY2221038500PE | 1700000024285745 | TWS | R7M | 5
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38500 | PE | 10Feb2022 | 4 | 100 | 61.45 | 6145 | 10-Feb-2022 | [NAME] | BANKNIFTY2221038500PE | 1700000023961771 | TWS | R7M | 5
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38500 | PE | 10Feb2022 | 12 | 300 | 9.25 | 2775 | 10-Feb-2022 | 12:05:45 | BANKNIFTY2221038500PE | 1700000066048532 | TWS | R7M | 5
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 397.75 | 9943.75 | 10-Feb-2022 | 10:35:20 | BANKNIFTY2221038600CE | 1400000036485516 | TWS | R7M | 7
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 393.85 | 9846.25 | 10-Feb-2022 | 10:35:22 | BANKNIFTY2221038600CE | 1400000036501253 | TWS | R7M | 7
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 393.2 | 9830 | 10-Feb-2022 | 10:35:24 | BANKNIFTY2221038600CE | 1400000036520021 | TWS | R7M | 7
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 391.95 | 9798.75 | 10-Feb-2022 | 10:35:26 | BANKNIFTY2221038600CE | 1400000036534577 | TWS | R7M | 7
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 394.2 | 9855 | 10-Feb-2022 | 10:35:32 | BANKNIFTY2221038600CE | 1400000036580244 | TWS | R7M | 7
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38600 | CE | 10Feb2022 | 1 | 25 | 392.3 | 9807.5 | 10-Feb-2022 | 10:35:36 | BANKNIFTY2221038600CE | 1400000036555538 | TWS | R7M | 7
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 2 | 50 | 428.5 | 21425 | 10-Feb-2022 | 10:39:12 | BANKNIFTY2221038600CE | 1400000038243014 | TWS | R7M | 7
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38600 | CE | 10Feb2022 | 4 | 100 | 428.45 | 42845 | 10-Feb-2022 | 10:39:12 | BANKNIFTY2221038600CE | 1400000038243014 | TWS | R7M | 7
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38900 | PE | 10Feb2022 | 1 | 25 | 65 | 1625 | 10-Feb-2022 | 11:16:03 | BANKNIFTY2221038900PE | 1700000051327836 | TWS | R7M | 8
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 38900 | PE | 10Feb2022 | 1 | 25 | 76 | 1900 | 10-Feb-2022 | 11:16:58 | BANKNIFTY2221038900PE | 1700000051600937 | TWS | R7M | 8
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 38900 | PE | 10Feb2022 | 2 | 50 | 47.75 | 2387.5 | 10-Feb-2022 | 11:49:34 | BANKNIFTY2221038900PE | 1700000061684869 | TWS | R7M | 8
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 10Feb2022 | 1 | 25 | 73.5 | 1837.5 | 10-Feb-2022 | 11:56:55 | BANKNIFTY2221039000PE | 1600000063260090 | TWS | R7M | 10
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 10Feb2022 | 1 | 25 | 78.65 | 1966.25 | 10-Feb-2022 | 11:57:15 | BANKNIFTY2221039000PE | 1600000063329673 | TWS | R7M | 10
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 10Feb2022 | 1 | 25 | 85 | 2125 | 10-Feb-2022 | 11:59:05 | BANKNIFTY2221039000PE | 1600000063676737 | TWS | R7M | 10
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 10Feb2022 | 2 | 50 | 86.65 | 4332.5 | 10-Feb-2022 | 12:13:25 | BANKNIFTY2221039000PE | 1600000067574681 | TWS | R7M | 10
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 10Feb2022 | 1 | 25 | 86.6 | 2165 | 10-Feb-2022 | 12:13:25 | BANKNIFTY2221039000PE | 1600000067574681 | TWS | R7M | 10
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39500 | CE | 17Feb2022 | 8 | 200 | 111 | 22200 | 11-Feb-2022 | 10:00:04 | BANKNIFTY2221739500CE | 1500000011280223 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 2 | 50 | 601.3 | 30065 | 11-Feb-2022 | 09:32:53 | BANKNIFTY2221739000PE | 1600000006824003 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 586 | 14650 | 11-Feb-2022 | 09:32:12 | BANKNIFTY2221739000PE | 1600000006033758 | TWS | R7M | 3
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 600.85 | 15021.25 | 11-Feb-2022 | 09:30:15 | BANKNIFTY2221739000PE | 1600000005984237 | TWS | R7M | 3
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39500 | CE | 17Feb2022 | 1 | 25 | 142.65 | 3566.25 | 11-Feb-2022 | [NAME] | BANKNIFTY2221739500CE | 1500000001522690 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39500 | CE | 17Feb2022 | 2 | 50 | 142.65 | 7132.5 | 11-Feb-2022 | [NAME] | BANKNIFTY2221739500CE | 1500000001522690 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39500 | CE | 17Feb2022 | 1 | 25 | 142.65 | 3566.25 | 11-Feb-2022 | [NAME] | BANKNIFTY2221739500CE | 1500000001522690 | TWS | R7M | 1
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 655.5 | 16387.5 | 11-Feb-2022 | 09:26:50 | BANKNIFTY2221739000PE | 1600000003993894 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 655.5 | 16387.5 | 11-Feb-2022 | 09:26:50 | BANKNIFTY2221739000PE | 1600000003993894 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 5 | 125 | 655.35 | 81918.75 | 11-Feb-2022 | 09:26:50 | BANKNIFTY2221739000PE | 1600000003993894 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 604 | 15100 | 11-Feb-2022 | 09:23:24 | BANKNIFTY2221739000PE | 1600000002865961 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 590 | 14750 | 11-Feb-2022 | 09:21:20 | BANKNIFTY2221739000PE | 1600000002419981 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 605 | 15125 | 11-Feb-2022 | 09:20:22 | BANKNIFTY2221739000PE | 1600000001835057 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 615 | 15375 | 11-Feb-2022 | 09:18:38 | BANKNIFTY2221739000PE | 1600000001161963 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 625 | 15625 | 11-Feb-2022 | 09:18:37 | BANKNIFTY2221739000PE | 1600000001231398 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 630 | 15750 | 11-Feb-2022 | 09:18:33 | BANKNIFTY2221739000PE | 1600000001096405 | TWS | R7M | 2
 |  | NFO | 7MPP07 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 640 | 16000 | 11-Feb-2022 | 09:18:18 | BANKNIFTY2221739000PE | 1600000001128791 | TWS | R7M | 2
 |  | NFO | 7MPP07 | SELL | BANKNIFTY | 39500 | CE | 17Feb2022 | 4 | 100 | 120 | 12000 | 11-Feb-2022 | 09:16:14 | BANKNIFTY2221739500CE | 1500000000205439 | TWS | R7M | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 571.5 | 14287.5 | 11-Feb-2022 | 12:42:22 | BANKNIFTY2221738400CE | 1400000040801948 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 570.9 | 14272.5 | 11-Feb-2022 | 12:42:26 | BANKNIFTY2221738400CE | 1400000040815772 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 575 | 14375 | 11-Feb-2022 | 12:42:42 | BANKNIFTY2221738400CE | 1400000040879485 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 572 | 14300 | 11-Feb-2022 | 12:43:27 | BANKNIFTY2221738400CE | 1400000040905708 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 572 | 14300 | 11-Feb-2022 | 12:43:27 | BANKNIFTY2221738400CE | 1400000040833468 | TWS | VNS | 5
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38400 | CE | 17Feb2022 | 4 | 100 | 597.5 | 59750 | 11-Feb-2022 | 12:45:23 | BANKNIFTY2221738400CE | 1400000041406425 | TWS | VNS | 5
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 38400 | CE | 17Feb2022 | 1 | 25 | 597.3 | 14932.5 | 11-Feb-2022 | 12:45:23 | BANKNIFTY2221738400CE | 1400000041406425 | TWS | VNS | 5
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 647.8 | 16195 | 11-Feb-2022 | 09:16:10 | BANKNIFTY2221739000PE | 1600000000368560 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 641.85 | 16046.25 | 11-Feb-2022 | 09:16:11 | BANKNIFTY2221739000PE | 1600000000356486 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 639.25 | 15981.25 | 11-Feb-2022 | 09:16:12 | BANKNIFTY2221739000PE | 1600000000389180 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 617 | 15425 | 11-Feb-2022 | 09:18:38 | BANKNIFTY2221739000PE | 1600000000463164 | TWS | VNS | 1
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 585.75 | 14643.75 | 11-Feb-2022 | 09:20:52 | BANKNIFTY2221739000PE | 1600000002277221 | TWS | VNS | 1
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 3 | 75 | 584.9 | 43867.5 | 11-Feb-2022 | 09:20:52 | BANKNIFTY2221739000PE | 1600000002277221 | TWS | VNS | 1
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 599 | 14975 | 11-Feb-2022 | 09:33:44 | BANKNIFTY2221739000PE | 1600000006999453 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 600 | 15000 | 11-Feb-2022 | 09:33:44 | BANKNIFTY2221739000PE | 1600000007018524 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 597 | 14925 | 11-Feb-2022 | 09:33:55 | BANKNIFTY2221739000PE | 1600000006979173 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 590 | 14750 | 11-Feb-2022 | 09:34:03 | BANKNIFTY2221739000PE | 1600000007047632 | TWS | VNS | 2
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 4 | 100 | 602.7 | 60270 | 11-Feb-2022 | 09:35:20 | BANKNIFTY2221739000PE | 1600000007391032 | TWS | VNS | 2
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 578 | 14450 | 11-Feb-2022 | 09:40:20 | BANKNIFTY2221739000PE | 1600000009028554 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 580 | 14500 | 11-Feb-2022 | 09:40:46 | BANKNIFTY2221739000PE | 1600000009139959 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 576 | 14400 | 11-Feb-2022 | 09:40:57 | BANKNIFTY2221739000PE | 1600000009109523 | TWS | VNS | 3
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 3 | 75 | 586.45 | 43983.75 | 11-Feb-2022 | 09:42:09 | BANKNIFTY2221739000PE | 1600000009537549 | TWS | VNS | 3
 |  | NFO | YMHS11184 | BUY | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 570 | 14250 | 11-Feb-2022 | 09:42:54 | BANKNIFTY2221739000PE | 1600000009078052 | TWS | VNS | 4
 |  | NFO | YMHS11184 | SELL | BANKNIFTY | 39000 | PE | 17Feb2022 | 1 | 25 | 611.6 | 15290 | 11-Feb-2022 | 09:47:12 | BANKNIFTY2221739000PE | 1600000010165894 | TWS | VNS | 4