Support Board
Date/Time: Sun, 22 Dec 2024 23:02:15 +0000
Post From: Orientation ??
| [2015-08-27 13:38:25] |
| Sawtooth - Posts: 4141 |
|
This formula in row 3 of a Formula Column will recreate an SMA of the Last price: =AVERAGE(OFFSET(ID0.SG4@3,0,0,$K$1,1)) or =AVERAGE(OFFSET(E3,0,0,$K$1,1)) where K1 is the length. If you want to do 4 SMAs of an SMA, you'll need 4 Formula Columns, the first referencing column E, and the others each referencing the column to the left. This formula in row 3 will give the difference between current price and previous Last price: =ID0.SG4@3-ID0.SG4@4 or =E3-E4 |