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	32	63	63	0	0	2016	2016	32	0	2016	0
3	Aug-21	35	58	121	0	0	2030	4046	33.4	363	4046	0
4	Sep-21	33	61	182	0.35	63.7	2013	6059	33.3	-72.8	6059	0
5	Oct-21	35	59	241	0	0	2065	8124	33.7	409.7	8060.3	63.7
6	Nov-21	37	55	296	0	0	2035	10159	34.3	976.8	10095.3	63.7
7	Dec-21	33	61	357	0.35	124.95	2013	12172	34.1	-464.1	12108.3	63.7
8	Jan-22	38	56	413	0	0	2128	14300	34.6	1610.7	14111.35	188.65
9	Feb-22	33	61	474	0	0	2013	16313	34.4	-758.4	16124.35	188.65
10	Mar-22	30	67	541	0.335	181.235	2010	18323	33.9	-2380.4	18134.35	188.65
11	Apr-22	31	71	612	0	0	2201	20524	33.5	-1774.8	20154.115	369.885
12	May-22	29	69	681	0	0	2001	22525	33.1	-3064.5	22155.115	369.885
13	Jun-22	39	52	733	0.35	256.55	2028	24553	33.5	4324.7	24183.115	369.885
14	Jul-22	37	61	794	0	0	2257	26810	33.8	2779	26183.565	626.435
15	Aug-22	34	59	853	0	0	2006	28816	33.8	170.6	28189.565	626.435
16	Sep-22	36	56	909	0.35	318.15	2016	30832	33.9	1999.8	30205.565	626.435
17	Oct-22	30	78	987	0	0	2340	33172	33.6	-3849.3	32227.415	944.585
18	Nov-22	32	63	1050	0	0	2016	35188	33.5	-1680	34243.415	944.585
19	Dec-22	37	55	1105	0.335	370.175	2035	37223	33.7	3867.5	36278.415	944.585
20	Jan-23	34	70	1175	0	0	2380	39603	33.7	352.5	38288.24	1314.76
21	Feb-23	38	53	1228	0	0	2014	41617	33.9	5280.4	40302.24	1314.76
22	Mar-23	39	52	1280	0.35	448	2028	43645	34.1	6528	42330.24	1314.76
23	Apr-23	38	65	1345	0	0	2470	46115	34.3	5245.5	44352.24	1762.76
24	May-23	30	67	1412	0	0	2010	48125	34.1	-6071.6	46362.24	1762.76
25	Jun-23	36	56	1468	0.35	513.8	2016	50141	34.2	2789.2	48378.24	1762.76
26	Jul-23	32	79	1547	0	0	2528	52669	34	-3403.4	50392.44	2276.56
27	Aug-23	38	53	1600	0	0	2014	54683	34.2	6400	52406.44	2276.56
28	Sep-23	39	52	1652	0.335	553.42	2028	56711	34.3	7929.6	54434.44	2276.56
29	Oct-23	36	71	1723	0	0	2556	59267	34.4	2929.1	56437.02	2829.98
30	Nov-23	35	58	1781	0	0	2030	61297	34.4	1068.6	58467.02	2829.98
31	Dec-23	29	69	1850	0.35	647.5	2001	63298	34.2	-9990	60468.02	2829.98
32	Jan-24	35	76	1926	0	0	2660	65958	34.2	1540.8	62480.52	3477.48
33	Feb-24	38	53	1979	0	0	2014	67972	34.3	7520.2	64494.52	3477.48
34	Mar-24	39	52	2031	0.35	710.85	2028	70000	34.5	9545.7	66522.52	3477.48
35	Apr-24	34	80	2111	0	0	2720	72720	34.4	-1055.5	68531.67	4188.33
36	May-24	36	56	2167	0	0	2016	74736	34.5	3467.2	70547.67	4188.33
37	Jun-24	30	67	2234	0.335	748.39	2010	76746	34.4	-10053	72557.67	4188.33
38	Jul-24	32	86	2320	0	0	2752	79498	34.3	-5568	74561.28	4936.72
39	Aug-24	33	61	2381	0	0	2013	81511	34.2	-3095.3	76574.28	4936.72
40	Sep-24	31	65	2446	0.35	856.1	2015	83526	34.1	-7827.2	78589.28	4936.72
41	Oct-24	34	85	2531	0	0	2890	86416	34.1	-253.1	80623.18	5792.82
42	Nov-24	32	63	2594	0	0	2016	88432	34.1	-5447.4	82639.18	5792.82
43	Dec-24	30	67	2661	0.35	931.35	2010	90442	34	-10910.1	84649.18	5792.82
44	Jan-25	33	89	2750	0	0	2937	93379	34	-2750	86654.83	6724.17
45	Feb-25	29	69	2819	0	0	2001	95380	33.8	-14095	88655.83	6724.17
46	Mar-25	30	67	2886	0.335	966.81	2010	97390	33.7	-10966.8	90665.83	6724.17
47	Apr-25	35	85	2971	0	0	2975	100365	33.8	3862.3	92674.02	7690.98
48	May-25	32	63	3034	0	0	2016	102381	33.7	-5461.2	94690.02	7690.98
49	Jun-25	36	56	3090	0.35	1081.5	2016	104397	33.8	7107	96706.02	7690.98
50	Jul-25	34	91	3181	0	0	3094	107491	33.8	636.2	98718.52	8772.48
51	Aug-25	32	63	3244	0	0	2016	109507	33.8	-5839.2	100734.52	8772.48
52	Sep-25	35	58	3302	0.35	1155.7	2030	111537	33.8	3962.4	102764.52	8772.48
53	Oct-25	37	86	3388	0	0	3182	114719	33.9	10841.6	104790.82	9928.18
54	Nov-25	32	63	3451	0	0	2016	116735	33.8	-6556.9	106806.82	9928.18
55	Dec-25	39	52	3503	0.335	1173.505	2028	118763	33.9	18215.6	108834.82	9928.18
56	Jan-26	34	94	3597	0	0	3196	121959	33.9	359.7	110857.315	11101.685
57	Feb-26	39	52	3649	0	0	2028	123987	34	18609.9	112885.315	11101.685
58	Mar-26	32	63	3712	0.35	1299.2	2016	126003	33.9	-7424	114901.315	11101.685
59	Apr-26	32	104	3816	0	0	3328	129331	33.9	-7250.4	116930.115	12400.885
60	May-26	34	59	3875	0	0	2006	131337	33.9	387.5	118936.115	12400.885
61	Jun-26	31	65	3940	0.35	1379	2015	133352	33.8	-11426	120951.115	12400.885
62	Jul-26	29	117	4057	0	0	3393	136745	33.7	-19473.6	122965.115	13779.885
63	Aug-26	29	69	4126	0	0	2001	138746	33.6	-19392.2	124966.115	13779.885
64	Sep-26	36	56	4182	0.335	1400.97	2016	140762	33.7	10036.8	126982.115	13779.885
65	Oct-26	34	101	4283	0	0	3434	144196	33.7	1284.9	129015.145	15180.855
66	Nov-26	30	67	4350	0	0	2010	146206	33.6	-16095	131025.145	15180.855
67	Dec-26	29	69	4419	0.35	1546.65	2001	148207	33.5	-20327.4	133026.145	15180.855
68	Jan-27	32	111	4530	0	0	3552	151759	33.5	-6795	135031.495	16727.505
69	Feb-27	37	55	4585	0	0	2035	153794	33.5	16047.5	137066.495	16727.505
70	Mar-27	36	56	4641	0.35	1624.35	2016	155810	33.6	11602.5	139082.495	16727.505
71	Apr-27	30	121	4762	0	0	3630	159440	33.5	-17143.2	141088.145	18351.855
72	May-27	35	58	4820	0	0	2030	161470	33.5	7230	143118.145	18351.855
73	Jun-27	39	52	4872	0.335	1632.12	2028	163498	33.6	26796	145146.145	18351.855
74	Jul-27	34	107	4979	0	0	3638	167136	33.6	1991.6	147152.025	19983.975
75	Aug-27	30	67	5046	0	0	2010	169146	33.5	-18165.6	149162.025	19983.975
76	Sep-27	39	52	5098	0.35	1784.3	2028	171174	33.6	28039	151190.025	19983.975
77	Oct-27	31	123	5221	0	0	3813	174987	33.5	-13574.6	153218.725	21768.275
78	Nov-27	36	56	5277	0	0	2016	177003	33.5	13192.5	155234.725	21768.275
79	Dec-27	35	58	5335	0.35	1867.25	2030	179033	33.6	8002.5	157264.725	21768.275
80	Jan-28	36	108	5443	0	0	3888	182921	33.6	13063.2	159285.475	23635.525
81	Feb-28	31	65	5508	0	0	2015	184936	33.6	-14320.8	161300.475	23635.525
82	Mar-28	36	56	5564	0.335	1863.94	2016	186952	33.6	13353.6	163316.475	23635.525
83	Apr-28	38	102	5666	0	0	3876	190828	33.7	24930.4	165328.535	25499.465
84	May-28	32	63	5729	0	0	2016	192844	33.7	-9739.3	167344.535	25499.465
85	Jun-28	36	56	5785	0.35	2024.75	2016	194860	33.7	13305.5	169360.535	25499.465
86	Jul-28	35	115	5900	0	0	4025	198885	33.7	7670	171360.785	27524.215
87	Aug-28	32	63	5963	0	0	2016	200901	33.7	-10137.1	173376.785	27524.215
88	Sep-28	33	61	6024	0.35	2108.4	2013	202914	33.7	-4216.8	175389.785	27524.215
89	Oct-28	33	125	6149	0	0	4125	207039	33.7	-4304.3	177406.385	29632.615
90	Nov-28	31	65	6214	0	0	2015	209054	33.6	-16777.8	179421.385	29632.615
91	Dec-28	30	67	6281	0.335	2104.135	2010	211064	33.6	-22611.6	181431.385	29632.615
92	Jan-29	36	115	6396	0	0	4140	215204	33.6	15350.4	183467.25	31736.75
93	Feb-29	33	61	6457	0	0	2013	217217	33.6	-3874.2	185480.25	31736.75
94	Mar-29	36	56	6513	0.35	2279.55	2016	219233	33.7	15631.2	187496.25	31736.75
95	Apr-29	30	143	6656	0	0	4290	223523	33.6	-24627.2	189506.7	34016.3
96	May-29	36	56	6712	0	0	2016	225539	33.6	16108.8	191522.7	34016.3
97	Jun-29	39	52	6764	0.35	2367.4	2028	227567	33.6	36525.6	193550.7	34016.3
98	Jul-29	33	133	6897	0	0	4389	231956	33.6	-4138.2	195572.3	36383.7
99	Aug-29	29	69	6966	0	0	2001	233957	33.6	-32043.6	197573.3	36383.7
100	Sep-29	36	56	7022	0.335	2352.37	2016	235973	33.6	16852.8	199589.3	36383.7