Hi All,

I want excel function or formula.
I am getting script price in live market in excel sheet through broker software. I want a formula that count highest and lowest number ever since start. e.g. the script price or number say 900. In every second this number goes up and down say 901, 902 or in next couple of seconds it may fall say 898, 897 etc. I want formula that print or show me highest number ever in one cell or lowest number ever in another cell. This numbers will not change until next, it may rise or fall than previous number, e.g. if highest number ever shown was 905 and the current stock price say 901, the 905 will not change till 901 will go up 905. Once gone above 905 and higher number shown like 905.50, it should change from 905 to 905.50.

Regards