Support Board
Date/Time: Sat, 10 May 2025 01:22:21 +0000
Post From: Orientation ??
| [2015-08-27 13:38:25] |
| Sawtooth - Posts: 4214 |
|
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 |