LOWEST Function

RSS

Lowest( <value>, <periods> )¶

Returns the lowest 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:

LOWEST(CLOSE, 5)

Example Data
Date	Open	High	Low	Close	Volume	LOWEST(CLOSE, 5)
06/01/2011	75100	76050	74100	75875	106528	75875
06/02/2011	75750	77000	75450	76650	81891	75875
06/03/2011	76550	76900	75100	75200	80819	75200
06/06/2011	75400	75800	73150	73175	82726	73175
06/07/2011	73200	73775	72925	73675	72927	73175
06/08/2011	73875	76650	73450	76275	113339	73175
06/09/2011	76400	79300	75950	78425	120824	73175
06/10/2011	78500	79975	77725	78575	86989	73175
06/13/2011	78600	79250	77725	78175	78661	73675
06/14/2011	77925	77950	75250	75450	112682	75450
06/15/2011	76025	76225	72550	72575	130420	72575
06/16/2011	72575	72850	69875	70025	125316	70025
06/17/2011	70050	71450	69125	70200	93140	70025
06/20/2011	70450	70775	69550	70150	63702	70025
06/21/2011	70300	71925	70225	70825	71108	70025
06/22/2011	68125	68500	65025	65025	127015	65025
06/23/2011	65000	65300	62000	64675	138220	64675
06/24/2011	65225	65675	62800	62875	78876	62875