Skip to content

Accumulation Function - ACC()

By Optuma Team · Updated 2021-07-02

This Accumulation function ACC() can be used to sum values over a specified period. It can also be used to count the number of times a true/false boolean signal has occurred. For example, to calculate the cumulative volume over the last 10 days nest the VOL() function within the ACC(). Click on the ACC() script text to set the lookback type and amount - in this case 10 bars.

img0

ACC(VOL(), RANGE=Look Back Period, BARS=10)

In the following example, variable H1 calculates new highest highs over the last 52 weeks, which is then nested in the ACC() function to count the number of new highs over the last 6 months:

H1 = HIGH() > HIGHESTHIGH(BACKTYPE=Weeks, BARS=52);
ACC(H1, RANGE=Look Back Period, BACKTYPE=Months, BARS=6)

Here’s the formula added to a Show View and a Watchlist column, showing that WWE has had 55 new highs over the last months.

Capture

From Optuma 2.0 and later, the ACC() function includes the option of setting a specific date to start the accumulation count from.

In the following example the script is looking for each 25EMA crossing above a 50EMA since the 1st of January 2008.

V1 = MA(BARS=25, STYLE=Exponential) ;
V2 = MA(BARS=50, STYLE=Exponential) ;
V3 = V1 CrossesAbove V2 ;
ACC(V3,RANGE=Look Back Period, BACKTYPE=Date, STARTDATE=2008-01-01)

Here is how it would look on a chart:

AccDate1

You can see the accumulation count only begins once it has passed the 1st of January 2008.

Choose which categories of cookies you allow. Strictly-necessary cookies are always on. You can change this any time via the "Cookie Settings" link in the footer.

  • Functional

    Remember preferences like dismissed banners and your dark-mode choice.

  • Analytics

    Help us understand how the site is used so we can improve it.

  • Marketing

    Measure our advertising and help us reach people who may be interested in Optuma.