10th July 2012, 01:21 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 620
|
|
Quote:
|
Originally Posted by Shaun
I think there is a formula for taking in to account the high and lower prices but i can't remember where i seen it.
|
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. |