pandas_multiple.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		SYMBOL	EXPIRY_DT	RCD_DATE	NXT_DY	OPTION_TYP	STRIKE_PR	OPEN	HIGH	LOW	CLSE	CONTRACTS	OPEN_INT	S	DFF	MNDF	IV	MEAN_IV
2	0	ADANIPORTS	2015-01-29 00:00:00	2014-12-24 00:00:00	2014-12-26 00:00:00	CE	290	14	14	10	10.4	28	37000	286.5	3.5	3.5	0.33435165	0.32876776
3	1	ADANIPORTS	2015-01-29 00:00:00	2014-12-24 00:00:00	2014-12-26 00:00:00	PE	290	14.85	14.85	13.45	13.5	16	25000	286.5	3.5	3.5	0.32318387	0.32876776
4	2	ADANIPORTS	2015-01-29 00:00:00	2014-12-26 00:00:00	2014-12-29 00:00:00	CE	290	11.35	13	10.3	12.75	55	57000	291.35	1.35	1.35	0.34098914	0.34028111
5	3	ADANIPORTS	2015-01-29 00:00:00	2014-12-26 00:00:00	2014-12-29 00:00:00	PE	290	12.6	12.85	11.15	11.35	12	31000	291.35	1.35	1.35	0.33957308	0.34028111
6	4	ADANIPORTS	2015-01-29 00:00:00	2014-12-29 00:00:00	2014-12-30 00:00:00	CE	300	8.55	10.05	7.8	9.7	199	177000	295.55	4.45	4.45	0.340743	0.34001171
7	5	ADANIPORTS	2015-01-29 00:00:00	2014-12-29 00:00:00	2014-12-30 00:00:00	PE	300	14.4	15.25	13.95	14.1	13	20000	295.55	4.45	4.45	0.33928042	0.34001171
8	6	ADANIPORTS	2015-01-29 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	CE	320	5.2	13.9	5.2	13.25	2038	389000	317.75	2.25	2.25	0.39359211	0.39290419
9	7	ADANIPORTS	2015-01-29 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	PE	320	24.05	24.05	14.8	15.45	66	44000	317.75	2.25	2.25	0.39221627	0.39290419
10	8	ADANIPORTS	2015-01-29 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	CE	320	12.95	14.2	10.75	13.6	767	411000	320.7	0.7	0.7	0.36789744	0.36303204
11	9	ADANIPORTS	2015-01-29 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	PE	320	14.4	17.2	12.05	12.55	120	71000	320.7	0.7	0.7	0.35816664	0.36303204
12	10	ADANIPORTS	2015-01-29 00:00:00	2015-01-01 00:00:00	2015-01-02 00:00:00	CE	320	12.7	15.8	12.15	13.7	479	467000	321.55	1.55	1.55	0.36439696	0.36227582
13	11	ADANIPORTS	2015-01-29 00:00:00	2015-01-01 00:00:00	2015-01-02 00:00:00	PE	320	13.5	14	11.5	12	141	81000	321.55	1.55	1.55	0.36015468	0.36227582
14	12	ADANIPORTS	2015-01-29 00:00:00	2015-01-02 00:00:00	2015-01-05 00:00:00	CE	320	13.3	16.5	12.5	12.95	728	495000	322.25	2.25	2.25	0.33851709	0.34067808
15	13	ADANIPORTS	2015-01-29 00:00:00	2015-01-02 00:00:00	2015-01-05 00:00:00	PE	320	11.9	12.5	8.9	10.85	428	167000	322.25	2.25	2.25	0.34283907	0.34067808
16	14	ADANIPORTS	2015-01-29 00:00:00	2015-01-05 00:00:00	2015-01-06 00:00:00	CE	320	14.5	18	14.1	15.95	416	527000	324.95	4.95	4.95	0.4042356	0.39886348
17	15	ADANIPORTS	2015-01-29 00:00:00	2015-01-05 00:00:00	2015-01-06 00:00:00	PE	320	10.2	11.25	8.5	10.65	188	204000	324.95	4.95	4.95	0.39349136	0.39886348
18	16	ADANIPORTS	2015-01-29 00:00:00	2015-01-06 00:00:00	2015-01-07 00:00:00	CE	320	11.05	20.9	11.05	16.25	943	581000	323.45	3.45	3.45	0.44903095	0.44356558
19	17	ADANIPORTS	2015-01-29 00:00:00	2015-01-06 00:00:00	2015-01-07 00:00:00	PE	320	12.2	14.55	7.95	12.45	587	286000	323.45	3.45	3.45	0.43810021	0.44356558
20	18	ADANIPORTS	2015-01-29 00:00:00	2015-01-07 00:00:00	2015-01-08 00:00:00	CE	320	17.8	19.5	13.4	15.95	259	617000	323.35	3.35	3.35	0.45133119	0.452129435
21	19	ADANIPORTS	2015-01-29 00:00:00	2015-01-07 00:00:00	2015-01-08 00:00:00	PE	320	11	14.95	9.35	12.65	337	277000	323.35	3.35	3.35	0.45292768	0.452129435
22	20	ADANIPORTS	2015-01-29 00:00:00	2015-01-08 00:00:00	2015-01-09 00:00:00	CE	340	8.75	12.7	8.1	11.9	625	521000	336.25	3.75	3.75	0.42339963	0.41016435
23	21	ADANIPORTS	2015-01-29 00:00:00	2015-01-08 00:00:00	2015-01-09 00:00:00	PE	340	19	19	14	14.8	123	120000	336.25	3.75	3.75	0.39692907	0.41016435
24	22	ADANIPORTS	2015-01-29 00:00:00	2015-01-09 00:00:00	2015-01-12 00:00:00	CE	330	20.3	21.7	12.4	14.1	493	438000	333.35	3.35	3.35	0.39896485	0.39896485
25	23	ADANIPORTS	2015-01-29 00:00:00	2015-01-09 00:00:00	2015-01-12 00:00:00	PE	330	7.85	13	7.1	10.75	244	108000	333.35	3.35	3.35	0.39896485	0.39896485
26	24	ADANIPORTS	2015-01-29 00:00:00	2015-01-12 00:00:00	2015-01-13 00:00:00	CE	330	12.6	16.3	11.1	11.8	354	418000	330.6	0.6	0.6	0.40443155	0.40707199
27	25	ADANIPORTS	2015-01-29 00:00:00	2015-01-12 00:00:00	2015-01-13 00:00:00	PE	330	11.2	13.8	9.15	11.35	123	113000	330.6	0.6	0.6	0.40971243	0.40707199
28	26	ADANIPORTS	2015-01-29 00:00:00	2015-01-13 00:00:00	2015-01-14 00:00:00	CE	320	16.95	17.05	11.5	12.65	283	229000	324.8	4.8	4.8	0.37399241	0.37966586
29	27	ADANIPORTS	2015-01-29 00:00:00	2015-01-13 00:00:00	2015-01-14 00:00:00	PE	320	6.4	9	5.9	8.15	270	282000	324.8	4.8	4.8	0.38533931	0.37966586
30	28	ADANIPORTS	2015-01-29 00:00:00	2015-01-14 00:00:00	2015-01-15 00:00:00	CE	330	7.85	13.25	7.85	11.3	542	365000	332.4	2.4	2.4	0.37546139	0.38202841
31	29	ADANIPORTS	2015-01-29 00:00:00	2015-01-14 00:00:00	2015-01-15 00:00:00	PE	330	12.15	13.1	8.4	9.25	139	104000	332.4	2.4	2.4	0.38859543	0.38202841
32	30	ADANIPORTS	2015-01-29 00:00:00	2015-01-15 00:00:00	2015-01-16 00:00:00	CE	330	9.5	12.65	9.1	10.5	211	360000	331.4	1.4	1.4	0.37875432	0.385542755
33	31	ADANIPORTS	2015-01-29 00:00:00	2015-01-15 00:00:00	2015-01-16 00:00:00	PE	330	8	12.6	7.5	9.45	149	108000	331.4	1.4	1.4	0.39233119	0.385542755
34	32	ADANIPORTS	2015-01-29 00:00:00	2015-01-16 00:00:00	2015-01-19 00:00:00	CE	330	8.8	12.65	8.75	10.15	279	333000	332.4	2.4	2.4	0.3569251	0.3609605
35	33	ADANIPORTS	2015-01-29 00:00:00	2015-01-16 00:00:00	2015-01-19 00:00:00	PE	330	10.5	10.6	6.65	7.95	121	145000	332.4	2.4	2.4	0.3649959	0.3609605
36	34	ADANIPORTS	2015-01-29 00:00:00	2015-01-19 00:00:00	2015-01-20 00:00:00	CE	330	10.4	11.9	7.7	8.1	198	352000	329.9	0.1	0.1	0.37411923	0.37411923
37	35	ADANIPORTS	2015-01-29 00:00:00	2015-01-19 00:00:00	2015-01-20 00:00:00	PE	330	6.7	9.55	6.65	8.2	116	124000	329.9	0.1	0.1	0.37411923	0.37411923
38	36	ADANIPORTS	2015-01-29 00:00:00	2015-01-20 00:00:00	2015-01-21 00:00:00	CE	330	8.3	9.85	6.8	8.05	176	351000	331.3	1.3	1.3	0.35642277	0.358843505
39	37	ADANIPORTS	2015-01-29 00:00:00	2015-01-20 00:00:00	2015-01-21 00:00:00	PE	330	7.5	8.95	6.4	6.85	100	122000	331.3	1.3	1.3	0.36126424	0.358843505
40	38	ADANIPORTS	2015-01-29 00:00:00	2015-01-21 00:00:00	2015-01-22 00:00:00	CE	330	8	9.75	6.3	7.1	211	352000	329.95	0.05	0.05	0.36563396	0.369483735
41	39	ADANIPORTS	2015-01-29 00:00:00	2015-01-21 00:00:00	2015-01-22 00:00:00	PE	330	6.4	9.2	5.85	7.3	113	113000	329.95	0.05	0.05	0.37333351	0.369483735
42	40	ADANIPORTS	2015-01-29 00:00:00	2015-01-22 00:00:00	2015-01-23 00:00:00	CE	330	7.45	8.3	5.35	6.9	146	365000	330.7	0.7	0.7	0.35859475	0.370937415
43	41	ADANIPORTS	2015-01-29 00:00:00	2015-01-22 00:00:00	2015-01-23 00:00:00	PE	330	6.65	7.5	6	6.65	109	115000	330.7	0.7	0.7	0.38328008	0.370937415
44	42	ADANIPORTS	2015-01-29 00:00:00	2015-01-23 00:00:00	2015-01-27 00:00:00	CE	350	1.25	8.6	1.25	5.5	2971	365000	346.7	3.3	3.3	0.39442699	0.391569475
45	43	ADANIPORTS	2015-01-29 00:00:00	2015-01-23 00:00:00	2015-01-27 00:00:00	PE	350	16	16	5.15	8.7	118	41000	346.7	3.3	3.3	0.38871196	0.391569475
46	44	ADANIPORTS	2015-01-29 00:00:00	2015-01-27 00:00:00	2015-01-28 00:00:00	CE	350	4.35	6.2	2.9	4.15	1074	487000	345.25	4.75	4.75	0.60785319	0.60530128
47	45	ADANIPORTS	2015-01-29 00:00:00	2015-01-27 00:00:00	2015-01-28 00:00:00	PE	350	9.7	10.5	6.4	8.85	65	45000	345.25	4.75	4.75	0.60274937	0.60530128
48	46	ADANIPORTS	2015-01-29 00:00:00	2015-01-28 00:00:00	2015-01-29 00:00:00	CE	340	6.45	12	2.95	3.8	1028	234000	339.8	0.2	0.2	0.5493813	0.55995144
49	47	ADANIPORTS	2015-01-29 00:00:00	2015-01-28 00:00:00	2015-01-29 00:00:00	PE	340	4	8.95	1.5	4.15	872	92000	339.8	0.2	0.2	0.57052158	0.55995144
50	48	ADANIPORTS	2015-01-29 00:00:00	2015-01-29 00:00:00	1978-01-01 00:00:00	CE	340	3.35	8.95	1	2.85	692	181000	343.45	3.45	3.45	0	0
51	49	ADANIPORTS	2015-01-29 00:00:00	2015-01-29 00:00:00	1978-01-01 00:00:00	PE	340	2.45	3.5	0.05	0.2	269	99000	343.45	3.45	3.45	0	0
52	0	ASIANPAINT	2015-01-29 00:00:00	2014-12-24 00:00:00	2014-12-26 00:00:00	CE	740	26.5	26.75	22	22.65	41	13500	738.55	1.45	1.45	0.25235474	0.254786605
53	1	ASIANPAINT	2015-01-29 00:00:00	2014-12-24 00:00:00	2014-12-26 00:00:00	PE	740	23.45	25.8	23	24.55	99	40500	738.55	1.45	1.45	0.25721847	0.254786605
54	2	ASIANPAINT	2015-01-29 00:00:00	2014-12-26 00:00:00	2014-12-29 00:00:00	CE	730	24.05	25.1	24.05	25.1	2	1000	734.65	4.65	4.65	0.25463324	0.2681431
55	3	ASIANPAINT	2015-01-29 00:00:00	2014-12-26 00:00:00	2014-12-29 00:00:00	PE	730	18.65	22.85	18.65	22.85	5	7500	734.65	4.65	4.65	0.28165296	0.2681431
56	4	ASIANPAINT	2015-01-29 00:00:00	2014-12-29 00:00:00	2014-12-30 00:00:00	CE	760	16.6	28	15.95	27.2	211	35000	764.75	4.75	4.75	0.27933621	0.28018554
57	5	ASIANPAINT	2015-01-29 00:00:00	2014-12-29 00:00:00	2014-12-30 00:00:00	PE	760	31.25	31.25	22.3	22.6	29	10500	764.75	4.75	4.75	0.28103487	0.28018554
58	6	ASIANPAINT	2015-01-29 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	CE	760	27.95	29.3	21	23.35	140	34000	756.85	3.15	3.15	0.28705725	0.28416904
59	7	ASIANPAINT	2015-01-29 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	PE	760	23.25	26.05	21.15	26	22	9000	756.85	3.15	3.15	0.28128083	0.28416904
60	8	ASIANPAINT	2015-01-29 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	CE	760	24.05	25.45	21.6	22.95	82	42500	757.65	2.35	2.35	0.28258555	0.273489105
61	9	ASIANPAINT	2015-01-29 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	PE	760	23.45	25.55	23.2	23.75	27	16500	757.65	2.35	2.35	0.26439266	0.273489105
62	10	ASIANPAINT	2015-01-29 00:00:00	2015-01-01 00:00:00	2015-01-02 00:00:00	CE	760	21	24.1	19.85	21.75	25	45000	755.85	4.15	4.15	0.28387359	0.284772005
63	11	ASIANPAINT	2015-01-29 00:00:00	2015-01-01 00:00:00	2015-01-02 00:00:00	PE	760	25.5	26.05	23.05	26.05	5	16500	755.85	4.15	4.15	0.28567042	0.284772005
64	12	ASIANPAINT	2015-01-29 00:00:00	2015-01-02 00:00:00	2015-01-05 00:00:00	CE	780	17.3	28	16.75	23.65	357	57500	780.05	0.05	0.05	0.27920421	0.279499805
65	13	ASIANPAINT	2015-01-29 00:00:00	2015-01-02 00:00:00	2015-01-05 00:00:00	PE	780	22.5	25.6	22.2	23.65	56	12500	780.05	0.05	0.05	0.2797954	0.279499805
66	14	ASIANPAINT	2015-01-29 00:00:00	2015-01-05 00:00:00	2015-01-06 00:00:00	CE	780	26.05	29	23.25	23.9	119	58500	779.3	0.7	0.7	0.30410535	0.30441906
67	15	ASIANPAINT	2015-01-29 00:00:00	2015-01-05 00:00:00	2015-01-06 00:00:00	PE	780	21.35	24.95	18.75	24.65	52	17000	779.3	0.7	0.7	0.30473277	0.30441906
68	16	ASIANPAINT	2015-01-29 00:00:00	2015-01-06 00:00:00	2015-01-07 00:00:00	CE	760	33.9	34	22.2	24	12	21000	759.55	0.45	0.45	0.31846004	0.33095679
69	17	ASIANPAINT	2015-01-29 00:00:00	2015-01-06 00:00:00	2015-01-07 00:00:00	PE	760	16	27	15	26.35	70	43500	759.55	0.45	0.45	0.34345354	0.33095679
70	18	ASIANPAINT	2015-01-29 00:00:00	2015-01-07 00:00:00	2015-01-08 00:00:00	CE	780	18	26.5	18	22.35	300	86000	775.1	4.9	4.9	0.32472074	0.32472074
71	19	ASIANPAINT	2015-01-29 00:00:00	2015-01-07 00:00:00	2015-01-08 00:00:00	PE	780	28.15	30.25	25.05	27.25	19	18000	775.1	4.9	4.9	0.32472074	0.32472074
72	20	ASIANPAINT	2015-01-29 00:00:00	2015-01-08 00:00:00	2015-01-09 00:00:00	CE	820	11.9	28.2	10.75	26.8	916	68000	822.9	2.9	2.9	0.3222398	0.32192119
73	21	ASIANPAINT	2015-01-29 00:00:00	2015-01-08 00:00:00	2015-01-09 00:00:00	PE	820	25.4	25.4	23.25	23.85	55	13500	822.9	2.9	2.9	0.32160258	0.32192119
74	22	ASIANPAINT	2015-01-29 00:00:00	2015-01-09 00:00:00	2015-01-12 00:00:00	CE	820	28.95	30	19.7	23.2	397	64500	816.45	3.55	3.55	0.3264079	0.3270638
75	23	ASIANPAINT	2015-01-29 00:00:00	2015-01-09 00:00:00	2015-01-12 00:00:00	PE	820	20.75	31.55	18.85	26.85	67	14000	816.45	3.55	3.55	0.3277197	0.3270638
76	24	ASIANPAINT	2015-01-29 00:00:00	2015-01-12 00:00:00	2015-01-13 00:00:00	CE	810	33.9	35.3	24.3	26.2	67	41000	812.15	2.15	2.15	0.35967725	0.357884825
77	25	ASIANPAINT	2015-01-29 00:00:00	2015-01-12 00:00:00	2015-01-13 00:00:00	PE	810	20.05	24.85	20.05	23.8	39	16000	812.15	2.15	2.15	0.3560924	0.357884825
78	26	ASIANPAINT	2015-01-29 00:00:00	2015-01-13 00:00:00	2015-01-14 00:00:00	CE	840	17	28.5	15.5	22.7	1071	120000	836.05	3.95	3.95	0.35187428	0.35079987
79	27	ASIANPAINT	2015-01-29 00:00:00	2015-01-13 00:00:00	2015-01-14 00:00:00	PE	840	24	31	24	26.5	119	27500	836.05	3.95	3.95	0.34972546	0.35079987
80	28	ASIANPAINT	2015-01-29 00:00:00	2015-01-14 00:00:00	2015-01-15 00:00:00	CE	840	25.7	31.45	19.35	25.75	671	90500	844.95	4.95	4.95	0.34043964	0.343018845
81	29	ASIANPAINT	2015-01-29 00:00:00	2015-01-14 00:00:00	2015-01-15 00:00:00	PE	840	20.1	27.8	18.8	21.15	124	33000	844.95	4.95	4.95	0.34559805	0.343018845
82	30	ASIANPAINT	2015-01-29 00:00:00	2015-01-15 00:00:00	2015-01-16 00:00:00	CE	840	23.5	28	20.95	23.2	120	86500	843.45	3.45	3.45	0.32592315	0.32897201
83	31	ASIANPAINT	2015-01-29 00:00:00	2015-01-15 00:00:00	2015-01-16 00:00:00	PE	840	19.95	23.6	17.05	20.15	101	37000	843.45	3.45	3.45	0.33202087	0.32897201
84	32	ASIANPAINT	2015-01-29 00:00:00	2015-01-16 00:00:00	2015-01-19 00:00:00	CE	850	19.25	27.25	18.75	19.5	317	71000	846.8	3.2	3.2	0.32977691	0.33291519
85	33	ASIANPAINT	2015-01-29 00:00:00	2015-01-16 00:00:00	2015-01-19 00:00:00	PE	850	20.55	24.1	17.35	23.1	46	15500	846.8	3.2	3.2	0.33605347	0.33291519
86	34	ASIANPAINT	2015-01-29 00:00:00	2015-01-19 00:00:00	2015-01-20 00:00:00	CE	840	25	25	16.75	17.5	110	80500	835.85	4.15	4.15	0.35256135	0.35482951
87	35	ASIANPAINT	2015-01-29 00:00:00	2015-01-19 00:00:00	2015-01-20 00:00:00	PE	840	19.35	22.5	16.75	21.9	87	45000	835.85	4.15	4.15	0.35709767	0.35482951
88	36	ASIANPAINT	2015-01-29 00:00:00	2015-01-20 00:00:00	2015-01-21 00:00:00	CE	840	19.45	24	17.05	19.6	118	85500	842.2	2.2	2.2	0.35075581	0.34695427
89	37	ASIANPAINT	2015-01-29 00:00:00	2015-01-20 00:00:00	2015-01-21 00:00:00	PE	840	16.5	19.5	15.5	17	53	43500	842.2	2.2	2.2	0.34315273	0.34695427
90	38	ASIANPAINT	2015-01-29 00:00:00	2015-01-21 00:00:00	2015-01-22 00:00:00	CE	850	15.6	23	15	19.8	361	69000	853.65	3.65	3.65	0.35614722	0.359139465
91	39	ASIANPAINT	2015-01-29 00:00:00	2015-01-21 00:00:00	2015-01-22 00:00:00	PE	850	21.25	21.25	14.45	16.45	85	27000	853.65	3.65	3.65	0.36213171	0.359139465
92	40	ASIANPAINT	2015-01-29 00:00:00	2015-01-22 00:00:00	2015-01-23 00:00:00	CE	870	14.55	24.2	14.35	17.9	272	34500	868.5	1.5	1.5	0.38819521	0.365790275
93	41	ASIANPAINT	2015-01-29 00:00:00	2015-01-22 00:00:00	2015-01-23 00:00:00	PE	870	16.5	19.5	13.4	17.25	64	7500	868.5	1.5	1.5	0.34338534	0.365790275
94	42	ASIANPAINT	2015-01-29 00:00:00	2015-01-23 00:00:00	2015-01-27 00:00:00	CE	860	20.1	29.1	16.05	17.35	94	56500	864.25	4.25	4.25	0.34313749	0.34313749
95	43	ASIANPAINT	2015-01-29 00:00:00	2015-01-23 00:00:00	2015-01-27 00:00:00	PE	860	13.65	15.4	8.15	13.1	51	15000	864.25	4.25	4.25	0.34313749	0.34313749
96	44	ASIANPAINT	2015-01-29 00:00:00	2015-01-27 00:00:00	2015-01-28 00:00:00	CE	890	7	16.95	7	13.3	204	34500	889.4	0.6	0.6	0.51757821	0.457611725
97	45	ASIANPAINT	2015-01-29 00:00:00	2015-01-27 00:00:00	2015-01-28 00:00:00	PE	890	14	15.85	3	10.75	40	8500	889.4	0.6	0.6	0.39764524	0.457611725
98	46	ASIANPAINT	2015-01-29 00:00:00	2015-01-28 00:00:00	2015-01-29 00:00:00	CE	900	11.5	23.25	11.5	16.9	928	84000	909.4	9.4	9.4	0.61400998	0.63208646
99	47	ASIANPAINT	2015-01-29 00:00:00	2015-01-28 00:00:00	2015-01-29 00:00:00	PE	900	6.2	15	3.1	8.15	289	51000	909.4	9.4	9.4	0.65016294	0.63208646
100	48	ASIANPAINT	2015-01-29 00:00:00	2015-01-29 00:00:00	1978-01-01 00:00:00	CE	880	35	35	0.35	1.2	913	53000	880.6	0.6	0.6	0	0