This is what is confusing me. Some of the items you have picked up as
NewPeak are not peaks at all. Here is an example Row 153 you are
saying is a NewPeak. The price is 1.4518 this is ranked 28th at this
point. The code will never identify this as a peak, it has to be the
highest number in the list to this point to wear the NewPeak title.
Otherwise it is bog standard.


now i see what the problem is. once again thank you for helping me out. if
you look at the following chart.

http://i87.photobucket.com/albums/k1...Picture1-9.png

i'm measuring each wave, i'm measuring the distance between all four peaks
and troughs. the fact that peak 3 is less than peak 3 doesn't matter, it is
still a peak that needs to be measured. and it is a peak because the
distance between peak 3 and trough 3 is greater than 33 pips and the distance
between peak 3 and trough 4 is also 33 pips.

the spread sheet should be accessible now.

remember i'm eventually going to have about 500,000 rows of data so i'm not
simply interested in the highest out of 500,000. i'm looking to measure
about 5000 waves and then collect probability on those waves being a certain
length.