Brokerage Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	U	V
1	Date	Broker	Script Name	Product	Mode	Qty	Buy Price	Sell Price	Buy Total	Sell Total	Turnover	Brokerage	Trans Charges	Stamp Duty	STT	SEBI Tax	GST	DP Charge	Charges Total	Net P&L	15813.59

2	04-04-2022	Zerodha	CUB	EQ	CNC	500	133.20	135.65	66600.00	67825.00	134425.00	0	4.37	13.44	134.43	0.2	0.82	15.93	169.19	1055.81
3	05-04-2022	Zerodha	NIFTY 7th APR 18400 CE	OPT	MIS	50	210.50	216.00	10525.00	10800.00	21325.00	40	10.66	2.13	5.4	0.03	9.12	0	67.34	207.66
4	06-04-2022	Zerodha	VAIBHAVGBL	EQ	CNC	50	468.70	515.00	23435.00	25750.00	49185.00	0	1.6	4.92	49.19	0.07	0.3	15.93	72.01	2242.99
5	07-04-2022	Zerodha	MAZDOCK	EQ	CNC	500	265.51	281.10	132755.00	140550.00	273305.00	0	8.88	27.33	273.31	0.41	1.67	15.93	327.53	7467.47
6	08-04-2022	Zerodha	INDUSTOWER APR 190 PE	OPT	CNC	2800	1.40	1.00	3920.00	2800.00	6720.00	40	3.36	0.67	1.4	0.01	7.81	0	53.25	-1173.25
7	08-04-2022	Zerodha	INDUSTOWER APR 205 PE	OPT	CNC	2800	2.85	3.80	7980.00	10640.00	18620.00	40	9.31	1.86	5.32	0.03	8.88	0	65.4	2594.60
8	08-04-2022	Zerodha	RBLBANK APR 125 PE	OPT	MIS	2900	6.80	3.10	19720.00	8990.00	28710.00	40	14.36	2.87	4.5	0.04	9.79	0	71.56	-10801.56
9	12-04-2022	Zerodha	MAZDOCK	EQ	CNC	500	278.60	306.00	139300.00	153000.00	292300.00	0	9.5	29.23	292.3	0.44	1.79	15.93	349.19	13350.81
10	12-04-2022	Zerodha	INDUSTOWER APR 200 PE	OPT	MIS	2800	2.50	2.85	7000.00	7980.00	14980.00	40	7.49	1.5	3.99	0.02	8.55	0	61.55	918.45
11	13-04-2022	Zerodha	NIFTY 13th APR 17250 CE	OPT	CNC	200	247.90	225.65	49580.00	45130.00	94710.00	40	47.36	9.47	22.57	0.14	15.75	0	135.29	-4585.29
12	13-04-2022	Zerodha	NIFTY 13th APR 17300 CE	OPT	CNC	400	175.65	204.10	70260.00	81640.00	151900.00	40	75.95	15.19	40.82	0.23	20.91	0	193.1	11186.90
13	13-04-2022	Zerodha	NIFTY 13th APR 17350 CE	OPT	CNC	200	164.34	125.65	32868.00	25130.00	57998.00	40	29	5.8	12.57	0.09	12.44	0	99.9	-7837.90
14	18-04-2022	Zerodha	NIFTY 22 DEC 15000 PE	OPT	CNC	50	206.00	231.10	10300.00	11555.00	21855.00	40	10.93	2.19	5.78	0.03	9.17	0	68.1	1186.90
15	ert
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100