I have datafeed which gives real time prices of stocks and futures in excel. Is it possible to create a constant range OHLC table out of it? By that, i mean the High and Low prices are constant and a new row of (Open High Low Close) is created only when the price move above previous High or below previous Low.

Thanks for any input!