Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sat, 05 Jul 2025 05:22:11 +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: 4232
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
1x Thank you
Simple Alert vs Spreadsheet.PNG / V - Attached On 2018-12-27 02:22:22 UTC - Size: 33.58 KB - 469 views