Spreadsheet: 768242d1644895166-conditional-formatting-error-test-fobhav_conditional-format-error_-150222
Sheet: fobhav edtd 140222

 | INSTRUMENT | SYMBOL | EXPIRY_DT | CONTRACTS | OPEN_INT | CHG_IN_OI | SYMBOL | SERIES | DATE1 | TTL_TRD_QNTY | TURNOVER_LACS | DELIV_PER | Symbol | Underlying Previous Day Close Price (B) | Underlying Close Price (A) | Previous Day Underlying Volatility (D) | Current Day Underlying Daily Volatility | Futures Close Price (G) | Previous Day Futures Volatility (J)
1 | FUTSTK | TCS | 2022-02-24 00:00:00 | 39273 | 12437700 | -43650 |  |  |  |  |  |  |  |  | 3733.8 |  |  | 3731.1
2 | FUTSTK | RELIANCE | 2022-02-24 00:00:00 | 30058 | 28666000 | -570750 |  |  |  |  |  |  |  |  | 2338.55 |  |  | 2338
3 | FUTSTK | TATASTEEL | 2022-02-24 00:00:00 | 28989 | 41080500 | -1633275 |  |  |  |  |  |  |  |  | 1186.8 |  |  | 1188.05
4 | FUTSTK | INFY | 2022-02-24 00:00:00 | 26741 | 39286800 | -1699800 |  |  |  |  |  |  |  |  | 1682.2 |  |  | 1685.45
5 | FUTSTK | SBIN | 2022-02-24 00:00:00 | 22442 | 77242500 | -742500 |  |  |  |  |  |  |  |  | 501.4 |  |  | 501
6 | FUTSTK | HDFCBANK | 2022-02-24 00:00:00 | 21597 | 25989700 | -367950 |  |  |  |  |  |  |  |  | 1473.7 |  |  | 1468.75
7 | FUTSTK | ICICIBANK | 2022-02-24 00:00:00 | 19889 | 76916125 | -8250 |  |  |  |  |  |  |  |  | 753.7 |  |  | 755.05
8 | FUTSTK | HDFC | 2022-02-24 00:00:00 | 16239 | 20646300 | 198300 |  |  |  |  |  |  |  |  | 2296.8 |  |  | 2300.75
9 | FUTSTK | TATAMOTORS | 2022-02-24 00:00:00 | 15382 | 75852750 | 6067650 |  |  |  |  |  |  |  |  | 471.45 |  |  | 469.25
10 | FUTSTK | DIVISLAB | 2022-02-24 00:00:00 | 13350 | 2719400 | -119500 |  |  |  |  |  |  |  |  | 4277.85 |  |  | 4287.05
11 | FUTSTK | AXISBANK | 2022-02-24 00:00:00 | 12850 | 34514400 | -2290800 |  |  |  |  |  |  |  |  | 773.35 |  |  | 774.7
12 | FUTSTK | WIPRO | 2022-02-24 00:00:00 | 12832 | 36200800 | -357600 |  |  |  |  |  |  |  |  | 541.7 |  |  | 543
13 | FUTSTK | ITC | 2022-02-24 00:00:00 | 12503 | 171203200 | -3868800 |  |  |  |  |  |  |  |  | 219.45 |  |  | 219.6
14 | FUTSTK | ADANIENT | 2022-02-24 00:00:00 | 11893 | 20778500 | -32500 |  |  |  |  |  |  |  |  | 1663.95 |  |  | 1665.25
15 | FUTSTK | KOTAKBANK | 2022-02-24 00:00:00 | 11860 | 15504800 | 426800 |  |  |  |  |  |  |  |  | 1746.85 |  |  | 1751.75
16 | FUTSTK | BHARTIARTL | 2022-02-24 00:00:00 | 11564 | 52057150 | -1125750 |  |  |  |  |  |  |  |  | 689.6 |  |  | 690.7
17 | FUTSTK | HINDALCO | 2022-02-24 00:00:00 | 11417 | 28855150 | -1608200 |  |  |  |  |  |  |  |  | 521.25 |  |  | 522.45
18 | FUTSTK | APOLLOHOSP | 2022-02-24 00:00:00 | 10612 | 2456625 | -33500 |  |  |  |  |  |  |  |  | 4486.4 |  |  | 4497.3
19 | FUTSTK | JSWSTEEL | 2022-02-24 00:00:00 | 9287 | 38464200 | -21600 |  |  |  |  |  |  |  |  | 626.55 |  |  | 627.5
48 | FUTSTK | IRCTC | 2022-02-24 00:00:00 | 4937 | 10256750 | 63875 |  |  |  |  |  |  |  |  | 798.4 |  |  | 795.95
49 | FUTSTK | MOTHERSUMI | 2022-02-24 00:00:00 | 4839 | 17909500 | 441000 |  |  |  |  |  |  |  |  | 168.1 |  |  | 167.85
50 | FUTSTK | HINDUNILVR | 2022-02-24 00:00:00 | 4737 | 8855400 | -29700 |  |  |  |  |  |  |  |  | 2228.5 |  |  | 2229.4
51 | FUTSTK | MINDTREE | 2022-02-24 00:00:00 | 4693 | 2688800 | -42600 |  |  |  |  |  |  |  |  | 3776.4 |  |  | 3774.45
52 | FUTSTK | BANDHANBNK | 2022-02-24 00:00:00 | 4678 | 19976400 | -230400 |  |  |  |  |  |  |  |  | 310.6 |  |  | 310.3
53 | FUTSTK | TATACHEM | 2022-02-24 00:00:00 | 4362 | 6696000 | -383000 |  |  |  |  |  |  |  |  | 885.8 |  |  | 885.45
54 | FUTSTK | DRREDDY | 2022-02-24 00:00:00 | 4341 | 2484375 | -2000 |  |  |  |  |  |  |  |  | 4204.8 |  |  | 4208.7
62 | FUTSTK | [NAME] | 2022-02-24 00:00:00 | 3709 | 8710800 | 850 |  |  |  |  |  |  |  |  | 761.35 |  |  | 763
63 | FUTSTK | TVSMOTOR | 2022-02-24 00:00:00 | 3684 | 9812600 | -81200 |  |  |  |  |  |  |  |  | 641.7 |  |  | 642.65
64 | FUTSTK | COFORGE | 2022-02-24 00:00:00 | 3661 | 687900 | 14400 |  |  |  |  |  |  |  |  | 4355.1 |  |  | 4296.15
65 | FUTSTK | BEL | 2022-02-24 00:00:00 | 3559 | 30571000 | -3093200 |  |  |  |  |  |  |  |  | 195.9 |  |  | 195.85
66 | FUTSTK | SRF | 2022-02-24 00:00:00 | 3434 | 2647500 | -61875 |  |  |  |  |  |  |  |  | 2348.95 |  |  | 2354.15
67 | FUTSTK | CUMMINSIND | 2022-02-24 00:00:00 | 3421 | 1977600 | -139200 |  |  |  |  |  |  |  |  | 953.65 |  |  | 946.15
68 | FUTSTK | GNFC | 2022-02-24 00:00:00 | 3416 | 2658500 | -149500 |  |  |  |  |  |  |  |  | 539.35 |  |  | 541.2
69 | FUTSTK | TATACONSUM | 2022-02-24 00:00:00 | 3396 | 10509075 | -95850 |  |  |  |  |  |  |  |  | 694.3 |  |  | 693.3
75 | FUTSTK | NTPC | 2022-02-24 00:00:00 | 3310 | 44226300 | -4195200 |  |  |  |  |  |  |  |  | 132.5 |  |  | 132.7
76 | FUTSTK | SUNTV | 2022-02-24 00:00:00 | 3292 | 12657000 | 298500 |  |  |  |  |  |  |  |  | 516.65 |  |  | 514.9
77 | FUTSTK | NAUKRI | 2022-02-24 00:00:00 | 3271 | 1649875 | -47875 |  |  |  |  |  |  |  |  | 4511.4 |  |  | 4511.3
95 | FUTSTK | [NAME] | 2022-02-24 00:00:00 | 2732 | 8105000 | 139000 |  |  |  |  |  |  |  |  | 577.3 |  |  | 576.85
96 | FUTSTK | INDHOTEL | 2022-02-24 00:00:00 | 2620 | 16413782 | -144792 |  |  |  |  |  |  |  |  | 195.1 |  |  | 194.75
97 | FUTSTK | ABFRL | 2022-02-24 00:00:00 | 2584 | 13826800 | -390000 |  |  |  |  |  |  |  |  | 267.15 |  |  | 266.85
98 | FUTSTK | LTTS | 2022-02-24 00:00:00 | 2563 | 717400 | -48400 |  |  |  |  |  |  |  |  | 4423.7 |  |  | 4424.3
99 | FUTSTK | ACC | 2022-02-24 00:00:00 | 2548 | 2158000 | -13250 |  |  |  |  |  |  |  |  | 2153.95 |  |  | 2151.45
100 | FUTSTK | DIXON | 2022-02-24 00:00:00 | 2536 | 586125 | -17375 |  |  |  |  |  |  |  |  | 4146.8 |  |  | 4133.3
101 | FUTSTK | INDIACEM | 2022-02-24 00:00:00 | 2510 | 11953800 | 2900 |  |  |  |  |  |  |  |  | 197.6 |  |  | 197.25
102 | FUTSTK | PIDILITIND | 2022-02-24 00:00:00 | 2453 | 2714750 | 27750 |  |  |  |  |  |  |  |  | 2388.75 |  |  | 2384.85
103 | FUTSTK | [NAME] | 2022-02-24 00:00:00 | 2452 | 19924300 | -8800 |  |  |  |  |  |  |  |  | 382.65 |  |  | 382.7
104 | FUTSTK | IOC | 2022-02-24 00:00:00 | 2348 | 36887500 | -1469000 |  |  |  |  |  |  |  |  | 116.55 |  |  | 116.85
105 | FUTSTK | HINDCOPPER | 2022-02-24 00:00:00 | 2260 | 16868900 | -2145700 |  |  |  |  |  |  |  |  | 126 |  |  | 126.45
106 | FUTSTK | TATAPOWER | 2022-02-24 00:00:00 | 2252 | 113143500 | -12703500 |  |  |  |  |  |  |  |  | 220.5 |  |  | 220.1
107 | FUTSTK | ICICIPRULI | 2022-02-24 00:00:00 | 2251 | 6295500 | 189750 |  |  |  |  |  |  |  |  | 502.6 |  |  | 502.35
108 | FUTSTK | HAVELLS | 2022-02-24 00:00:00 | 2249 | 3999500 | 8000 |  |  |  |  |  |  |  |  | 1156.05 |  |  | 1154.7
109 | FUTSTK | INDIAMART | 2022-02-24 00:00:00 | 2046 | 352725 | 11925 |  |  |  |  |  |  |  |  | 5022.9 |  |  | 4585.2
110 | FUTSTK | AMBUJACEM | 2022-02-24 00:00:00 | 2009 | 14019000 | -234000 |  |  |  |  |  |  |  |  | 355.1 |  |  | 355.9
111 | FUTSTK | BAJAJ-AUTO | 2022-02-24 00:00:00 | 2005 | 2050250 | 11500 |  |  |  |  |  |  |  |  | 3487.75 |  |  | 3485.95
112 | FUTSTK | DELTACORP | 2022-02-24 00:00:00 | 1966 | 13896600 | -156400 |  |  |  |  |  |  |  |  | 258.05 |  |  | 258.15
113 | FUTSTK | GUJGASLTD | 2022-02-24 00:00:00 | 1957 | 2151250 | 338750 |  |  |  |  |  |  |  |  | 641.7 |  |  | 636.45
114 | FUTSTK | MGL | 2022-02-24 00:00:00 | 1943 | 4070400 | -151800 |  |  |  |  |  |  |  |  | 786.15 |  |  | 777.05
115 | FUTSTK | IPCALAB | 2022-02-24 00:00:00 | 1915 | 1206450 | -5850 |  |  |  |  |  |  |  |  | 964.55 |  |  | 965.25
116 | FUTSTK | PERSISTENT | 2022-02-24 00:00:00 | 1888 | 333300 | -19350 |  |  |  |  |  |  |  |  | 3943.9 |  |  | 3950
117 | FUTSTK | POWERGRID | 2022-02-24 00:00:00 | 1869 | 32744620 | 1045268 |  |  |  |  |  |  |  |  | 201.85 |  |  | 197
161 | FUTSTK | NAM-INDIA | 2022-02-24 00:00:00 | 996 | 2630400 | -86400 |  |  |  |  |  |  |  |  | 317.95 |  |  | 308.4
162 | FUTSTK | HAL | 2022-02-24 00:00:00 | 941 | 2498975 | -44175 |  |  |  |  |  |  |  |  | 1332.85 |  |  | 1310.3
163 | FUTSTK | NAVINFLUOR | 2022-02-24 00:00:00 | 910 | 485325 | -9450 |  |  |  |  |  |  |  |  | 3714.15 |  |  | 3721.6
164 | FUTSTK | GSPL | 2022-02-24 00:00:00 | 906 | 1349800 | 34000 |  |  |  |  |  |  |  |  | 286.5 |  |  | 285.85
165 | FUTSTK | UBL | 2022-02-24 00:00:00 | 906 | 964950 | -10850 |  |  |  |  |  |  |  |  | 1526.95 |  |  | 1529.55
166 | FUTSTK | MFSL | 2022-02-24 00:00:00 | 899 | 1606800 | -33800 |  |  |  |  |  |  |  |  | 826.5 |  |  | 823.6
167 | FUTSTK | CUB | 2022-02-24 00:00:00 | 847 | 12362400 | -377400 |  |  |  |  |  |  |  |  | 132.2 |  |  | 132
168 | FUTSTK | ABB | 2022-02-24 00:00:00 | 805 | 252250 | -4000 |  |  |  |  |  |  |  |  | 2090.95 |  |  | 2097.25
169 | FUTSTK | DALBHARAT | 2022-02-24 00:00:00 | 786 | 459750 | 3000 |  |  |  |  |  |  |  |  | 1804.6 |  |  | 1810.9
170 | FUTSTK | ALKEM | 2022-02-24 00:00:00 | 719 | 320600 | 21800 |  |  |  |  |  |  |  |  | 3365 |  |  | 3365.75
171 | FUTSTK | INTELLECT | 2022-02-24 00:00:00 | 687 | 380250 | 6000 |  |  |  |  |  |  |  |  | 655.25 |  |  | 656.7
172 | FUTSTK | APLLTD | 2022-02-24 00:00:00 | 624 | 1817200 | 1400 |  |  |  |  |  |  |  |  | 736.7 |  |  | 736.8
173 | FUTSTK | RAMCOCEM | 2022-02-24 00:00:00 | 596 | 1884450 | -39950 |  |  |  |  |  |  |  |  | 836.55 |  |  | 837.4
174 | FUTSTK | JKCEMENT | 2022-02-24 00:00:00 | 585 | 257775 | 875 |  |  |  |  |  |  |  |  | 3062.75 |  |  | 3013.35
175 | FUTSTK | PFIZER | 2022-02-24 00:00:00 | 538 | 172500 | 1000 |  |  |  |  |  |  |  |  | 4313.9 |  |  | 4311.75
176 | FUTSTK | SYNGENE | 2022-02-24 00:00:00 | 419 | 875500 | -14450 |  |  |  |  |  |  |  |  | 567.65 |  |  | 567.25