Support Board

Date/Time: Mon, 29 Apr 2024 03:08:04 +0000

Post From: Orientation ??

[2015-08-27 15:13:50] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3982
For an SMA of P3[-1], in Q3: =AVERAGE(OFFSET(P4,0,0,4,1)) If you want an SMA of E3+ the previous P4, you'll need to use another Formula Column (Q3) to combine the values: =E3+P4 then in R3: =AVERAGE(OFFSET(Q3,0,0,4,1)) The spreadsheet array is in descending order; previous bars are in rows below row 3. Date Time Of Last Edit: 2015-08-28 00:48:51