Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 07:30:10 +0000
Post From: Orientation ??
| [2015-08-27 13:38:25] |
| Sawtooth - Posts: 3982 |
|
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 |