Spreadsheet: 271567d1381983924-how-to-get-values-automatically-from-a-sheet-to-another-sheet-new-microsoft-office-excel-worksheet-2-
Sheet: Sheet1

Option Chain (Equity Derivatives) | Underlying Index: NIFTY 6089.05  As on Oct 15, 2013 15:30:41 IST
View Options Contracts for:
OR
Filter by: [NAME]
Futures contracts
CALLS |  |  |  |  |  |  |  |  |  |  |  | PUTS
Chart | OI | Chng in OI | Volume | IV | LTP | Net Chng | Bid | Bid | Ask | Ask | Strike Price | Bid | Bid | Ask | Ask | Net Chng | LTP | IV | Volume | Chng in OI | OI | Chart
 |  |  |  |  |  |  | Qty | Price | Price | Qty |  | Qty | Price | Price | Qty
 | 900 | - | - | - | 1970 | - | 100 | 2143.5 | 2405 | 100 | 3850 | 500 | 0.1 | 0.9 | 500 | - | 1 | - | - | - | 600
 | - | - | - | - | - | - | 100 | 2093.5 | 2355 | 100 | 3900 | 500 | 0.1 | 0.9 | 500 | - | 0.2 | - | - | - | 300
 | - | - | - | - | - | - | 100 | 2043.5 | 2305 | 100 | 3950 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | 135150 | -1050 | 122 | - | 2097 | -32 | 50 | 2090.35 | 2101.5 | 100 | 4000 | 1300 | 0.35 | 0.4 | 150 | -0.2 | 0.4 | 70.1 | 180 | 4550 | 57850
 | - | - | - | - | - | - | 100 | 1943.5 | 2205 | 100 | 4050 | 500 | 0.1 | 0.85 | 500 | - | 0.25 | - | - | - | 500
 | 800 | - | - | - | 1085 | - | 100 | 1893.5 | 2155 | 100 | 4100 | 2800 | 0.25 | 0.9 | 500 | - | 0.6 | - | - | - | 7500
 | - | - | - | - | - | - | 100 | 1843.5 | 2105 | 100 | 4150 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | - | - | - | - | - | - | 100 | 1793.5 | 2055 | 100 | 4200 | 500 | 0.2 | 0.85 | 900 | -0.35 | 0.55 | 64.52 | 4 | - | 700
 | - | - | - | - | - | - | 100 | 1743.5 | 2005 | 100 | 4250 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | - | - | - | - | - | - | 100 | 1693.5 | 1955 | 100 | 4300 | 2000 | 0.3 | 0.55 | 1000 | -0.15 | 0.55 | 60.79 | 44 | - | 5200
 | - | - | - | - | - | - | 100 | 1643.5 | 1905 | 100 | 4350 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | 123000 | - | 351 | - | 1694 | -33.4 | 50 | 1693.3 | 1701.8 | 100 | 4400 | 1550 | 0.4 | 0.45 | 1050 | -0.25 | 0.45 | 56.03 | 453 | -2950 | 57250
 | - | - | - | - | - | - | 100 | 1543.5 | 1805 | 100 | 4450 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | 179900 | -5300 | 231 | 60.87 | 1610.5 | -24.15 | 50 | 1592.9 | 1601.25 | 250 | 4500 | 13150 | 0.55 | 0.6 | 900 | -0.2 | 0.6 | 54.02 | 1108 | -41250 | 434100
 | - | - | - | - | - | - | 100 | 1443.5 | 1705 | 100 | 4550 | 500 | 0.1 | 0.9 | 500 | - | - | - | - | - | -
 | 550 | - | - | - | 1525.85 | - | 100 | 1393.5 | 1655 | 100 | 4600 | 1300 | 0.5 | 0.6 | 750 | -0.35 | 0.5 | 49.56 | 117 | -1000 | 132350
 | - | - | - | - | - | - | 100 | 1349.5 | 1605.5 | 100 | 4650 | 250 | 0.5 | 1.25 | 500 | - | - | - | - | - | -
 | 61300 | - | 6 | 75.01 | 1425.8 | -2.65 | 250 | 1349.7 | 1411.75 | 250 | 4700 | 500 | 0.75 | 0.8 | 1000 | -0.1 | 0.8 | 48.43 | 99 | -1900 | 221900
 | - | - | - | - | - | - | 100 | 1249.5 | 1550.5 | 100 | 4750 | 500 | 0.25 | 2 | 500 | - | 1 | - | - | - | 50
 | 38250 | -3650 | 173 | 67.37 | 1323.35 | -8.25 | 50 | 1296.7 | 1308.85 | 50 | 4800 | 200 | 1 | 1.05 | 100 | -0.35 | 1.05 | 46.3 | 1106 | -6150 | 476400
 | - | - | - | - | - | - | 100 | 1155.5 | 1411 | 100 | 4850 | 10000 | 0.3 | 1.95 | 50 | - | 1.35 | - | - | - | 2050
 | 47400 | -200 | 8 | - | 1195.05 | -32.95 | 200 | 1196.6 | 1208.55 | 100 | 4900 | 650 | 1.35 | 1.4 | 50 | -0.3 | 1.35 | 44.04 | 2520 | -27450 | 619250
 | - | - | - | - | - | - | 100 | 1061.5 | 1314 | 100 | 4950 | 100 | 1.05 | 2.1 | 500 | 0.3 | 1.8 | 43.79 | 20 | -1000 | 54500
 | 397800 | 350 | 162 | - | 1097.8 | -38 | 50 | 1097.75 | 1102.9 | 450 | 5000 | 5650 | 1.8 | 2 | 8100 | -0.25 | 1.8 | 41.94 | 5513 | -56450 | 2023800
 | - | - | - | - | - | - | 100 | 967.5 | 1214 | 100 | 5050 | 50 | 1.85 | - | - | 0.05 | 2.15 | 41.07 | 2 | - | 56050
 | 696600 | -250 | 38 | 45.36 | 1017 | -21.05 | 50 | 998.35 | 1003.85 | 50 | 5100 | 550 | 2.3 | 2.35 | 50 | -0.2 | 2.35 | 39.69 | 6425 | -32300 | 1698000
 | 100 | - | - | - | 800 | - | 100 | 874.2 | 1117 | 100 | 5150 | 50 | 1.6 | 3.7 | 250 | -0.45 | 2.05 | 37.11 | 3 | - | 46550
 | 432150 | -6650 | 270 | - | 900 | -39.75 | 450 | 902 | 905.9 | 250 | 5200 | 2450 | 3.05 | 3.15 | 300 | -0.4 | 3.05 | 37.36 | 11343 | -69100 | 1756300
 | 250 | - | - | - | 674.4 | - | 100 | 826.1 | 885.95 | 100 | 5250 | 50 | 3.25 | 3.7 | 50 | 0.15 | 3.7 | 36.53 | 1218 | -29450 | 121950
 | 664650 | -57800 | 1477 | - | 805.65 | -33.4 | 50 | 801.75 | 806.9 | 100 | 5300 | 400 | 4.35 | 4.5 | 1750 | 0.2 | 4.35 | 35.5 | 23197 | -142150 | 2200550
 | 500 | - | - | - | 587.7 | - | 100 | 726.6 | 787.7 | 100 | 5350 | 2000 | 5.05 | 7.95 | 250 | 0.4 | 5.5 | 34.91 | 237 | -100 | 217400
 | 765650 | -6300 | 665 | - | 705.4 | -33.6 | 50 | 705 | 708.95 | 150 | 5400 | 8500 | 6.55 | 6.7 | 600 | 0.8 | 6.7 | 34.09 | 33502 | -99450 | 3572200
 | 2100 | - | - | - | 560 | - | 100 | 634.15 | 685.2 | 100 | 5450 | 200 | 7.1 | 8.6 | 50 | 1.95 | 8.75 | 33.74 | 1287 | -17000 | 75700
 | 971000 | -117050 | 3480 | - | 610.6 | -35.5 | 100 | 610.5 | 612.85 | 50 | 5500 | 1000 | 9.4 | 9.85 | 550 | 1.25 | 9.9 | 32.41 | 71974 | 107400 | 4309800
 | 1250 | - | - | - | 442.05 | - | 100 | 553.2 | 572.9 | 100 | 5550 | 50 | 10 | 12.6 | 100 | -0.1 | 10.1 | 30.33 | 773 | -19350 | 96800
 | 723250 | -37100 | 1187 | 19.8 | 515 | -34.3 | 150 | 513.25 | 516.75 | 50 | 5600 | 2850 | 13.6 | 13.95 | 100 | 1.3 | 13.65 | 30.17 | 79128 | -55050 | 3878750
 | 2500 | - | - | - | 485.65 | - | 100 | 459.1 | 480.7 | 50 | 5650 | 150 | 16.5 | 18 | 100 | 1.95 | 17 | 29.47 | 547 | -7850 | 163000
 | 1021350 | 8750 | 2218 | 22.22 | 421.75 | -34.35 | 250 | 420 | 423.75 | 50 | 5700 | 1600 | 20.1 | 20.45 | 50 | 2.25 | 20.2 | 28.38 | 133720 | 597800 | 6203050
 | 31500 | -150 | 8 | 31.24 | 400 | -9.85 | 50 | 371.5 | 384.15 | 50 | 5750 | 200 | 24.45 | 25.5 | 50 | 2.65 | 24.9 | 27.58 | 1437 | 11550 | 227050
 | 1591300 | 27200 | 6934 | 22.5 | 332.65 | -33.5 | 50 | 333 | 335.25 | 200 | 5800 | 450 | 31.05 | 31.25 | 400 | 4.3 | 31.1 | 26.91 | 189952 | -229050 | 4545100
 | 58300 | -1150 | 56 | 22.61 | 291 | -28.4 | 50 | 284.15 | 301.15 | 100 | 5850 | 200 | 35.85 | 38.5 | 150 | 4.55 | 38 | 26.04 | 3252 | -9000 | 345000
 | 2180900 | -88700 | 21203 | 22.26 | 250.1 | -29.3 | 500 | 249.05 | 250.6 | 50 | 5900 | 1650 | 47.2 | 47.55 | 1750 | 6.75 | 47.2 | 25.36 | 306789 | 148300 | 4414300
 | 86050 | -7450 | 300 | 20.28 | 204.85 | -33.95 | 250 | 207.1 | 210 | 50 | 5950 | 50 | 57 | 58 | 1000 | 7.1 | 56.9 | 24.34 | 5202 | 48050 | 186350
 | 3374650 | -41000 | 45926 | 21.66 | 176.3 | -25.05 | 50 | 174.9 | 176.5 | 50 | 6000 | 250 | 72.15 | 72.3 | 400 | 10.85 | 72.05 | 24.03 | 384131 | 748100 | 5228950
 | 176100 | -11150 | 1643 | 21.06 | 142.45 | -22.7 | 400 | 135.7 | 143.25 | 100 | 6050 | 300 | 86 | 87.75 | 700 | 12.05 | 87.5 | 23.2 | 4181 | 8150 | 105300
 | 3922150 | -319600 | 224737 | 20.46 | 111.95 | -22.2 | 200 | 111.1 | 111.95 | 200 | 6100 | 50 | 106.2 | 106.85 | 250 | 13.45 | 106.05 | 22.39 | 307613 | 437600 | 3324550
 | 368650 | 19250 | 7255 | 19.99 | 85.8 | -20.6 | 400 | 85.7 | 86.9 | 50 | 6150 | 250 | 130 | 131.95 | 250 | 17.35 | 130 | 21.99 | 3263 | 14550 | 34000
 | 4447800 | 339900 | 375129 | 19.6 | 63.95 | -16.85 | 450 | 63.95 | 64 | 50 | 6200 | 50 | 155.4 | 156.9 | 50 | 18.25 | 155.15 | 21.11 | 87330 | 202100 | 1607000
 | 430050 | 7150 | 4268 | 19.32 | 46.5 | -13.8 | 500 | 45.1 | 47.35 | 50 | 6250 | 250 | 162.85 | 206.8 | 2000 | -37.8 | 159.2 | 14.39 | 15 | 300 | 700
 | 4917050 | 495900 | 296406 | 19.05 | 32.65 | -11 | 4300 | 32.65 | 33 | 500 | 6300 | 50 | 221.9 | 225 | 100 | 24.45 | 221.75 | 20.48 | 10700 | 29000 | 538900
 | 169750 | 9850 | 2376 | 18.98 | 22.75 | -7.2 | 400 | 21.5 | 23.35 | 500 | 6350 | 2000 | 238.1 | 282.45 | 2000 | -170 | 270 | 22.91 | 1 | 50 | 50
 | 3166000 | 231500 | 186006 | 18.67 | 14.75 | -5.6 | 750 | 14.65 | 14.75 | 4250 | 6400 | 50 | 302.6 | 306.95 | 50 | 30.6 | 303.6 | 20.75 | 1943 | -12750 | 105300
 | 103050 | -5350 | 434 | 18.5 | 9.4 | -3.4 | 1000 | 9 | 9.4 | 150 | 6450 | 50 | 220 | 426.3 | 2000 | - | - | - | - | - | -
 | 3813150 | 200450 | 102632 | 17.94 | 5.2 | -2.5 | 1500 | 5.2 | 5.25 | 2950 | 6500 | 100 | 391.5 | 395 | 50 | 32.2 | 391.9 | 20.46 | 1481 | -13300 | 489200
 | 17200 | 50 | 10 | 18.27 | 3.5 | -2 | 50000 | 1 | 3.5 | 1450 | 6550 | 50 | 310 | 514.5 | 100 | - | - | - | - | - | -
 | 993900 | 106750 | 39306 | 18.13 | 2 | -0.65 | 200 | 1.95 | 2 | 50 | 6600 | 100 | 469 | 494.15 | 100 | 24 | 482 | - | 90 | -150 | 7500
 | 6150 | - | - | - | 1.5 | -0.4 | 150 | 1.3 | 1.95 | 50 | 6650 | 5400 | 405 | 614.5 | 100 | - | - | - | - | - | -
 | 732300 | 14350 | 11082 | 18.6 | 0.8 | -0.4 | 100 | 0.75 | 0.85 | 2000 | 6700 | 100 | 584.65 | 590.05 | 50 | 32 | 585 | 22.9 | 304 | 1850 | 60300
 | 1000 | - | - | - | 17 | - | 1000 | 0.5 | 2 | 200 | 6750 | 1000 | 428.5 | 717.5 | 100 | - | - | - | - | - | -
 | 370900 | -1300 | 1027 | 20.06 | 0.5 | -0.2 | 650 | 0.5 | 0.6 | 3100 | 6800 | 1000 | 478.5 | 767.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | 500 | 0.2 | 1 | 500 | 6850 | 1000 | 526.5 | 820.5 | 100 | - | - | - | - | - | -
 | 54100 | - | 78 | 22.94 | 0.6 | 0.1 | 1200 | 0.45 | 0.5 | 500 | 6900 | 1000 | 576.5 | 870.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | 500 | 0.2 | 1 | 500 | 6950 | 1000 | 623.5 | 920.5 | 100 | - | - | - | - | - | -
 | 149950 | -1050 | 2479 | 24.83 | 0.5 | -0.05 | 1050 | 0.5 | 0.55 | 1950 | 7000 | 350 | 883 | 887.45 | 50 | 35.95 | 884 | 32.16 | 389 | 450 | 179200
 | - | - | - | - | - | - | - | - | - | - | 7050 | 1000 | 720.5 | 1023.5 | 100 | - | - | - | - | - | -
 | 1650 | 50 | 274 | 25.75 | 0.3 | -0.3 | 950 | 0.3 | 0.45 | 4350 | 7100 | 1000 | 767.5 | 1076.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | - | - | - | - | 7150 | 1000 | 817.5 | 1126.5 | 100 | - | - | - | - | - | -
 | 1150 | - | - | - | 0.15 | - | 100 | 0.15 | 0.95 | 1800 | 7200 | 1000 | 867.5 | 1176.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | - | - | - | - | 7250 | 1000 | 914.5 | 1229.5 | 100 | - | - | - | - | - | -
 | 1000 | - | - | - | 0.55 | - | - | - | - | - | 7300 | 1000 | 964.5 | 1279.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | - | - | - | - | 7350 | 1000 | 1011.5 | 1332.5 | 100 | - | - | - | - | - | -
 | - | - | - | - | - | - | - | - | - | - | 7400 | 1000 | 1061.5 | 1382.5 | 100 | - | - | - | - | - | -
 | 100 | - | - | - | 0.5 | - | - | - | - | - | 7450 | 1000 | 1108.5 | 1432.5 | 100 | - | - | - | - | - | -
 | 250 | - | - | - | 0.1 | - | - | - | 1 | 10000 | 7500 | 50 | 1377.3 | 1383.1 | 50 | 32.5 | 1375 | - | 117 | 3350 | 58700
 | 2000 | - | - | - | 1 | - | - | - | 1 | 2000 | 7550 | 1000 | 1208.5 | 1535.5 | 100 | - | - | - | - | - | -
 | 800 | - | - | - | 0.3 | - | - | - | - | - | 7600 | 1000 | 1255.5 | 1588.5 | 100 | - | - | - | - | - | -
Top
Note : 10% interest rate is applied while computing implied volatility.
Highlighted options are in-the-money.