stock.xlsx

	A	B	C	D	E	F	H	I	L	M	O	P
1	Date	Price	Stock	total stock	profit	Total profit	Pocket SAR	total pocket SAR	avg Price	profit/lost	Actual payment	Actual Profit

2	Jul-21	33	61	61	0	0	2013	2013	33	0	2013	0
3	Aug-21	34	59	120	0	0	2006	4019	33.5	120	4019	0
4	Sep-21	33	61	181	0.35	63.35	2013	6032	33.3	-90.5	6032	0
5	Oct-21	36	58	239	0	0	2088	8120	34	645.3	8056.65	63.35
6	Nov-21	30	67	306	0	0	2010	10130	33.1	-1224	10066.65	63.35
7	Dec-21	36	56	362	0.35	126.7	2016	12146	33.6	1049.8	12082.65	63.35
8	Jan-22	38	56	418	0	0	2128	14274	34.1	1839.2	14083.95	190.05
9	Feb-22	36	56	474	0	0	2016	16290	34.4	900.6	16099.95	190.05
10	Mar-22	36	56	530	0.335	177.55	2016	18306	34.5	848	18115.95	190.05
11	Apr-22	39	56	586	0	0	2184	20490	35	2637	20122.4	367.6
12	May-22	29	69	655	0	0	2001	22491	34.3	-3930	22123.4	367.6
13	Jun-22	30	67	722	0.35	252.7	2010	24501	33.9	-3104.6	24133.4	367.6
14	Jul-22	34	67	789	0	0	2278	26779	33.9	78.9	26158.7	620.3
15	Aug-22	32	63	852	0	0	2016	28795	33.8	-1618.8	28174.7	620.3
16	Sep-22	32	63	915	0.35	320.25	2016	30811	33.7	-1647	30190.7	620.3
17	Oct-22	30	78	993	0	0	2340	33151	33.4	-3674.1	32210.45	940.55
18	Nov-22	29	69	1062	0	0	2001	35152	33.1	-4672.8	34211.45	940.55
19	Dec-22	38	53	1115	0.335	373.525	2014	37166	33.3	5463.5	36225.45	940.55
20	Jan-23	34	70	1185	0	0	2380	39546	33.4	829.5	38231.925	1314.075
21	Feb-23	33	61	1246	0	0	2013	41559	33.4	-498.4	40244.925	1314.075
22	Mar-23	37	55	1301	0.35	455.35	2035	43594	33.5	4683.6	42279.925	1314.075
23	Apr-23	30	82	1383	0	0	2460	46054	33.3	-4840.5	44284.575	1769.425
24	May-23	33	61	1444	0	0	2013	48067	33.3	-433.2	46297.575	1769.425
25	Jun-23	35	58	1502	0.35	525.7	2030	50097	33.4	2553.4	48327.575	1769.425
26	Jul-23	39	65	1567	0	0	2535	52632	33.6	8775.2	50336.875	2295.125
27	Aug-23	39	52	1619	0	0	2028	54660	33.8	8742.6	52364.875	2295.125
28	Sep-23	30	67	1686	0.335	564.81	2010	56670	33.6	-6406.8	54374.875	2295.125
29	Oct-23	32	81	1767	0	0	2592	59262	33.5	-2827.2	56402.065	2859.935
30	Nov-23	30	67	1834	0	0	2010	61272	33.4	-6419	58412.065	2859.935
31	Dec-23	34	59	1893	0.35	662.55	2006	63278	33.4	1135.8	60418.065	2859.935
32	Jan-24	35	77	1970	0	0	2695	65973	33.5	3152	62450.515	3522.485
33	Feb-24	31	65	2035	0	0	2015	67988	33.4	-5087.5	64465.515	3522.485
34	Mar-24	29	69	2104	0.35	736.4	2001	69989	33.3	-9257.6	66466.515	3522.485
35	Apr-24	39	71	2175	0	0	2769	72758	33.5	12397.5	68499.115	4258.885
36	May-24	35	58	2233	0	0	2030	74788	33.5	3349.5	70529.115	4258.885
37	Jun-24	32	63	2296	0.335	769.16	2016	76804	33.5	-3444	72545.115	4258.885
38	Jul-24	32	87	2383	0	0	2784	79588	33.4	-3574.5	74559.955	5028.045
39	Aug-24	31	65	2448	0	0	2015	81603	33.3	-5875.2	76574.955	5028.045
40	Sep-24	39	52	2500	0.35	875	2028	83631	33.5	14250	78602.955	5028.045
41	Oct-24	33	88	2588	0	0	2904	86535	33.4	-1294	80631.955	5903.045
42	Nov-24	36	56	2644	0	0	2016	88551	33.5	6874.4	82647.955	5903.045
43	Dec-24	35	58	2702	0.35	945.7	2030	90581	33.5	4053	84677.955	5903.045
44	Jan-25	29	102	2804	0	0	2958	93539	33.4	-12618	86690.255	6848.745
45	Feb-25	34	59	2863	0	0	2006	95545	33.4	1717.8	88696.255	6848.745
46	Mar-25	34	59	2922	0.335	978.87	2006	97551	33.4	1753.2	90702.255	6848.745
47	Apr-25	36	83	3005	0	0	2988	100539	33.5	7813	92711.385	7827.615
48	May-25	35	58	3063	0	0	2030	102569	33.5	4594.5	94741.385	7827.615
49	Jun-25	30	67	3130	0.35	1095.5	2010	104579	33.4	-10955	96751.385	7827.615
50	Jul-25	31	100	3230	0	0	3100	107679	33.3	-7752	98755.885	8923.115
51	Aug-25	38	53	3283	0	0	2014	109693	33.4	15430.1	100769.885	8923.115
52	Sep-25	35	58	3341	0.35	1169.35	2030	111723	33.4	5345.6	102799.885	8923.115
53	Oct-25	32	100	3441	0	0	3200	114923	33.4	-4817.4	104830.535	10092.465
54	Nov-25	30	67	3508	0	0	2010	116933	33.3	-11927.2	106840.535	10092.465
55	Dec-25	29	69	3577	0.335	1198.295	2001	118934	33.2	-15381.1	108841.535	10092.465
56	Jan-26	39	83	3660	0	0	3237	122171	33.4	21228	110880.24	11290.76
57	Feb-26	33	61	3721	0	0	2013	124184	33.4	-1488.4	112893.24	11290.76
58	Mar-26	33	61	3782	0.35	1323.7	2013	126197	33.4	-1512.8	114906.24	11290.76
59	Apr-26	38	88	3870	0	0	3344	129541	33.5	17802	116926.54	12614.46
60	May-26	32	63	3933	0	0	2016	131557	33.4	-5899.5	118942.54	12614.46
61	Jun-26	31	65	3998	0.35	1399.3	2015	133572	33.4	-9595.2	120957.54	12614.46
62	Jul-26	30	114	4112	0	0	3420	136992	33.3	-13980.8	122978.24	14013.76
63	Aug-26	37	55	4167	0	0	2035	139027	33.4	15417.9	125013.24	14013.76
64	Sep-26	39	52	4219	0.335	1413.365	2028	141055	33.4	23626.4	127041.24	14013.76
65	Oct-26	29	118	4337	0	0	3422	144477	33.3	-19082.8	129049.875	15427.125
66	Nov-26	29	69	4406	0	0	2001	146478	33.2	-18945.8	131050.875	15427.125
67	Dec-26	30	67	4473	0.35	1565.55	2010	148488	33.2	-14313.6	133060.875	15427.125
68	Jan-27	33	109	4582	0	0	3597	152085	33.2	-916.4	135092.325	16992.675
69	Feb-27	32	63	4645	0	0	2016	154101	33.2	-5574	137108.325	16992.675
70	Mar-27	35	58	4703	0.35	1646.05	2030	156131	33.2	8465.4	139138.325	16992.675
71	Apr-27	37	99	4802	0	0	3663	159794	33.3	18247.6	141155.275	18638.725
72	May-27	32	63	4865	0	0	2016	161810	33.3	-6324.5	143171.275	18638.725
73	Jun-27	31	65	4930	0.335	1651.55	2015	163825	33.2	-11339	145186.275	18638.725
74	Jul-27	30	122	5052	0	0	3660	167485	33.2	-16166.4	147194.725	20290.275
75	Aug-27	38	53	5105	0	0	2014	169499	33.2	24504	149208.725	20290.275
76	Sep-27	30	67	5172	0.35	1810.2	2010	171509	33.2	-16550.4	151218.725	20290.275
77	Oct-27	32	120	5292	0	0	3840	175349	33.1	-6350.4	153248.525	22100.475
78	Nov-27	31	65	5357	0	0	2015	177364	33.1	-11249.7	155263.525	22100.475
79	Dec-27	29	69	5426	0.35	1899.1	2001	179365	33.1	-22246.6	157264.525	22100.475
80	Jan-28	34	115	5541	0	0	3910	183275	33.1	4986.9	159275.425	23999.575
81	Feb-28	29	69	5610	0	0	2001	185276	33	-23001	161276.425	23999.575
82	Mar-28	35	58	5668	0.335	1898.78	2030	187306	33	11336	163306.425	23999.575
83	Apr-28	33	119	5787	0	0	3927	191233	33	0	165334.645	25898.355
84	May-28	37	55	5842	0	0	2035	193268	33.1	23368	167369.645	25898.355
85	Jun-28	39	52	5894	0.35	2062.9	2028	195296	33.1	34774.6	169397.645	25898.355
86	Jul-28	38	107	6001	0	0	4066	199362	33.2	29404.9	171400.745	27961.255
87	Aug-28	32	63	6064	0	0	2016	201378	33.2	-7276.8	173416.745	27961.255
88	Sep-28	32	63	6127	0.35	2144.45	2016	203394	33.2	-7352.4	175432.745	27961.255
89	Oct-28	30	139	6266	0	0	4170	207564	33.1	-20051.2	177458.295	30105.705
90	Nov-28	31	65	6331	0	0	2015	209579	33.1	-13295.1	179473.295	30105.705
91	Dec-28	37	55	6386	0.335	2139.31	2035	211614	33.1	24905.4	181508.295	30105.705
92	Jan-29	36	115	6501	0	0	4140	215754	33.2	18852.9	183508.985	32245.015
93	Feb-29	31	65	6566	0	0	2015	217769	33.2	-14445.2	185523.985	32245.015
94	Mar-29	37	55	6621	0.35	2317.35	2035	219804	33.2	25159.8	187558.985	32245.015
95	Apr-29	38	114	6735	0	0	4332	224136	33.3	32328	189573.635	34562.365
96	May-29	38	53	6788	0	0	2014	226150	33.3	31903.6	191587.635	34562.365
97	Jun-29	30	67	6855	0.35	2399.25	2010	228160	33.3	-22621.5	193597.635	34562.365
98	Jul-29	33	134	6989	0	0	4422	232582	33.3	-2096.7	195620.385	36961.615
99	Aug-29	38	53	7042	0	0	2014	234596	33.3	33097.4	197634.385	36961.615
100	Sep-29	36	56	7098	0.335	2377.83	2016	236612	33.3	19164.6	199650.385	36961.615