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	37	55	185	0.35	64.75	2035	6061	32.8	1110	6061	0
5	Oct-21	37	56	241	0	0	2072	8133	33.7	1012.2	8068.25	64.75
6	Nov-21	35	58	299	0	0	2030	10163	34	388.7	10098.25	64.75
7	Dec-21	34	59	358	0.35	125.3	2006	12169	34	0	12104.25	64.75
8	Jan-22	31	69	427	0	0	2139	14308	33.5	-1281	14117.95	190.05
9	Feb-22	35	58	485	0	0	2030	16338	33.7	727.5	16147.95	190.05
10	Mar-22	29	69	554	0.335	185.59	2001	18339	33.1	-2603.8	18148.95	190.05
11	Apr-22	35	63	617	0	0	2205	20544	33.3	1172.3	20168.36	375.64
12	May-22	33	61	678	0	0	2013	22557	33.3	-203.4	22181.36	375.64
13	Jun-22	29	69	747	0.35	261.45	2001	24558	32.9	-3212.1	24182.36	375.64
14	Jul-22	39	58	805	0	0	2262	26820	33.3	4910.5	26182.91	637.09
15	Aug-22	35	58	863	0	0	2030	28850	33.4	1467.1	28212.91	637.09
16	Sep-22	35	58	921	0.35	322.35	2030	30880	33.5	1473.6	30242.91	637.09
17	Oct-22	33	71	992	0	0	2343	33223	33.5	-496	32263.56	959.44
18	Nov-22	33	61	1053	0	0	2013	35236	33.5	-526.5	34276.56	959.44
19	Dec-22	38	53	1106	0.335	370.51	2014	37250	33.7	4977	36290.56	959.44
20	Jan-23	31	77	1183	0	0	2387	39637	33.5	-3194.1	38307.05	1329.95
21	Feb-23	33	61	1244	0	0	2013	41650	33.5	-622	40320.05	1329.95
22	Mar-23	33	61	1305	0.35	456.75	2013	43663	33.5	-652.5	42333.05	1329.95
23	Apr-23	31	80	1385	0	0	2480	46143	33.3	-3462.5	44356.3	1786.7
24	May-23	36	56	1441	0	0	2016	48159	33.4	3890.7	46372.3	1786.7
25	Jun-23	33	61	1502	0.35	525.7	2013	50172	33.4	-600.8	48385.3	1786.7
26	Jul-23	31	82	1584	0	0	2542	52714	33.3	-3801.6	50401.6	2312.4
27	Aug-23	33	61	1645	0	0	2013	54727	33.3	-493.5	52414.6	2312.4
28	Sep-23	31	65	1710	0.335	572.85	2015	56742	33.2	-3933	54429.6	2312.4
29	Oct-23	37	70	1780	0	0	2590	59332	33.3	6764	56446.75	2885.25
30	Nov-23	31	65	1845	0	0	2015	61347	33.3	-4243.5	58461.75	2885.25
31	Dec-23	29	69	1914	0.35	669.9	2001	63348	33.1	-8230.2	60462.75	2885.25
32	Jan-24	31	87	2001	0	0	2697	66045	33	-4202.1	62489.85	3555.15
33	Feb-24	34	59	2060	0	0	2006	68051	33	2060	64495.85	3555.15
34	Mar-24	39	52	2112	0.35	739.2	2028	70079	33.2	12672	66523.85	3555.15
35	Apr-24	38	73	2185	0	0	2774	72853	33.3	10488	68558.65	4294.35
36	May-24	31	65	2250	0	0	2015	74868	33.3	-5175	70573.65	4294.35
37	Jun-24	35	58	2308	0.335	773.18	2030	76898	33.3	3923.6	72603.65	4294.35
38	Jul-24	33	85	2393	0	0	2805	79703	33.3	-717.9	74635.47	5067.53
39	Aug-24	33	61	2454	0	0	2013	81716	33.3	-736.2	76648.47	5067.53
40	Sep-24	36	56	2510	0.35	878.5	2016	83732	33.4	6777	78664.47	5067.53
41	Oct-24	32	90	2600	0	0	2880	86612	33.3	-3640	80665.97	5946.03
42	Nov-24	34	59	2659	0	0	2006	88618	33.3	1861.3	82671.97	5946.03
43	Dec-24	39	52	2711	0.35	948.85	2028	90646	33.4	15452.7	84699.97	5946.03
44	Jan-25	36	82	2793	0	0	2952	93598	33.5	7261.8	86703.12	6894.88
45	Feb-25	31	65	2858	0	0	2015	95613	33.5	-7145	88718.12	6894.88
46	Mar-25	37	55	2913	0.335	975.855	2035	97648	33.5	10195.5	90753.12	6894.88
47	Apr-25	29	103	3016	0	0	2987	100635	33.4	-13572	92764.265	7870.735
48	May-25	35	58	3074	0	0	2030	102665	33.4	4918.4	94794.265	7870.735
49	Jun-25	39	52	3126	0.35	1094.1	2028	104693	33.5	17505.6	96822.265	7870.735
50	Jul-25	31	100	3226	0	0	3100	107793	33.4	-8065	98828.165	8964.835
51	Aug-25	39	52	3278	0	0	2028	109821	33.5	18356.8	100856.165	8964.835
52	Sep-25	33	61	3339	0.35	1168.65	2013	111834	33.5	-1669.5	102869.165	8964.835
53	Oct-25	31	103	3442	0	0	3193	115027	33.4	-8605	104893.515	10133.485
54	Nov-25	29	69	3511	0	0	2001	117028	33.3	-15448.4	106894.515	10133.485
55	Dec-25	31	65	3576	0.335	1197.96	2015	119043	33.3	-8224.8	108909.515	10133.485
56	Jan-26	39	82	3658	0	0	3198	122241	33.4	20850.6	110909.555	11331.445
57	Feb-26	34	59	3717	0	0	2006	124247	33.4	2230.2	112915.555	11331.445
58	Mar-26	33	61	3778	0.35	1322.3	2013	126260	33.4	-1511.2	114928.555	11331.445
59	Apr-26	34	98	3876	0	0	3332	129592	33.4	2325.6	116938.255	12653.745
60	May-26	30	67	3943	0	0	2010	131602	33.4	-13406.2	118948.255	12653.745
61	Jun-26	38	53	3996	0.35	1398.6	2014	133616	33.4	18381.6	120962.255	12653.745
62	Jul-26	30	114	4110	0	0	3420	137036	33.3	-13974	122983.655	14052.345
63	Aug-26	37	55	4165	0	0	2035	139071	33.4	15410.5	125018.655	14052.345
64	Sep-26	35	58	4223	0.335	1414.705	2030	141101	33.4	6756.8	127048.655	14052.345
65	Oct-26	31	111	4334	0	0	3441	144542	33.4	-10401.6	129074.95	15467.05
66	Nov-26	38	53	4387	0	0	2014	146556	33.4	20180.2	131088.95	15467.05
67	Dec-26	32	63	4450	0.35	1557.5	2016	148572	33.4	-6230	133104.95	15467.05
68	Jan-27	37	97	4547	0	0	3589	152161	33.5	16369.2	135136.45	17024.55
69	Feb-27	32	63	4610	0	0	2016	154177	33.4	-6915	137152.45	17024.55
70	Mar-27	35	58	4668	0.35	1633.8	2030	156207	33.5	7468.8	139182.45	17024.55
71	Apr-27	32	114	4782	0	0	3648	159855	33.4	-7173	141196.65	18658.35
72	May-27	36	56	4838	0	0	2016	161871	33.5	12578.8	143212.65	18658.35
73	Jun-27	33	61	4899	0.335	1641.165	2013	163884	33.5	-2449.5	145225.65	18658.35
74	Jul-27	38	96	4995	0	0	3648	167532	33.5	22477.5	147232.485	20299.515
75	Aug-27	38	53	5048	0	0	2014	169546	33.6	22716	149246.485	20299.515
76	Sep-27	37	55	5103	0.35	1786.05	2035	171581	33.6	17350.2	151281.485	20299.515
77	Oct-27	39	98	5201	0	0	3822	175403	33.7	28085.4	153317.435	22085.565
78	Nov-27	31	65	5266	0	0	2015	177418	33.7	-14218.2	155332.435	22085.565
79	Dec-27	31	65	5331	0.35	1865.85	2015	179433	33.7	-14393.7	157347.435	22085.565
80	Jan-28	35	111	5442	0	0	3885	183318	33.7	7074.6	159366.585	23951.415
81	Feb-28	31	65	5507	0	0	2015	185333	33.7	-14868.9	161381.585	23951.415
82	Mar-28	29	69	5576	0.335	1867.96	2001	187334	33.6	-26207.2	163382.585	23951.415
83	Apr-28	39	100	5676	0	0	3900	191234	33.7	30650.4	165414.625	25819.375
84	May-28	32	63	5739	0	0	2016	193250	33.7	-9756.3	167430.625	25819.375
85	Jun-28	36	56	5795	0.35	2028.25	2016	195266	33.7	13328.5	169446.625	25819.375
86	Jul-28	37	109	5904	0	0	4033	199299	33.8	19483.2	171451.375	27847.625
87	Aug-28	38	53	5957	0	0	2014	201313	33.8	25019.4	173465.375	27847.625
88	Sep-28	32	63	6020	0.35	2107	2016	203329	33.8	-10836	175481.375	27847.625
89	Oct-28	34	121	6141	0	0	4114	207443	33.8	1228.2	177488.375	29954.625
90	Nov-28	32	63	6204	0	0	2016	209459	33.8	-11167.2	179504.375	29954.625
91	Dec-28	38	53	6257	0.335	2096.095	2014	211473	33.8	26279.4	181518.375	29954.625
92	Jan-29	35	118	6375	0	0	4130	215603	33.8	7650	183552.28	32050.72
93	Feb-29	35	58	6433	0	0	2030	217633	33.8	7719.6	185582.28	32050.72
94	Mar-29	37	55	6488	0.35	2270.8	2035	219668	33.9	20761.6	187617.28	32050.72
95	Apr-29	36	119	6607	0	0	4284	223952	33.9	13874.7	189630.48	34321.52
96	May-29	36	56	6663	0	0	2016	225968	33.9	13992.3	191646.48	34321.52
97	Jun-29	38	53	6716	0.35	2350.6	2014	227982	33.9	27535.6	193660.48	34321.52
98	Jul-29	36	121	6837	0	0	4356	232338	34	14357.7	195665.88	36672.12
99	Aug-29	36	56	6893	0	0	2016	234354	34	13786	197681.88	36672.12
100	Sep-29	38	53	6946	0.335	2326.91	2014	236368	34	27784	199695.88	36672.12