Hi, I trade in stocks using RTD function in my excel sheet.
Can anyone tell me if there is any way to store the maximum and minmum value of RTD (which are always updating continuously) of a particular time-period without storing them.
To be specific, In my excel sheet, from 10:00 am to 10:05 am I get RTD values. Now I want to know the highest (lowest or average) value within this time, without storing them continuously in excel sheet.

Actually by continuously storing value in excel sheet, the sheet gets pretty big in size.