Support Board
Date/Time: Wed, 12 Feb 2025 04:36:55 +0000
Post From: study subgraph average
| [2020-09-15 12:27:27] |
| Sawtooth - Posts: 4173 |
|
Actually there is an easier way, using two instances of the Spreadsheet Formula study: Add an instance of the Spreadsheet Formula study, set the 'Draw Zero Values' to No. Use a formula like this in the Formula field: =ID1.SG1[-3] - where ID1 is the MA to be displaced, by e.g. 3 bars to the left. Add another instance of the Spreadsheet Formula study, set the 'Draw Zero Values' to No. Use a formula like this in the Formula field: =AVERAGE(ID2.SG1,ID3.SG1) - where ID2 is the MA that is not displaced, and ID3 is the first Spreadsheet Formula study. Date Time Of Last Edit: 2020-09-15 14:13:06
|