SUM Function
Modified on 2011/07/22 07:31 by Chad Lowe (CTS) — Categorized as: Uncategorized
SUM( <
value
>, <
periods
> )
¶
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
Back to the Scripting Function Reference