HIGHEST Function

Returns the highest value occurring over the last number of periods from the current data point.

Function Parameters
Parameter Description
<value>The value field to inspect (e.g. CLOSE, HIGH, (H+L+C)/3, etc.)
<periods>The number of periods to look back.
| Example:
HIGHEST(CLOSE, 5)
Example Data
Date Open High Low Close Volume HIGHEST(CLOSE, 5)
06/01/2011 75100 76050 74100 75875 106528 75875
06/02/2011 75750 77000 75450 76650 81891 76650
06/03/2011 76550 76900 75100 75200 80819 76650
06/06/2011 75400 75800 73150 73175 82726 76650
06/07/2011 73200 73775 72925 73675 72927 76650
06/08/2011 73875 76650 73450 76275 113339 76650
06/09/2011 76400 79300 75950 78425 120824 78425
06/10/2011 78500 79975 77725 78575 86989 78575
06/13/2011 78600 79250 77725 78175 78661 78575
06/14/2011 77925 77950 75250 75450 112682 78575
06/15/2011 76025 76225 72550 72575 130420 78575
06/16/2011 72575 72850 69875 70025 125316 78575
06/17/2011 70050 71450 69125 70200 93140 78175
06/20/2011 70450 70775 69550 70150 63702 75450
06/21/2011 70300 71925 70225 70825 71108 72575
06/22/2011 68125 68500 65025 65025 127015 70825
06/23/2011 65000 65300 62000 64675 138220 70825
06/24/2011 65225 65675 62800 62875 78876 70825