View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JRod JRod is offline
external usenet poster
 
Posts: 8
Default Need to find highs and lows formula and how-to

I see a couple of similar questions already posted but they don't 100% help.
I have a list of currency data - similar to stock data. It shows highs and
lows during a specified period of time. It looks like this:

High Low
4/30/2007 6:00 1.9960 1.9951
4/30/2007 6:30 1.9954 1.9944
4/30/2007 7:00 1.9954 1.9942
4/30/2007 7:30 1.9954 1.9947
4/30/2007 8:00 1.9948 1.9923
4/30/2007 8:30 1.9966 1.9926
4/30/2007 9:00 1.9958 1.9921
4/30/2007 9:30 1.9940 1.9922
4/30/2007 10:00 1.9936 1.9902
4/30/2007 10:30 1.9912 1.9894
4/30/2007 11:00 1.9919 1.9891
4/30/2007 11:30 1.9936 1.9912
4/30/2007 12:00 1.9946 1.9929
4/30/2007 12:30 1.9948 1.9935
4/30/2007 13:00 1.9948 1.9928
4/30/2007 13:30 1.9935 1.9929
4/30/2007 14:00 1.9941 1.9925
4/30/2007 14:30 1.9968 1.9931
4/30/2007 15:00 1.9958 1.9944
4/30/2007 15:30 1.9968 1.9945
4/30/2007 16:00 1.9964 1.9953
4/30/2007 16:30 1.9998 1.9959
4/30/2007 17:00 2.0026 1.9991
4/30/2007 17:30 2.0029 1.9994

I am trying to find the first high, then the next low point, then the next
high and so on. If the market is moving down then this would be reversed. I
would find the low, then the next high, then the next low. I am not looking
for a daily high/low or just one high/low. I need to find high points and
low points as the market creates them.

To define high and low, typically it is a point higher and lower than the
previous two or next two time periods. This isn't always the case but is a
rule of thumb.

--
JRod