Login Page - Create Account

Support Board


Date/Time: Sat, 05 Jul 2025 05:12:30 +0000



Post From: Question on Formula based on average of last 5 bars to be more than 1.2 times of usual

[2018-12-22 08:29:30]
User164231 - Posts: 278
Hi Tom et al,

Say if I would like to detect a surge of ATR by 20 percent within the average of last 5 bars with a look back of 20 bars, is this the correct formula;

=AND(AVERAGE(ID5.SG1[0:-5]*1.2>AVERAGE(ID5.SG1[-6:-20])

Thanks.