916Equity_Strategy.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Symbol	Trade	Date	Price	Quantity	Ex. date	Ex. Price	Profit	Net p&L	Cum Pnl
2	PFIZER	Long (max loss)	2/6/15 9:15	2049	5	2/6/15 10:38	2004.05	-44.95	-224.75	-224.75
3	PFIZER	Long (max loss)	2/6/15 9:15	2049	5	2/6/15 10:38	2004.05	-44.95	-224.75	-449.50
4	TATAMOTORS	Short	2/6/15 9:15	560	18	2/6/15 15:14	559.7	0.3	5.40	-444.10
5	TATAMOTORS	Short	2/6/15 9:15	560	18	2/6/15 15:14	559.7	0.3	5.40	-438.70
6	SUNTV	Long (profit)	2/9/15 9:15	399.05	25	2/9/15 9:20	403.65	4.6	115.00	-323.70
7	SUNTV	Long	2/9/15 9:15	399.05	25	2/9/15 15:14	414.75	15.7	392.50	68.80
8	APOLLOTYRE	Short (profit)	2/9/15 9:15	198.25	50	2/9/15 9:22	192.15	6.1	305.00	373.80
9	APOLLOTYRE	Short	2/9/15 9:15	198.25	50	2/9/15 15:14	186.55	11.7	585.00	958.80
10	DLF	Short (max loss)	2/10/15 9:15	148.75	67	2/10/15 9:20	152.65	-3.9	-261.30	697.50
11	DLF	Short (max loss)	2/10/15 9:15	148.75	67	2/10/15 9:20	152.65	-3.9	-261.30	436.20
12	NATIONALUM	Long (profit)	2/11/15 9:15	52.3	191	2/11/15 9:16	52.8	0.5	95.50	531.70
13	NATIONALUM	Long (max loss)	2/11/15 9:15	52.3	191	2/11/15 9:18	51.8	-0.5	-95.50	436.20
14	SRF	Short	2/11/15 9:15	939	11	2/11/15 15:14	933.55	5.45	59.95	496.15
15	SRF	Short	2/11/15 9:15	939	11	2/11/15 15:14	933.55	5.45	59.95	556.10
16	PIIND	Long (max loss)	2/12/15 9:15	539	19	2/12/15 9:18	531.2	-7.8	-148.20	407.90
17	PIIND	Long (max loss)	2/12/15 9:15	539	19	2/12/15 9:18	531.2	-7.8	-148.20	259.70
18	VOLTAS	Short (max loss)	2/12/15 9:15	249.85	40	2/12/15 10:10	255.25	-5.4	-216.00	43.70
19	VOLTAS	Short (max loss)	2/12/15 9:15	249.85	40	2/12/15 10:10	255.25	-5.4	-216.00	-172.30
20	BHEL	Short (max loss)	2/13/15 9:15	168.47	59	2/13/15 9:32	170.3	-1.83	-107.97	-280.27
21	BHEL	Short (max loss)	2/13/15 9:15	168.47	59	2/13/15 9:32	170.3	-1.83	-107.97	-388.24
22	HEROMOTOCO	Short (profit)	2/18/15 9:15	2714.8	4	2/18/15 9:19	2699.4	15.4	61.60	-326.64
23	HEROMOTOCO	Short	2/18/15 9:15	2714.8	4	2/18/15 15:14	2660.05	54.75	219.00	-107.64
24	BEL	Long (profit)	2/27/15 9:15	114.55	87	2/27/15 9:19	115.85	1.3	113.10	5.46
25	BEL	Long	2/27/15 9:15	114.55	87	2/27/15 15:14	114.15	-0.4	-34.80	-29.34
26	JINDALSTEL	Long (max loss)	3/9/15 9:15	196.5	51	3/9/15 9:17	194.3	-2.2	-112.20	-141.54
27	JINDALSTEL	Long (max loss)	3/9/15 9:15	196.5	51	3/9/15 9:17	194.3	-2.2	-112.20	-253.74
28	MINDTREE	Short (profit)	3/9/15 9:15	700	14	3/9/15 9:37	684.95	15.05	210.70	-43.04
29	MINDTREE	Short	3/9/15 9:15	700	14	3/9/15 15:14	705	-5	-70.00	-113.04
30	MFSL	Long (profit)	3/12/15 9:15	495.5	20	3/12/15 9:20	506.5	11	220.00	106.96
31	MFSL	Long	3/12/15 9:15	495.5	20	3/12/15 15:14	489.6	-5.9	-118.00	-11.04
32	BAJAJFINSV	Long (max loss)	3/13/15 9:15	1552.1	6	3/13/15 9:24	1540	-12.1	-72.60	-83.64
33	BAJAJFINSV	Long (max loss)	3/13/15 9:15	1552.1	6	3/13/15 9:24	1540	-12.1	-72.60	-156.24
34	JINDALSTEL	Short (profit)	3/17/15 9:15	184.3	54	3/17/15 12:44	180.1	4.2	226.80	70.56
35	JINDALSTEL	Short	3/17/15 9:15	184.3	54	3/17/15 15:14	174.2	10.1	545.40	615.96
36	JINDALSTEL	Short (max loss)	3/23/15 9:15	143	70	3/23/15 9:45	150.7	-7.7	-539.00	76.96
37	JINDALSTEL	Short (max loss)	3/23/15 9:15	143	70	3/23/15 9:45	150.7	-7.7	-539.00	-462.04
38	TORNTPHARM	Long	4/6/15 9:15	1243.6	8	4/6/15 15:14	1240.95	-2.65	-21.20	-483.24
39	TORNTPHARM	Long	4/6/15 9:15	1243.6	8	4/6/15 15:14	1240.95	-2.65	-21.20	-504.44
40	SUNTV	Short	4/6/15 9:15	416.2	24	4/6/15 15:14	410.4	5.8	139.20	-365.24
41	SUNTV	Short	4/6/15 9:15	416.2	24	4/6/15 15:14	410.4	5.8	139.20	-226.04
42	BALKRISIND	Long (max loss)	4/9/15 9:15	350	29	4/9/15 9:17	346.95	-3.05	-88.45	-314.49
43	BALKRISIND	Long (max loss)	4/9/15 9:15	350	29	4/9/15 9:17	346.95	-3.05	-88.45	-402.94
44	PIIND	Long (max loss)	4/13/15 9:15	770.25	13	4/13/15 9:36	733.45	-36.8	-478.40	-881.34
45	PIIND	Long (max loss)	4/13/15 9:15	770.25	13	4/13/15 9:36	733.45	-36.8	-478.40	-1359.74
46	NMDC	Short (max loss)	4/20/15 9:15	128.25	78	4/20/15 9:24	129.65	-1.4	-109.20	-1468.94
47	NMDC	Short (max loss)	4/20/15 9:15	128.25	78	4/20/15 9:24	129.65	-1.4	-109.20	-1578.14
48	SUNPHARMA	Short (profit)	4/21/15 9:15	951.9	11	4/21/15 9:18	931.4	20.5	225.50	-1352.64
49	SUNPHARMA	Short	4/21/15 9:15	951.9	11	4/21/15 15:14	951.3	0.6	6.60	-1346.04
50	WIPRO	Short (profit)	4/22/15 9:15	208.97	48	4/22/15 13:47	206.55	2.42	116.16	-1229.88
51	WIPRO	Short	4/22/15 9:15	208.97	48	4/22/15 15:14	204.81	4.16	199.68	-1030.20
52	TORNTPHARM	Long (profit)	4/29/15 9:15	1280	8	4/29/15 9:16	1308	28	224.00	-806.20
53	TORNTPHARM	Long (max loss)	4/29/15 9:15	1280	8	4/29/15 10:17	1251.95	-28.05	-224.40	-1030.60
54	SRTRANSFIN	Short (profit)	5/4/15 9:15	910.65	11	5/4/15 9:17	873.6	37.05	407.55	-623.05
55	SRTRANSFIN	Short	5/4/15 9:15	910.65	11	5/4/15 15:14	828.45	82.2	904.20	281.15
56	PEL	Long (max loss)	5/8/15 9:15	995.35	10	5/8/15 9:17	983.95	-11.4	-114.00	167.15
57	PEL	Long (max loss)	5/8/15 9:15	995.35	10	5/8/15 9:17	983.95	-11.4	-114.00	53.15
58	SHREECEM	Long	5/13/15 9:15	11312.05	1	5/13/15 15:14	11150	-162.05	-162.05	-108.90
59	SHREECEM	Long	5/13/15 9:15	11312.05	1	5/13/15 15:14	11150	-162.05	-162.05	-270.95
60	MANAPPURAM	Long (max loss)	5/15/15 9:15	36.85	271	5/15/15 9:29	36	-0.85	-230.35	-501.30
61	MANAPPURAM	Long (max loss)	5/15/15 9:15	36.85	271	5/15/15 9:29	36	-0.85	-230.35	-731.65
62	TATASTEEL	Short (profit)	5/21/15 9:15	346.5	29	5/21/15 10:21	342.45	4.05	117.45	-614.20
63	TATASTEEL	Short	5/21/15 9:15	346.5	29	5/21/15 15:14	341.6	4.9	142.10	-472.10
64	BRITANNIA	Long (profit)	5/22/15 9:15	1220.17	8	5/22/15 9:16	1245.35	25.18	201.44	-270.66
65	BRITANNIA	Long	5/22/15 9:15	1220.17	8	5/22/15 15:14	1217.8	-2.37	-18.96	-289.62
66	MPHASIS	Long (profit)	5/25/15 9:15	385.4	26	5/25/15 10:09	388.4	3	78.00	-211.62
67	MPHASIS	Long (max loss)	5/25/15 9:15	385.4	26	5/25/15 11:28	382.4	-3	-78.00	-289.62
68	TATAMOTORS	Short (profit)	5/27/15 9:15	469.35	21	5/27/15 9:16	466.3	3.05	64.05	-225.57
69	TATAMOTORS	Short (max loss)	5/27/15 9:15	469.35	21	5/27/15 9:32	472.4	-3.05	-64.05	-289.62
70	AMARAJABAT	Long (profit)	5/29/15 9:15	897.2	11	5/29/15 9:17	903.1	5.9	64.90	-224.72
71	AMARAJABAT	Long (max loss)	5/29/15 9:15	897.2	11	5/29/15 9:30	891.3	-5.9	-64.90	-289.62
72	SUNPHARMA	Short (profit)	6/1/15 9:15	904.9	11	6/1/15 9:20	892.2	12.7	139.70	-149.92
73	SUNPHARMA	Short	6/1/15 9:15	904.9	11	6/1/15 15:14	878.85	26.05	286.55	136.63
74	ADANIENT	Short (profit)	6/3/15 9:15	509.6	20	6/3/15 9:17	445.9	63.7	1274.00	1410.63
75	ADANIENT	Short	6/3/15 9:15	509.6	20	6/3/15 15:14	109.2	400.4	8008.00	9418.63
76	SUNTV	Short (profit)	6/8/15 9:15	295.4	34	6/8/15 9:19	278.6	16.8	571.20	9989.83
77	SUNTV	Short	6/8/15 9:15	295.4	34	6/8/15 15:14	277.55	17.85	606.90	10596.73
78	SUNTV	Short (max loss)	6/23/15 9:15	316.35	32	6/23/15 9:32	323	-6.65	-212.80	10383.93
79	SUNTV	Short (max loss)	6/23/15 9:15	316.35	32	6/23/15 9:32	323	-6.65	-212.80	10171.13
80	CANBK	Short (max loss)	6/25/15 9:15	295.8	34	6/25/15 9:27	297.4	-1.6	-54.40	10116.73
81	CANBK	Short (max loss)	6/25/15 9:15	295.8	34	6/25/15 9:27	297.4	-1.6	-54.40	10062.33
82	BHARATFORG	Short (max loss)	6/29/15 9:15	520.53	19	6/29/15 9:48	533.05	-12.52	-237.88	9824.45
83	BHARATFORG	Short (max loss)	6/29/15 9:15	520.53	19	6/29/15 9:48	533.05	-12.52	-237.88	9586.57
84	TATACHEM	Long	7/1/15 9:15	440.2	23	7/1/15 15:14	436.7	-3.5	-80.50	9506.07
85	TATACHEM	Long	7/1/15 9:15	440.2	23	7/1/15 15:14	436.7	-3.5	-80.50	9425.57
86	MINDTREE	Long	7/17/15 9:15	634.25	16	7/17/15 15:14	632.98	-1.27	-20.32	9405.25
87	MINDTREE	Long	7/17/15 9:15	634.25	16	7/17/15 15:14	632.98	-1.27	-20.32	9384.93
88	FEDERALBNK	Short	7/20/15 9:15	69.8	143	7/20/15 15:14	70.85	-1.05	-150.15	9234.78
89	FEDERALBNK	Short	7/20/15 9:15	69.8	143	7/20/15 15:14	70.85	-1.05	-150.15	9084.63
90	INFY	Long (profit)	7/21/15 9:15	539.83	19	7/21/15 13:53	561.3	21.47	407.93	9492.56
91	INFY	Long	7/21/15 9:15	539.83	19	7/21/15 15:14	555.4	15.57	295.83	9788.39
92	SUNPHARMA	Short (profit)	7/21/15 9:15	818.1	12	7/21/15 9:16	808.05	10.05	120.60	9908.99
93	SUNPHARMA	Short (max loss)	7/21/15 9:15	818.1	12	7/21/15 9:33	828.1	-10	-120.00	9788.99
94	MUTHOOTFIN	Long (max loss)	7/23/15 9:15	210.8	47	7/23/15 9:20	206.4	-4.4	-206.80	9582.19
95	MUTHOOTFIN	Long (max loss)	7/23/15 9:15	210.8	47	7/23/15 9:20	206.4	-4.4	-206.80	9375.39
96	HAVELLS	Short	7/27/15 9:15	283.1	35	7/27/15 15:14	283.7	-0.6	-21.00	9354.39
97	HAVELLS	Short	7/27/15 9:15	283.1	35	7/27/15 15:14	283.7	-0.6	-21.00	9333.39
98	BHARTIARTL	Long (max loss)	8/5/15 9:15	427.15	23	8/5/15 9:18	421.75	-5.4	-124.20	9209.19
99	BHARTIARTL	Long (max loss)	8/5/15 9:15	427.15	23	8/5/15 9:18	421.75	-5.4	-124.20	9084.99
100	SUNTV	Short (max loss)	8/11/15 9:15	322.1	31	8/11/15 9:42	329.9	-7.8	-241.80	8843.19