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	38	53	116	0	0	2014	4030	34.7	696	4030	0
4	Sep-21	37	55	171	0.35	59.85	2035	6065	35.5	393.3	6065	0
5	Oct-21	34	61	232	0	0	2074	8139	35.1	-348	8079.15	59.85
6	Nov-21	34	59	291	0	0	2006	10145	34.9	-320.1	10085.15	59.85
7	Dec-21	34	59	350	0.35	122.5	2006	12151	34.7	-315	12091.15	59.85
8	Jan-22	36	59	409	0	0	2124	14275	34.9	531.7	14092.65	182.35
9	Feb-22	33	61	470	0	0	2013	16288	34.7	-893	16105.65	182.35
10	Mar-22	35	58	528	0.335	176.88	2030	18318	34.7	158.4	18135.65	182.35
11	Apr-22	29	76	604	0	0	2204	20522	34	-3442.8	20162.77	359.23
12	May-22	36	56	660	0	0	2016	22538	34.1	1320	22178.77	359.23
13	Jun-22	29	69	729	0.35	255.15	2001	24539	33.7	-3717.9	24179.77	359.23
14	Jul-22	39	58	787	0	0	2262	26801	34.1	4171.1	26186.62	614.38
15	Aug-22	37	55	842	0	0	2035	28836	34.2	2441.8	28221.62	614.38
16	Sep-22	32	63	905	0.35	316.75	2016	30852	34.1	-1991	30237.62	614.38
17	Oct-22	29	80	985	0	0	2320	33172	33.7	-5023.5	32240.87	931.13
18	Nov-22	37	55	1040	0	0	2035	35207	33.9	3432	34275.87	931.13
19	Dec-22	35	58	1098	0.335	367.83	2030	37237	33.9	1207.8	36305.87	931.13
20	Jan-23	32	74	1172	0	0	2368	39605	33.8	-2226.8	38306.04	1298.96
21	Feb-23	38	53	1225	0	0	2014	41619	34	5145	40320.04	1298.96
22	Mar-23	30	67	1292	0.35	452.2	2010	43629	33.8	-5168	42330.04	1298.96
23	Apr-23	33	75	1367	0	0	2475	46104	33.7	-1093.6	44352.84	1751.16
24	May-23	38	53	1420	0	0	2014	48118	33.9	6106	46366.84	1751.16
25	Jun-23	38	53	1473	0.35	515.55	2014	50132	34	6039.3	48380.84	1751.16
26	Jul-23	33	77	1550	0	0	2541	52673	34	-1550	50406.29	2266.71
27	Aug-23	36	56	1606	0	0	2016	54689	34.1	3212	52422.29	2266.71
28	Sep-23	38	53	1659	0.335	555.765	2014	56703	34.2	6470.1	54436.29	2266.71
29	Oct-23	32	80	1739	0	0	2560	59263	34.1	-3825.8	56440.525	2822.475
30	Nov-23	34	59	1798	0	0	2006	61269	34.1	-179.8	58446.525	2822.475
31	Dec-23	36	56	1854	0.35	648.9	2016	63285	34.1	3522.6	60462.525	2822.475
32	Jan-24	30	89	1943	0	0	2670	65955	33.9	-7966.3	62483.625	3471.375
33	Feb-24	38	53	1996	0	0	2014	67969	34.1	8183.6	64497.625	3471.375
34	Mar-24	32	63	2059	0.35	720.65	2016	69985	34	-4323.9	66513.625	3471.375
35	Apr-24	30	91	2150	0	0	2730	72715	33.8	-8600	68522.975	4192.025
36	May-24	33	61	2211	0	0	2013	74728	33.8	-1768.8	70535.975	4192.025
37	Jun-24	35	58	2269	0.335	760.115	2030	76758	33.8	2722.8	72565.975	4192.025
38	Jul-24	31	90	2359	0	0	2790	79548	33.7	-6605.2	74595.86	4952.14
39	Aug-24	37	55	2414	0	0	2035	81583	33.8	7966.2	76630.86	4952.14
40	Sep-24	29	69	2483	0.35	869.05	2001	83584	33.7	-11918.4	78631.86	4952.14
41	Oct-24	36	80	2563	0	0	2880	86464	33.7	5894.9	80642.81	5821.19
42	Nov-24	39	52	2615	0	0	2028	88492	33.8	13859.5	82670.81	5821.19
43	Dec-24	31	65	2680	0.35	938	2015	90507	33.8	-7504	84685.81	5821.19
44	Jan-25	39	76	2756	0	0	2964	93471	33.9	14331.2	86711.81	6759.19
45	Feb-25	38	53	2809	0	0	2014	95485	34	11516.9	88725.81	6759.19
46	Mar-25	37	55	2864	0.335	959.44	2035	97520	34.1	8592	90760.81	6759.19
47	Apr-25	34	88	2952	0	0	2992	100512	34	-295.2	92793.37	7718.63
48	May-25	32	63	3015	0	0	2016	102528	34	-6030	94809.37	7718.63
49	Jun-25	29	69	3084	0.35	1079.4	2001	104529	33.9	-15420	96810.37	7718.63
50	Jul-25	39	79	3163	0	0	3081	107610	34	16131.3	98811.97	8798.03
51	Aug-25	30	67	3230	0	0	2010	109620	33.9	-12920	100821.97	8798.03
52	Sep-25	31	65	3295	0.35	1153.25	2015	111635	33.9	-9555.5	102836.97	8798.03
53	Oct-25	29	109	3404	0	0	3161	114796	33.7	-16679.6	104844.72	9951.28
54	Nov-25	32	63	3467	0	0	2016	116812	33.7	-5893.9	106860.72	9951.28
55	Dec-25	34	59	3526	0.335	1181.21	2006	118818	33.7	1057.8	108866.72	9951.28
56	Jan-26	34	94	3620	0	0	3196	122014	33.7	1086	110881.51	11132.49
57	Feb-26	36	56	3676	0	0	2016	124030	33.7	8454.8	112897.51	11132.49
58	Mar-26	38	53	3729	0.35	1305.15	2014	126044	33.8	16034.7	114911.51	11132.49
59	Apr-26	31	107	3836	0	0	3317	129361	33.7	-10740.8	116923.36	12437.64
60	May-26	29	69	3905	0	0	2001	131362	33.6	-18353.5	118924.36	12437.64
61	Jun-26	35	58	3963	0.35	1387.05	2030	133392	33.7	5548.2	120954.36	12437.64
62	Jul-26	32	106	4069	0	0	3392	136784	33.6	-6917.3	122959.31	13824.69
63	Aug-26	35	58	4127	0	0	2030	138814	33.6	5777.8	124989.31	13824.69
64	Sep-26	30	67	4194	0.335	1404.99	2010	140824	33.6	-15098.4	126999.31	13824.69
65	Oct-26	35	98	4292	0	0	3430	144254	33.6	6008.8	129024.32	15229.68
66	Nov-26	38	53	4345	0	0	2014	146268	33.7	19118	131038.32	15229.68
67	Dec-26	32	63	4408	0.35	1542.8	2016	148284	33.6	-7493.6	133054.32	15229.68
68	Jan-27	33	108	4516	0	0	3564	151848	33.6	-2709.6	135075.52	16772.48
69	Feb-27	31	65	4581	0	0	2015	153863	33.6	-11910.6	137090.52	16772.48
70	Mar-27	29	69	4650	0.35	1627.5	2001	155864	33.5	-21390	139091.52	16772.48
71	Apr-27	32	114	4764	0	0	3648	159512	33.5	-7146	141112.02	18399.98
72	May-27	34	59	4823	0	0	2006	161518	33.5	2411.5	143118.02	18399.98
73	Jun-27	37	55	4878	0.335	1634.13	2035	163553	33.5	17073	145153.02	18399.98
74	Jul-27	34	107	4985	0	0	3638	167191	33.5	2492.5	147156.89	20034.11
75	Aug-27	32	63	5048	0	0	2016	169207	33.5	-7572	149172.89	20034.11
76	Sep-27	37	55	5103	0.35	1786.05	2035	171242	33.6	17860.5	151207.89	20034.11
77	Oct-27	33	115	5218	0	0	3795	175037	33.5	-3130.8	153216.84	21820.16
78	Nov-27	33	61	5279	0	0	2013	177050	33.5	-2639.5	155229.84	21820.16
79	Dec-27	31	65	5344	0.35	1870.4	2015	179065	33.5	-13360	157244.84	21820.16
80	Jan-28	30	130	5474	0	0	3900	182965	33.4	-19159	159274.44	23690.56
81	Feb-28	36	56	5530	0	0	2016	184981	33.5	14378	161290.44	23690.56
82	Mar-28	33	61	5591	0.335	1872.985	2013	186994	33.4	-2795.5	163303.44	23690.56
83	Apr-28	33	118	5709	0	0	3894	190888	33.4	-2283.6	165324.455	25563.545
84	May-28	36	56	5765	0	0	2016	192904	33.5	14989	167340.455	25563.545
85	Jun-28	29	69	5834	0.35	2041.9	2001	194905	33.4	-26253	169341.455	25563.545
86	Jul-28	33	123	5957	0	0	4059	198964	33.4	-2382.8	171358.555	27605.445
87	Aug-28	32	63	6020	0	0	2016	200980	33.4	-8428	173374.555	27605.445
88	Sep-28	31	65	6085	0.35	2129.75	2015	202995	33.4	-14604	175389.555	27605.445
89	Oct-28	33	126	6211	0	0	4158	207153	33.4	-2484.4	177417.805	29735.195
90	Nov-28	38	53	6264	0	0	2014	209167	33.4	28814.4	179431.805	29735.195
91	Dec-28	39	52	6316	0.335	2115.86	2028	211195	33.4	35369.6	181459.805	29735.195
92	Jan-29	36	115	6431	0	0	4140	215335	33.5	16720.6	183483.945	31851.055
93	Feb-29	38	53	6484	0	0	2014	217349	33.5	29178	185497.945	31851.055
94	Mar-29	39	52	6536	0.35	2287.6	2028	219377	33.6	35948	187525.945	31851.055
95	Apr-29	37	116	6652	0	0	4292	223669	33.6	22616.8	189530.345	34138.655
96	May-29	35	58	6710	0	0	2030	225699	33.6	9394	191560.345	34138.655
97	Jun-29	31	65	6775	0.35	2371.25	2015	227714	33.6	-17615	193575.345	34138.655
98	Jul-29	32	137	6912	0	0	4384	232098	33.6	-11059.2	195588.095	36509.905
99	Aug-29	30	67	6979	0	0	2010	234108	33.5	-25124.4	197598.095	36509.905
100	Sep-29	36	56	7035	0.335	2356.725	2016	236124	33.6	17587.5	199614.095	36509.905