Support Board
Date/Time: Sun, 22 Dec 2024 22:27:46 +0000
Post From: Orientation ??
| [2015-08-27 15:13:50] |
| Sawtooth - Posts: 4141 |
|
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
|