Support Board

Date/Time: Thu, 02 May 2024 16:52:57 +0000

Post From: study subgraph average

[2020-09-15 12:27:27] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3990
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