Hi everyone,
I am facing the following problem. For the data attached I want to add a column that sums up the column “gsv_scaled” based on the following conditions:
  1. The ticker should be the same as in the row a new value is calculated for
  2. The date should be within the range of 180 days prior to the date of the row the new value is calculated for.
Is there a way of implementing that in Stata?
I am grateful for any suggestions and approaches to this.

Thanks for your help!
Marian