Spreadsheet: 767837d1644670234-append-data-applying-vlookup-test-fobhavdata110222
Sheet: fobhav

 |  |  |  |  |  |  |  |  | '=IFERROR(VLOOKUP($C5,FOVOLT!$C$2:$I$122,COLUMNS(fobhav!$C5:C5),0),"")
 | INSTRUMENT | SYMBOL | EXPIRY_DT | CLOSE | CONTRACTS | OPEN_INT | CHG_IN_OI | TIMESTAMP
1 | FUTSTK | DIVISLAB | 2022-02-24 00:00:00 | 4297.3 | 33743 | 2838900 | 194200 | 2022-02-11 00:00:00
2 | FUTSTK | TATASTEEL | 2022-02-24 00:00:00 | 1253.7 | 28260 | 42713775 | -1278825 | 2022-02-11 00:00:00
3 | FUTSTK | RELIANCE | 2022-02-24 00:00:00 | 2377.75 | 25987 | 29236750 | -1107750 | 2022-02-11 00:00:00
4 | FUTSTK | INFY | 2022-02-24 00:00:00 | 1722.5 | 24156 | 40986600 | 286200 | 2022-02-11 00:00:00
5 | FUTSTK | TCS | 2022-02-24 00:00:00 | 3707.85 | 17524 | 12481350 | 322950 | 2022-02-11 00:00:00
6 | FUTSTK | HDFCBANK | 2022-02-24 00:00:00 | 1517.45 | 16500 | 26357650 | -163900 | 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
11 | FUTSTK | HDFC | 2022-02-24 00:00:00 | 2429.45 | 11379 | 20448000 | 221700 | 2022-02-11 00:00:00
12 | FUTSTK | WIPRO | 2022-02-24 00:00:00 | 562.3 | 11230 | 36558400 | -1203200 | 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
16 | FUTSTK | ITC | 2022-02-24 00:00:00 | 227.5 | 10024 | 175072000 | 2246400 | 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
21 | FUTSTK | KOTAKBANK | 2022-02-24 00:00:00 | 1831.9 | 8499 | 15078000 | 44400 | 2022-02-11 00:00:00
22 | FUTSTK | BHARTIARTL | 2022-02-24 00:00:00 | 715.05 | 8042 | 53182900 | -1404100 | 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
34 | FUTSTK | SUNPHARMA | 2022-02-24 00:00:00 | 880.15 | 6259 | 22155000 | -861700 | 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
36 | FUTSTK | HEROMOTOCO | 2022-02-24 00:00:00 | 2664.25 | 6149 | 3090300 | -36300 | 2022-02-11 00:00:00
37 | FUTSTK | LT | 2022-02-24 00:00:00 | 1871.65 | 6115 | 13534350 | -47150 | 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
41 | FUTSTK | HCLTECH | 2022-02-24 00:00:00 | 1163.6 | 5678 | 22349600 | -16800 | 2022-02-11 00:00:00
42 | FUTSTK | ASIANPAINT | 2022-02-24 00:00:00 | 3215.5 | 5656 | 3604500 | 56250 | 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
44 | FUTSTK | HINDUNILVR | 2022-02-24 00:00:00 | 2264 | 5414 | 8885100 | -269700 | 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
56 | FUTSTK | TITAN | 2022-02-24 00:00:00 | 2441.85 | 3936 | 4939500 | -177750 | 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
64 | FUTSTK | VOLTAS | 2022-02-24 00:00:00 | 1191.65 | 3582 | 3725000 | -46000 | 2022-02-11 00:00:00
65 | FUTSTK | GODREJCP | 2022-02-24 00:00:00 | 827.95 | 3550 | 4870500 | 424000 | 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
70 | FUTSTK | SBILIFE | 2022-02-24 00:00:00 | 1132.85 | 3182 | 6255750 | -91500 | 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
72 | FUTSTK | IGL | 2022-02-24 00:00:00 | 392.7 | 3130 | 18656000 | 111375 | 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
74 | FUTSTK | DRREDDY | 2022-02-24 00:00:00 | 4330.55 | 3101 | 2486375 | -2750 | 2022-02-11 00:00:00
75 | FUTSTK | TATACONSUM | 2022-02-24 00:00:00 | 700.9 | 3084 | 10604925 | 19575 | 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
79 | FUTSTK | POWERGRID | 2022-02-24 00:00:00 | 202.8 | 3054 | 31699352 | 4826365 | 2022-02-11 00:00:00
80 | FUTSTK | ACC | 2022-02-24 00:00:00 | 2247.6 | 3053 | 2171250 | -20250 | 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
82 | FUTSTK | HDFCLIFE | 2022-02-24 00:00:00 | 595.25 | 3007 | 22272800 | -118800 | 2022-02-11 00:00:00