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 |