G
Guest
I would like to get the highest value in my list based on 1-minute intervals.
I do not want to get the hightest value for the day because it may not be
the highest high at that point. There are 391 minutes in my stock data.
Thanks!
Time High Low Close High for Day
8:30:59 47.39 47.39 47.39 47.39
8:31:59 47.30 47.02 47.15 47.39
8:32:59 47.29 47.10 47.18 47.39
8:33:59 47.30 47.15 47.19 47.39
8:34:59 47.43 47.17 47.38 47.43 <----------New High
8:35:59 47.41 47.22 47.23 47.43
8:36:59 47.24 47.08 47.10 =MAX(J2:J8)
I do not want to get the hightest value for the day because it may not be
the highest high at that point. There are 391 minutes in my stock data.
Thanks!
Time High Low Close High for Day
8:30:59 47.39 47.39 47.39 47.39
8:31:59 47.30 47.02 47.15 47.39
8:32:59 47.29 47.10 47.18 47.39
8:33:59 47.30 47.15 47.19 47.39
8:34:59 47.43 47.17 47.38 47.43 <----------New High
8:35:59 47.41 47.22 47.23 47.43
8:36:59 47.24 47.08 47.10 =MAX(J2:J8)