Insider Transactions logic

Hi all,

I’m trying to look at insider transactions (InsBuyTrans) that is ‘‘the NUMBER of officers and directors that purchased their company’s common stock in the last six months’’.

My issue is that I would like to evaluate the amount of transaction in the last week and since the indicator is calculated on a rolling period I can not exclude that a weekly increase is happening because some transactions from one month ago are dropped. Maybee there is a simple workaround for this but I just don’t see it.

Thanks

Maybe : InsBuyTrans - FHist(“InsBuyTrans”,1)

As far as my understanding goes this would not solve the problem. For example:

Month: 1|2|3|4|5|6|7
Transactions: 9|1|1|1|1|1|1

If today is month 7
InsBuyTrans = Month 2to7 = 6
FHist(“InsBuyTrans”,1) = Month 1to6 = 14

InsBuyTrans - FHist(“InsBuyTrans”,1) = 6-14 = -8

Or am I missing something?