Thread: Function Max
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ferrdav[_6_] ferrdav[_6_] is offline
external usenet poster
 
Posts: 1
Default Function Max

thank's dave, but my problem it's a bit more complex:

time bin it's a function that assess a number to those trades that are
in whithin a certain range of time, let's say 5 minutes.

since the number of trades (for a security) aren't the same for 5
minutes in 5 minutes, i need to isolate prices that were made in first
5 minutes of tdaes (time bin = 1) form those in the second five minutes
of trade (time bin=2) and so on... this' what time bin function does

what i need is to calculate the maximum price between those in time bin
1, and then the maximum in time bin 2 and so on...

i believe i should use a do..while loop, but i cannot do that...:(



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/