I have a list of SEC Form 4 filing insider purchases in this attached excel list. I.e. different CEOs, CFOs, Directors buying shares of their own companies, the price they bought at, the date they bought at etc.
What I did in Excel was to calculate how many different transactions/ purchases were there of the same stock in the last 20-days (number of days configurable), as shown in the yellow column below.
However, i cannot find a clean way in Alteryx to do this. Can anyone advise how to create this in Alteryx?
