Calculating Max and Min Value of RTD without capturing them.

**Tuhin Paul** · 08-21-2019, 06:38 AM

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.

**dangelor** · 08-21-2019, 01:02 PM

I'm not familiar with RTD, but you may be able to incorporate it into this simple routine...

Please Login or Register  to view this content.

**MrShorty** · 08-21-2019, 02:30 PM

I have suggested some relatively simple MAX() and MIN() functions using circular references with iteration enabled for this sort of thing before: https://www.excelforum.com/excel-gen...amic-cell.html