Calculating consecutive losses using above() function in a Chart

wardzynski — Fri, 15 Sep 2017 02:38:47 GMT

I am trying to use the above function, but I do not get any values using this

above(sum(Profit),1,3) for the Column: Consecutive. I dont understand why?

It only works when I use above(sum(Profit),0,3)

I do not understand why the above() function behaves like this?

What I would like to achieve is calculating how many consecutive losses I get, so this is what I would like to see:

Re: Calculating consecutive losses using above() function in a Chart

antoniotiman — Fri, 15 Sep 2017 05:00:49 GMT

Hi Daniel,

You can use an Expression like this

If(Sum(Profit) > 0,0,Above(Column(1))+1)

Regards,

Antonio