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	30	67	67	0	0	2010	2010	30	0	2010	0
3	Aug-21	32	63	130	0	0	2016	4026	31	260	4026	0
4	Sep-21	39	52	182	0.35	63.7	2028	6054	33.3	1456	6054	0
5	Oct-21	39	53	235	0	0	2067	8121	34.6	1339.5	8057.3	63.7
6	Nov-21	35	58	293	0	0	2030	10151	34.6	117.2	10087.3	63.7
7	Dec-21	30	67	360	0.35	126	2010	12161	33.8	-1656	12097.3	63.7
8	Jan-22	38	56	416	0	0	2128	14289	34.3	1747.2	14099.3	189.7
9	Feb-22	30	67	483	0	0	2010	16299	33.7	-2076.9	16109.3	189.7
10	Mar-22	34	59	542	0.335	181.57	2006	18305	33.8	162.6	18115.3	189.7
11	Apr-22	29	76	618	0	0	2204	20509	33.2	-2966.4	20137.73	371.27
12	May-22	35	58	676	0	0	2030	22539	33.3	1216.8	22167.73	371.27
13	Jun-22	39	52	728	0.35	254.8	2028	24567	33.7	4149.6	24195.73	371.27
14	Jul-22	37	61	789	0	0	2257	26824	34	2603.7	26197.93	626.07
15	Aug-22	34	59	848	0	0	2006	28830	34	0	28203.93	626.07
16	Sep-22	33	61	909	0.35	318.15	2013	30843	33.9	-909	30216.93	626.07
17	Oct-22	38	62	971	0	0	2356	33199	34.2	3981.1	32254.78	944.22
18	Nov-22	31	65	1036	0	0	2015	35214	34	-3315.2	34269.78	944.22
19	Dec-22	33	61	1097	0.335	367.495	2013	37227	33.9	-1097	36282.78	944.22
20	Jan-23	36	66	1163	0	0	2376	39603	34.1	2442.3	38291.285	1311.715
21	Feb-23	36	56	1219	0	0	2016	41619	34.1	2316.1	40307.285	1311.715
22	Mar-23	36	56	1275	0.35	446.25	2016	43635	34.2	2422.5	42323.285	1311.715
23	Apr-23	35	70	1345	0	0	2450	46085	34.3	1076	44327.035	1757.965
24	May-23	32	63	1408	0	0	2016	48101	34.2	-3238.4	46343.035	1757.965
25	Jun-23	33	61	1469	0.35	514.15	2013	50114	34.1	-1762.8	48356.035	1757.965
26	Jul-23	38	67	1536	0	0	2546	52660	34.3	5990.4	50387.885	2272.115
27	Aug-23	33	61	1597	0	0	2013	54673	34.2	-2076.1	52400.885	2272.115
28	Sep-23	30	67	1664	0.335	557.44	2010	56683	34.1	-6988.8	54410.885	2272.115
29	Oct-23	38	68	1732	0	0	2584	59267	34.2	6754.8	56437.445	2829.555
30	Nov-23	31	65	1797	0	0	2015	61282	34.1	-5750.4	58452.445	2829.555
31	Dec-23	30	67	1864	0.35	652.4	2010	63292	34	-7642.4	60462.445	2829.555
32	Jan-24	35	76	1940	0	0	2660	65952	34	1940	62470.045	3481.955
33	Feb-24	31	65	2005	0	0	2015	67967	33.9	-6015	64485.045	3481.955
34	Mar-24	34	59	2064	0.35	722.4	2006	69973	33.9	206.4	66491.045	3481.955
35	Apr-24	37	74	2138	0	0	2738	72711	34	6627.8	68506.645	4204.355
36	May-24	38	53	2191	0	0	2014	74725	34.1	8764	70520.645	4204.355
37	Jun-24	39	52	2243	0.335	751.405	2028	76753	34.2	10990.7	72548.645	4204.355
38	Jul-24	30	92	2335	0	0	2760	79513	34.1	-9807	74557.24	4955.76
39	Aug-24	39	52	2387	0	0	2028	81541	34.2	11696.3	76585.24	4955.76
40	Sep-24	32	63	2450	0.35	857.5	2016	83557	34.1	-5390	78601.24	4955.76
41	Oct-24	36	80	2530	0	0	2880	86437	34.2	4807	80623.74	5813.26
42	Nov-24	30	67	2597	0	0	2010	88447	34.1	-10907.4	82633.74	5813.26
43	Dec-24	39	52	2649	0.35	927.15	2028	90475	34.2	12980.1	84661.74	5813.26
44	Jan-25	32	92	2741	0	0	2944	93419	34.1	-6030.2	86678.59	6740.41
45	Feb-25	37	55	2796	0	0	2035	95454	34.1	8108.4	88713.59	6740.41
46	Mar-25	37	55	2851	0.335	955.085	2035	97489	34.2	8267.9	90748.59	6740.41
47	Apr-25	38	78	2929	0	0	2964	100453	34.3	11130.2	92757.505	7695.495
48	May-25	36	56	2985	0	0	2016	102469	34.3	5074.5	94773.505	7695.495
49	Jun-25	36	56	3041	0.35	1064.35	2016	104485	34.4	5169.7	96789.505	7695.495
50	Jul-25	33	93	3134	0	0	3069	107554	34.3	-4387.6	98794.155	8759.845
51	Aug-25	35	58	3192	0	0	2030	109584	34.3	2234.4	100824.155	8759.845
52	Sep-25	34	59	3251	0.35	1137.85	2006	111590	34.3	-975.3	102830.155	8759.845
53	Oct-25	38	83	3334	0	0	3154	114744	34.4	12335.8	104846.305	9897.695
54	Nov-25	32	63	3397	0	0	2016	116760	34.4	-8152.8	106862.305	9897.695
55	Dec-25	29	69	3466	0.335	1161.11	2001	118761	34.3	-18716.4	108863.305	9897.695
56	Jan-26	32	99	3565	0	0	3168	121929	34.2	-8199.5	110870.195	11058.805
57	Feb-26	35	58	3623	0	0	2030	123959	34.2	2898.4	112900.195	11058.805
58	Mar-26	30	67	3690	0.35	1291.5	2010	125969	34.1	-15498	114910.195	11058.805
59	Apr-26	33	100	3790	0	0	3300	129269	34.1	-4169	116918.695	12350.305
60	May-26	33	61	3851	0	0	2013	131282	34.1	-4236.1	118931.695	12350.305
61	Jun-26	31	65	3916	0.35	1370.6	2015	133297	34	-12139.6	120946.695	12350.305
62	Jul-26	29	117	4033	0	0	3393	136690	33.9	-20165	122969.095	13720.905
63	Aug-26	32	63	4096	0	0	2016	138706	33.9	-7782.4	124985.095	13720.905
64	Sep-26	35	58	4154	0.335	1391.59	2030	140736	33.9	4569.4	127015.095	13720.905
65	Oct-26	29	117	4271	0	0	3393	144129	33.7	-20927.9	129016.505	15112.495
66	Nov-26	38	53	4324	0	0	2014	146143	33.8	18593.2	131030.505	15112.495
67	Dec-26	31	65	4389	0.35	1536.15	2015	148158	33.8	-12289.2	133045.505	15112.495
68	Jan-27	31	115	4504	0	0	3565	151723	33.7	-12611.2	135074.355	16648.645
69	Feb-27	38	53	4557	0	0	2014	153737	33.7	19595.1	137088.355	16648.645
70	Mar-27	38	53	4610	0.35	1613.5	2014	155751	33.8	19823	139102.355	16648.645
71	Apr-27	32	113	4723	0	0	3616	159367	33.7	-8501.4	141104.855	18262.145
72	May-27	31	65	4788	0	0	2015	161382	33.7	-12927.6	143119.855	18262.145
73	Jun-27	34	59	4847	0.335	1623.745	2006	163388	33.7	1454.1	145125.855	18262.145
74	Jul-27	31	117	4964	0	0	3627	167015	33.6	-13402.8	147129.11	19885.89
75	Aug-27	31	65	5029	0	0	2015	169030	33.6	-13075.4	149144.11	19885.89
76	Sep-27	39	52	5081	0.35	1778.35	2028	171058	33.7	27437.4	151172.11	19885.89
77	Oct-27	39	97	5178	0	0	3783	174841	33.8	27443.4	153176.76	21664.24
78	Nov-27	30	67	5245	0	0	2010	176851	33.7	-19931	155186.76	21664.24
79	Dec-27	35	58	5303	0.35	1856.05	2030	178881	33.7	6893.9	157216.76	21664.24
80	Jan-28	37	105	5408	0	0	3885	182766	33.8	17846.4	159245.71	23520.29
81	Feb-28	35	58	5466	0	0	2030	184796	33.8	6559.2	161275.71	23520.29
82	Mar-28	36	56	5522	0.335	1849.87	2016	186812	33.8	12148.4	163291.71	23520.29
83	Apr-28	35	110	5632	0	0	3850	190662	33.9	6758.4	165291.84	25370.16
84	May-28	38	53	5685	0	0	2014	192676	33.9	23308.5	167305.84	25370.16
85	Jun-28	35	58	5743	0.35	2010.05	2030	194706	33.9	6317.3	169335.84	25370.16
86	Jul-28	35	115	5858	0	0	4025	198731	33.9	6443.8	171350.79	27380.21
87	Aug-28	31	65	5923	0	0	2015	200746	33.9	-17176.7	173365.79	27380.21
88	Sep-28	35	58	5981	0.35	2093.35	2030	202776	33.9	6579.1	175395.79	27380.21
89	Oct-28	31	133	6114	0	0	4123	206899	33.8	-17730.6	177425.44	29473.56
90	Nov-28	29	69	6183	0	0	2001	208900	33.8	-29678.4	179426.44	29473.56
91	Dec-28	37	55	6238	0.335	2089.73	2035	210935	33.8	19961.6	181461.44	29473.56
92	Jan-29	39	105	6343	0	0	4095	215030	33.9	32983.6	183466.71	31563.29
93	Feb-29	38	53	6396	0	0	2014	217044	33.9	26223.6	185480.71	31563.29
94	Mar-29	31	65	6461	0.35	2261.35	2015	219059	33.9	-18736.9	187495.71	31563.29
95	Apr-29	37	116	6577	0	0	4292	223351	34	20388.7	189526.36	33824.64
96	May-29	30	67	6644	0	0	2010	225361	33.9	-26576	191536.36	33824.64
97	Jun-29	33	61	6705	0.35	2346.75	2013	227374	33.9	-6034.5	193549.36	33824.64
98	Jul-29	31	141	6846	0	0	4371	231745	33.9	-19853.4	195573.61	36171.39
99	Aug-29	34	59	6905	0	0	2006	233751	33.9	690.5	197579.61	36171.39
100	Sep-29	33	61	6966	0.335	2333.61	2013	235764	33.8	-6269.4	199592.61	36171.39