I would like to know the formula to do the following: List socks that:

1. In the last eight days made a new high that eclipsed the high of the previous rally.

2. Declined In the last 3 days and had lower highs each day

3. Today is trading above the high of the previous day