Help! Formula(s) to stock among Shares

[btparkhe1920]

Dear all
hi,
I want to create a stock report of share in excel.
because I do share accounting. I have a 1-month transaction bill or weekly. How many times have I bought and sold a share in it, I also need to know how much stock I have because I have to give that report for audit purpose.
He is giving a sample file of how I want the report
A list of how many times a share was bought and sold in a month should be generated
I am giving an example of how I should get data in an EXCEL file

In short, I should get the date and script name of the date on which a script came in that month
therefor,

This is how data should come
script name date
NIFTY08APR202114000.00PE 05-Apr-21
NIFTY08APR202114000.00PE 06-Apr-21
NIFTY08APR202114000.00PE 07-Apr-21
NIFTY08APR202114300.00PE 05-Apr-21
NIFTY08APR202114300.00PE 06-Apr-21
NIFTY08APR202114300.00PE 07-Apr-21
NIFTY08APR202114300.00PE 08-Apr-21
NIFTY08APR202114400.00PE 06-Apr-21
NIFTY08APR202114400.00PE 07-Apr-21