Support Board
Date/Time: Tue, 16 Sep 2025 18:58:08 +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 15:16:59] |
| Sawtooth - Posts: 4263 |
|
The formula would need to look like this: =AVERAGE(ID5.SG1[0]:ID5.SG1[-5])>AVERAGE(ID5.SG1[-6]:ID5.SG1[-20])*1.2 However, Simple Alert Formulas do not correctly support ranges so, even though you won't get a syntax error, the results will not be accurate. You would need to use a spreadsheet study with this formula in row 3 of one of the Formula Columns (K-Z): =AVERAGE(ID5.SG1@3:ID5.SG1@8)>AVERAGE(ID5.SG1@9:ID5.SG1@23)*1.2 Note: You can't use the Spreadsheet Formula study either because it also uses Simple Alert Formulas, despite its name. |