Support Board

Date/Time: Sun, 02 Feb 2025 10:09:24 +0000

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

[2018-12-27 02:23:22] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4164
Hi John, The attached pic shows some differences between a Simple Alert Formula and a Spreadsheet formula, referencing the same study in the same bars, using these respective formulas from post #2: =AVERAGE(ID5.SG1[0]:ID5.SG1[-5])>AVERAGE(ID5.SG1[-6]:ID5.SG1[-20])1.2 =AVERAGE(ID5.SG1@3:ID5.SG1@8)>AVERAGE(ID5.SG1@9:ID5.SG1@23)1.2 The magenta dots are from the Simple Alert formula and the cyan dots are from the spreadsheet formula. As you know, the spreadsheet's row 3 is the current bar, and rows below are previous bars, so the row# is always 3 greater than the absolute value of the [#]: [0] = @3 [-1] = @4 [-2] = @5 [-3] = @6 [-4] = @7 [-5] = @8 [-6] = @9 ...etc BTW, the formula in post #1 returns a syntax error. -Tom


Simple Alert vs Spreadsheet.PNG / V - Attached On 2018-12-27 02:22:22 UTC - Size: 33.58 KB - 452 views