This is how I did it, copied the data in from yahoo, then added the following columns. Sure, its clunky, but it did the job. See the attatchemnt
=IF(E15>E14;1;0)
puts a 1 in the colum if todays close was > then yesterdays close
=IF(G14=1;(H14+1);0)
adds up consecutive 1's...