That's where the formula that i seen comes in to it, this takes account of these types of prices.

Hi all, Sounds like you need a weighted average formula where highs & lows will be less significant on the final result. The further away from the initial average, the less significant these values would be.