Calculate average without using built-in function

[serendipity2020]

Hello

I'm learning thinkscript and want to calculate the sum of all the returns on the selected timeframe using below calculation.

def return = (close / close[1] - 1) * 100;

Now, when I select yearly timeframe, I want to calculate the sum of all the returns shown on the chart.
How do I do that without using sum function? Once sum is calculated, I'll get the total bars using barNumber and find the avg of the same.

I tried below but it doesn't give correct result.

def totalReturn = if (isNaN(return)) then 0 else return + return[1];

 

[halcyonguy]

Hello

I'm learning thinkscript and want to calculate the sum of all the returns on the selected timeframe using below calculation.

def return = (close / close[1] - 1) * 100;

Now, when I select yearly timeframe, I want to calculate the sum of all the returns shown on the chart.
How do I do that without using sum function? Once sum is calculated, I'll get the total bars using barNumber and find the avg of the same.

I tried below but it doesn't give correct result.

def totalReturn = if (isNaN(return)) then 0 else return + return[1];

def totalReturn = if barnumber() == 1 then return else totalReturn[1] + return;

 

[serendipity2020]

def totalReturn = if barnumber() == 1 then return else totalReturn[1] + return;

Thanks @halcyonguy
One more question. If I want to calculate say total return for last 4 bars only, in that case, how will this totalReturn look like?

So, basically, I'm planning to keep a input variable avgSince with default value of say 4, then I'd like this total return variable calculate the total return for last 4 bars only conditionally and if avgSince is say -1, then it would perform full calculation which you've provided already. Is that possible?

 

[halcyonguy]

Thanks @halcyonguy
One more question. If I want to calculate say total return for last 4 bars only, in that case, how will this totalReturn look like?

So, basically, I'm planning to keep a input variable avgSince with default value of say 4, then I'd like this total return variable calculate the total return for last 4 bars only conditionally and if avgSince is say -1, then it would perform full calculation which you've provided already. Is that possible?

if length is -1 then calcs with all the bars on chart.
on setting page , study inputs ,there is a hint for the length. click on white question mark
didn't know what you wanted, so this draws a bubble on all the bars with 4 values.

#total_avg

#https://usethinkscript.com/threads/calculate-average-without-using-built-in-function.18026/#post-138431

def bn = BarNumber();
def na = Double.NaN;

input sum_length = 4;
#hint len: Enter a quantity of bars to sum. \n -1 = all the bars on the chart.

def return = (close / close[1] - 1) * 100;

def totalReturn;
def avg;
def len;
if sum_length == -1 then {
  totalReturn = if BarNumber() == 1 then return else totalReturn[1] + return;
  avg = totalReturn / bn;
  len = bn;
} else {
  totalreturn = sum(return, sum_length);
  avg =  totalReturn / sum_length;
  len = sum_length;
}


input test1 = yes;
addchartbubble(test1, low,
return + " return\n" +
len + " Len\n" +
totalreturn + " tot\n" +
avg + " Avg"
, color.yellow, no);

addlabel(1, "Length = " + sum_length, color.yellow);
#

 

[serendipity2020]

if length is -1 then calcs with all the bars on chart.
on setting page , study inputs ,there is a hint for the length. click on white question mark
didn't know what you wanted, so this draws a bubble on all the bars with 4 values.

#total_avg

#https://usethinkscript.com/threads/calculate-average-without-using-built-in-function.18026/#post-138431

def bn = BarNumber();
def na = Double.NaN;

input sum_length = 4;
#hint len: Enter a quantity of bars to sum. \n -1 = all the bars on the chart.

def return = (close / close[1] - 1) * 100;

def totalReturn;
def avg;
def len;
if sum_length == -1 then {
  totalReturn = if BarNumber() == 1 then return else totalReturn[1] + return;
  avg = totalReturn / bn;
  len = bn;
} else {
  totalreturn = sum(return, sum_length);
  avg =  totalReturn / sum_length;
  len = sum_length;
}


input test1 = yes;
addchartbubble(test1, low,
return + " return\n" +
len + " Len\n" +
totalreturn + " tot\n" +
avg + " Avg"
, color.yellow, no);

addlabel(1, "Length = " + sum_length, color.yellow);
#

Thanks @halcyonguy This is exactly what I was looking for.