Loop through rows identifying a positive/negative pattern and return value

Hello,

I have about 20,000 rows. Each row contains 1 asset and 60 months of a running balance. I need to create a loop that goes through each cell in the row for all the months and determine if there are these pattersn:

Asset is negative, then remains positive, return reschedule
Asset is always negative, return BUY
Assset is negative, then positive the negative, return reschedule
Asset is positve, then always negative, return buy
Asset is postive then negative then positve, then reschedule
Asset is always positive, return good

I'd just return the value in a cell beside the asset ID where the cases are being analyzed.

Still trying to see if I can find something similar on the forum/google!

Here is an example. I just realized as I was making that, that it the cases could continue like UP down UP down UP down.

We need something to build on, this is a good start!

http://stackoverflow.com/questions/1...ven-standpoint

this seems similar