Dear Statalisters,

I have information about the number of number of stocks bought by company and date (daily). I need to create a variable that counts all the stocks bought during a time period between 7 and 13 days before the current date (row where the sum is generated).
This is an example:

Code:
date company_id num_bstocks week2
01jan2020 001 0 -
02jan2020 001 1 -
03jan2020 001 0 -
04jan2020 001 0 -
05jan2020 001 0 -
06jan2020 001 2 -
07jan2020 001 0 -
08jan2020 001 0 0
09jan2020 001 0 1
10jan2020 001 1 1
11jan2020 001 1 1
12jan2020 001 2 1
13jan2020 001 0 3
14jan2020 001 1 3
15jan2020 001 2 3
16jan2020 001 1 3
17jan2020 001 1 3
18jan2020 001 2 4
19jan2020 001 0 6
20jan2020 001 0 4
21jan2020 001 0 5
22jan2020 001 1 7
23jan2020 001 2 8
24jan2020 001 1 8
01jan2020 002 0 -
02jan2020 002 0 -
03jan2020 002 0 -
04jan2020 002 0 -
05jan2020 002 1 -
06jan2020 002 1 -
07jan2020 002 0 -
08jan2020 002 0 0
09jan2020 002 3 0
10jan2020 002 4 0
11jan2020 002 0 0
12jan2020 002 0 1
13jan2020 002 1 2
14jan2020 002 2 2
15jan2020 002 2 2
16jan2020 002 2 5
17jan2020 002 1 9
18jan2020 002 1 9
.
.
.
and so on.

Thank you so much!