I have a spreadsheet using the RTD function to update stock prices and option prices and I want the high/low for the day to be a field that queues off this RTD function. How can I do this. Example stock price is 10.00 then goes to 15.00 then goes to 20, then to 7.50. High for the day would be 20, low for the day 7.50 and these would be too separate fields queing of the RTD function thatis continuously updating price from a broker? Thanks