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