Is there an easier way to do this?

["epintoem" <epintoem@xxxx>]

I am looking to do the following

Compare todays close to the close say 25 days earlier, if less than
then assign a value of -1, equal to then 0, and if greater than +1.
I want to repeat that for days 26,27,28,29 and 30

then I wish to go to the previous 5 days and repeat the above and sum
up all their values..

any help will be appreciated.