Login Page - Create Account

Support Board


Date/Time: Sun, 02 Feb 2025 09:45:47 +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.