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

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

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.