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/