Support Board

Date/Time: Fri, 19 Apr 2024 11:13:44 +0000

Post From: Sierrachart add moving average and supertrend studies

[2022-02-14 00:07:28] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3973
Despite its name, the Spreadsheet Formula study is not a spreadsheet study. The video you linked to shows a line that looks just like the SuperTrend Stop study that is native in Sierra Chart. Have you added this study to see the similarity? (To make it look the same, set the DrawStyle to Line, set the Width/Size to 1, set the colors to Green and Red.) Using the formulas you provided creates a band on both sides of the price bars that price doesn't cross. It does not create a line as in the video you linked to. Try this, using your formulas: - Add the Spreadsheet Formula study, set the Chart Region to 1, and use a formula like this in its Formula field: =(H+L)/2+ID1.SG12 where ID1 is the ATR study; edit as needed to the ID# of your ATR study. - Duplicate the above study, and edit the formula to this: =(H+L)/2-ID1.SG12 where the number after the * is the Multiplier. Date Time Of Last Edit: 2022-02-14 00:18:46