Spreadsheet: 767917d1644734746-need-help-in-eliminating-incomplete-records-from-the-sheet-fo-stock-final-appended-110222-new
Sheet: expected result

 | INSTRUMENT | SYMBOL | EXPIRY_DT | CLOSE | CONTRACTS | OPEN_INT | CHG_IN_OI | TIMESTAMP | SYMBOL | SERIES | DATE1 | CLOSE_PRICE | TTL_TRD_QNTY | TURNOVER_LACS | DELIV_QTY | DELIV_PER | Symbol | Underlying Close Price (A) | Underlying Previous Day Close Price (B) | Previous Day Underlying Volatility (D) | Current Day Underlying Daily Volatility | Futures Close Price (G) | Futures Previous Day Close Price (H)
2 | FUTSTK | TATASTEEL | 2022-02-24 00:00:00 | 1253.7 | 28260 | 42713775 | -1278825 | 2022-02-11 00:00:00
7 | FUTSTK | SBIN | 2022-02-24 00:00:00 | 529 | 15305 | 77985000 | -1728000 | 2022-02-11 00:00:00
8 | FUTSTK | ICICIBANK | 2022-02-24 00:00:00 | 791.8 | 13637 | 76924375 | -987250 | 2022-02-11 00:00:00
9 | FUTSTK | HINDALCO | 2022-02-24 00:00:00 | 542.35 | 13182 | 30463350 | -726700 | 2022-02-11 00:00:00
10 | FUTSTK | INDUSINDBK | 2022-02-24 00:00:00 | 982 | 12339 | 24138900 | -1193400 | 2022-02-11 00:00:00
13 | FUTSTK | AXISBANK | 2022-02-24 00:00:00 | 803.35 | 10640 | 36805200 | -328800 | 2022-02-11 00:00:00
14 | FUTSTK | TATAMOTORS | 2022-02-24 00:00:00 | 498.3 | 10502 | 69785100 | 664050 | 2022-02-11 00:00:00
15 | FUTSTK | M&M | 2022-02-24 00:00:00 | 855.55 | 10372 | 13252400 | -186900 | 2022-02-11 00:00:00
17 | FUTSTK | PFC | 2022-02-24 00:00:00 | 121.55 | 10020 | 34602200 | -9833200 | 2022-02-11 00:00:00
18 | FUTSTK | TATAPOWER | 2022-02-24 00:00:00 | 232.15 | 9027 | 125847000 | -3152250 | 2022-02-11 00:00:00
19 | FUTSTK | BHARATFORG | 2022-02-24 00:00:00 | 732.3 | 8820 | 5520750 | -293250 | 2022-02-11 00:00:00
20 | FUTSTK | TVSMOTOR | 2022-02-24 00:00:00 | 660.75 | 8693 | 9893800 | -168000 | 2022-02-11 00:00:00
23 | FUTSTK | MOTHERSUMI | 2022-02-24 00:00:00 | 171.75 | 7792 | 17468500 | 2009000 | 2022-02-11 00:00:00
24 | FUTSTK | NAUKRI | 2022-02-24 00:00:00 | 4599.15 | 7595 | 1697750 | 109375 | 2022-02-11 00:00:00
25 | FUTSTK | JINDALSTEL | 2022-02-24 00:00:00 | 437.6 | 7533 | 35005000 | -5000 | 2022-02-11 00:00:00
26 | FUTSTK | ADANIENT | 2022-02-24 00:00:00 | 1764.65 | 7321 | 20811000 | -301500 | 2022-02-11 00:00:00
27 | FUTSTK | APOLLOHOSP | 2022-02-24 00:00:00 | 4517.2 | 6930 | 2490125 | 57375 | 2022-02-11 00:00:00
28 | FUTSTK | VEDL | 2022-02-24 00:00:00 | 379.25 | 6751 | 70800900 | -663400 | 2022-02-11 00:00:00
29 | FUTSTK | AUROPHARMA | 2022-02-24 00:00:00 | 698.85 | 6722 | 13100250 | -672000 | 2022-02-11 00:00:00
30 | FUTSTK | TATACHEM | 2022-02-24 00:00:00 | 913.85 | 6705 | 7079000 | 925000 | 2022-02-11 00:00:00
31 | FUTSTK | TECHM | 2022-02-24 00:00:00 | 1424.75 | 6644 | 15838200 | 180000 | 2022-02-11 00:00:00
32 | FUTSTK | JUBLFOOD | 2022-02-24 00:00:00 | 3088 | 6586 | 2433000 | 35750 | 2022-02-11 00:00:00
33 | FUTSTK | DLF | 2022-02-24 00:00:00 | 378.65 | 6431 | 34836450 | 861300 | 2022-02-11 00:00:00
35 | FUTSTK | JSWSTEEL | 2022-02-24 00:00:00 | 671.4 | 6183 | 38485800 | -595350 | 2022-02-11 00:00:00
38 | FUTSTK | SUNTV | 2022-02-24 00:00:00 | 516.5 | 6070 | 12358500 | 66000 | 2022-02-11 00:00:00
39 | FUTSTK | BANDHANBNK | 2022-02-24 00:00:00 | 317.8 | 5993 | 20206800 | 307800 | 2022-02-11 00:00:00
40 | FUTSTK | ADANIPORTS | 2022-02-24 00:00:00 | 726.15 | 5944 | 88772500 | 440000 | 2022-02-11 00:00:00
43 | FUTSTK | PEL | 2022-02-24 00:00:00 | 2425.5 | 5447 | 3663275 | -12100 | 2022-02-11 00:00:00
45 | FUTSTK | COFORGE | 2022-02-24 00:00:00 | 4474.45 | 5237 | 673500 | 45800 | 2022-02-11 00:00:00
46 | FUTSTK | LAURUSLABS | 2022-02-24 00:00:00 | 551.65 | 5212 | 5083200 | 54000 | 2022-02-11 00:00:00
47 | FUTSTK | GODREJPROP | 2022-02-24 00:00:00 | 1560.15 | 4836 | 5516225 | -212875 | 2022-02-11 00:00:00
48 | FUTSTK | INDIGO | 2022-02-24 00:00:00 | 2264.45 | 4558 | 3203750 | -3000 | 2022-02-11 00:00:00
49 | FUTSTK | MINDTREE | 2022-02-24 00:00:00 | 3872.4 | 4511 | 2731400 | 40200 | 2022-02-11 00:00:00
50 | FUTSTK | GRASIM | 2022-02-24 00:00:00 | 1710.15 | 4484 | 10471375 | 210425 | 2022-02-11 00:00:00
51 | FUTSTK | LALPATHLAB | 2022-02-24 00:00:00 | 2788.8 | 4452 | 761000 | 48500 | 2022-02-11 00:00:00
52 | FUTSTK | FEDERALBNK | 2022-02-24 00:00:00 | 102.95 | 4399 | 75970000 | -6190000 | 2022-02-11 00:00:00
53 | FUTSTK | LICHSGFIN | 2022-02-24 00:00:00 | 391.6 | 4232 | 20904000 | -66000 | 2022-02-11 00:00:00
54 | FUTSTK | NATIONALUM | 2022-02-24 00:00:00 | 120 | 4015 | 101881000 | -1266500 | 2022-02-11 00:00:00
55 | FUTSTK | ZEEL | 2022-02-24 00:00:00 | 262.55 | 4011 | 74952000 | 1053000 | 2022-02-11 00:00:00
57 | FUTSTK | TRENT | 2022-02-24 00:00:00 | 1073.7 | 3915 | 2404100 | 39875 | 2022-02-11 00:00:00
58 | FUTSTK | BANKBARODA | 2022-02-24 00:00:00 | 113.35 | 3883 | 128255400 | -6926400 | 2022-02-11 00:00:00
59 | FUTSTK | INDIACEM | 2022-02-24 00:00:00 | 210 | 3799 | 11950900 | 382800 | 2022-02-11 00:00:00
60 | FUTSTK | CANBK | 2022-02-24 00:00:00 | 251.4 | 3744 | 42465600 | -1868400 | 2022-02-11 00:00:00
61 | FUTSTK | CUMMINSIND | 2022-02-24 00:00:00 | 934.35 | 3707 | 2116800 | 169200 | 2022-02-11 00:00:00
62 | FUTSTK | NMDC | 2022-02-24 00:00:00 | 153 | 3667 | 84828700 | -4569400 | 2022-02-11 00:00:00
63 | FUTSTK | RBLBANK | 2022-02-24 00:00:00 | 141.9 | 3632 | 34585400 | -266800 | 2022-02-11 00:00:00
66 | FUTSTK | COALINDIA | 2022-02-24 00:00:00 | 160.9 | 3508 | 40790400 | -50400 | 2022-02-11 00:00:00
67 | FUTSTK | IEX | 2022-02-24 00:00:00 | 219.55 | 3433 | 46518750 | -183750 | 2022-02-11 00:00:00
68 | FUTSTK | GNFC | 2022-02-24 00:00:00 | 567.35 | 3220 | 2808000 | -180700 | 2022-02-11 00:00:00
69 | FUTSTK | AUBANK | 2022-02-24 00:00:00 | 1320.85 | 3189 | 2616500 | 149500 | 2022-02-11 00:00:00
71 | FUTSTK | MPHASIS | 2022-02-24 00:00:00 | 3000.9 | 3166 | 1420300 | -57575 | 2022-02-11 00:00:00
73 | FUTSTK | MANAPPURAM | 2022-02-24 00:00:00 | 152.05 | 3126 | 19974000 | 1890000 | 2022-02-11 00:00:00
76 | FUTSTK | IBULHSGFIN | 2022-02-24 00:00:00 | 197.9 | 3073 | 37593700 | 939300 | 2022-02-11 00:00:00
77 | FUTSTK | SRF | 2022-02-24 00:00:00 | 2479.95 | 3068 | 2709375 | -65625 | 2022-02-11 00:00:00
78 | FUTSTK | BPCL | 2022-02-24 00:00:00 | 370.4 | 3058 | 24604200 | -401400 | 2022-02-11 00:00:00
81 | FUTSTK | IRCTC | 2022-02-24 00:00:00 | 828.55 | 3016 | 10192875 | 13125 | 2022-02-11 00:00:00