Replacing TotalSum() with Sum() in scan

Discussion in ThinkOrSwim

Updated September 13, 2018

1,624 views
0 thanks given
1 followers

Search this Thread

Replacing TotalSum() with Sum() in scan

September 13th, 2018, 07:17 PM

#1 (permalink)

scotch

San Diego CA

Posts: 7 since Sep 2018

Thanks Given: 2

Thanks Received: 0

Hello,

I have an indicator that uses TotalSum() in its calculation, eg:

Code

plot MyIndicator = TotalSum(Average(myVar, 1));

So on each bar it is plotting the total sum of the 1 bar average of myVar up to that point. This works as intended and I want to create a scan, however ToS does not allow aggregation functions like TotalSum() to be used in scans. So I am working on replacing TotalSum() with Sum() in a plot to confirm that it matches the indicator plot before creating a scan with it.

The issue with using Sum() is that it expects a constant for its length parameter. When I try to use code like:

Code

plot SecondIndicator = Sum(Average(myVar, 1), BarNumber());

I get the Thinkscript error "'BarNumber' can not be used here because of CL constant function parameter 'length'". How can we convert a variable number like BarNumber() into a constant for use in functions that expect them like Sum()?

Last Updated on September 13, 2018