Shares Lot Remaining Formula

[dude6571]

Hi,

I am struggling with a formula.

I would like to get the remaining shares per lot based on the purchase date as per sheet attached.

Any help will be appreciated.
Thanks in advance

Index	Coin	Buy/Sell	Date	Shares	Shares per lot remaining	Comments box
1	ABC	Buy	21/02/2021​	10	5
2	ABC	Buy	27/02/2021​	10	10
3	ABC	Buy	30/06/2021​	10	10
4	ABC	Buy	03/09/2021​	10	10
5	ABC	Sell	29/10/2021​	5	0
6	ABC	Buy	04/12/2021​	10	10
7	ABC	Buy	23/07/2023​	10	10
1	DEF	Buy	17/05/2021​	20	0
2	DEF	Sell	29/08/2021​	21	0
3	DEF	Buy	28/08/2021​	10	9

Also asked here Remaining Shares per Lot , Formulam EXcel