Login Page - Create Account

# Support Board

Date/Time: Fri, 22 Sep 2023 14:17:40 +0000

## [User Discussion] - Sierrachart add moving average and supertrend studies

### View Count: 2454

 [2022-01-27 15:04:02] #1 noaah - Posts: 32 Hey ! Just need a bit of help to set up two studies on my graph. One is the moving average on period 20 (I put it but if I can have a confirmation that I do it well it will be very helpfull !) I attach a screenshot down there. The other is the Supertrend study, coefficient 3 and period 20. I only find the Super Trend STOP study, not the Super Trend. How to setup it if its possible ? Thanks a lot for you help ! PS: Im doing trades in 1 minute period, I just want to put the same setup than this guy: https://www.youtube.com/watch?v=fGYXpVoG198 https://www.sierrachart.com/Download.php?Folder=TicketingSystem&download=60524
 [2022-01-27 17:49:23] #2 John - SC Support - Posts: 26450 One is the moving average on period 20 (I put it but if I can have a confirmation that I do it well it will be very helpfull !) I attach a screenshot down there. If you want to have a 20 minute timeframe for your moving average, then this is correct. But, in general, when you are referring to a Moving Average "Period", the "Period" is the number of items that make up the moving average, or in the case of trading data, it is the number of bars. So you may want to think about using one of the other "Moving Average" studies (like the "Moving Average - Simple" and setting the Length to 20. Refer to the information here: Moving Average - Simple The other is the Supertrend study, coefficient 3 and period 20. I only find the Super Trend STOP study, not the Super Trend. How to setup it if its possible ? We only have the Super Trend Stop study. If you explain what you are looking for in terms of the "Super Trend", then we (or someone) might be able to point you to a study that will do what you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
 [2022-01-31 01:22:14] #3 noaah - Posts: 32 Ok top thanks! Well, there is this post: https://www.tradinformed.com/calculate-supertrend-indicator-using-excel/ , Im sorry I send it because it will explain better than me what is the Super Trend and the formula to get it! Hope itâ€™s possible to do that with Sierra !
 [2022-02-02 12:20:13] #4 noaah - Posts: 32 BASIC UPPERBAND = (HIGH + LOW) / 2 + Multiplier* ATR BASIC LOWERBAND = (HIGH + LOW) / 2 - Multiplier* ATR Here the calculation of the indicator, do you think I can integrate it in sierra ?
 [2022-02-02 18:18:02] #5 John - SC Support - Posts: 26450 You would just need to use the Average True Range study to get your ATR, but everything else is readily available. You could then use the Spreadsheet Formula to create the data. Refer to the following: ATR: Average True Range Spreadsheet Formula: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
 [2022-02-05 11:58:00] #6 noaah - Posts: 32 Wow! Ok thanks, to be honest editing the spreadsheet look a bit complicated for me, Im not good with the formulas to write etc.. Is that possible to ask help to create the spreadsheet of thos formula ? BASIC UPPERBAND = (HIGH + LOW) / 2 + Multiplier* ATR BASIC LOWERBAND = (HIGH + LOW) / 2 - Multiplier* ATR There are two formulas to calculate the Super Trend, one when it go up and one when it go down. Thanks a lot if you can help me !
 [2022-02-13 20:07:05] #7 noaah - Posts: 32 Up
 [2022-02-14 00:07:28] #8 Sawtooth - Posts: 3775 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.SG1*2 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.SG1*2 where the number after the * is the Multiplier. Date Time Of Last Edit: 2022-02-14 00:18:46
 [2022-03-13 00:44:17] #9 SC Support Tom - Posts: 450 This is in the works.
 [2022-03-13 07:55:11] #10 SC Support Tom - Posts: 450 I have been researching this, and have found various conflicting formulas for the SuperTrend. The formulas for the Basic Upper and Lower Bands given in Post #6 are universally agreed upon. The conflict comes after that. I will give two examples. 1) This site gives formulas for calculating Basic Upper and Lower Bands in Step 1, Final Upper and Lower Bands in Step 2, and the SuperTrend in Step 3. https://www.tradinformed.com/calculate-supertrend-indicator-using-excel/ 2) This site does not even bother with Final Upper and Lower Bands. The SuperTrend is computed directly from the Basic Upper and Lower Bands. https://usethinkscript.com/threads/supertrend-indicator-by-mobius-for-thinkorswim.7/ I have no way of knowing which, if either, of these sites is correct. Ordinarily I would dig up the original, authoritative source and go with that. But the SuperTrend Indicator was invented by the French trader Olivier Seban, and unfortunately all of his books are only available in French. Since I do not speak French, going to a primary source is out. I need for someone knowledgeable to tell me what the correct formula is before I can finish this. Date Time Of Last Edit: 2022-03-13 12:20:42
 [2022-03-13 18:33:31] #11 User829162 - Posts: 31 The Built-in Volatility Trend Indicator looks very similar, don't know how the actual calculations compare.
 [2022-03-13 18:46:53] #12 SC Support Tom - Posts: 450 WRT (my) Post #10, it seems that the formulas in site (2) give reasonable results. I will give it a couple of days to be corrected. If no corrections are forthcoming, then I will implement those formulas into ACSIL code and document the math accordingly. Date Time Of Last Edit: 2022-03-13 18:48:57
 [2022-03-14 07:18:53] #13 Marmany - Posts: 301 For info the Sierra study Super Trend Stop is in complete compliance with the Olivier Seban formula.
 [2022-03-16 06:35:59] #14 Acro - Posts: 434 John, I am a fan of the supertrend and have looked extensively at how this is implemented in tradingview as I have a few charts there that I can use for a myriad of global symbols. TV uses the last bar's median (hl2 in their speak) + a multiple of the "running moving average" over the chosen lookback period. They define this running moving average as the exponentially weighted moving average with alpha = 1 / length. Regardless of whether this is "correct" or not, it does produce a very good result I am happy to pop this in a spreadsheet formula study if tomglib or anyone else can explain how I phrase the RMA in that formula Thanks in advance
 [2022-03-23 03:09:27] #15 SC Support Tom - Posts: 450 WRT Post #13: For info the Sierra study Super Trend Stop is in complete compliance with the Olivier Seban formula. Thank you, this is good to know. Sorry for the delay in responding. I have been away. I will implement the SuperTrend using Super Trend Stop as my guide.
 [2022-03-23 04:09:30] #16 Acro - Posts: 434 Hi Tom, I've attached a work in progress cpp that modifies the Supertrend Stop study to use the Tradingview formula. If there's any way that can be included as a variation of the existing Supertrend Stop I'd be very grateful Private File
 [2022-03-23 04:46:54] #17 SC Support Tom - Posts: 450 WRT Post #16: I'll look at it tomorrow.
 [2022-04-10 09:58:59] #18 User113114 - Posts: 5 Hi Tom, Was there any further progress with finalising this study? Thanks in advance
 [2022-08-30 00:38:15] #19 58LesPaul - Posts: 427 What is the status of this please? Thanks in advance
 [2022-08-30 23:49:44] #20 58LesPaul - Posts: 427 Is there any further progress with finalising this study? Thanks
 [2022-09-01 10:17:44] #21 58LesPaul - Posts: 427 Hi Tom, Was there any further progress with finalizing this study? Thanks in advance
 [2022-09-02 10:52:28] #22 58LesPaul - Posts: 427 Hello Is there any further progress with finalizing this study? Thanks in advance
 [2022-09-06 03:21:55] #23 SC Support Tom - Posts: 450 I have been looking into this, and I will have more to say about it when I return to work on Thursday 9/8.
 [2022-09-09 19:11:26] #24 58LesPaul - Posts: 427 Tom, have you had a chance to look at this? Thanks
 [2022-09-12 04:21:11] #25 SC Support Tom - Posts: 450 WRT Post #24: Tom, have you had a chance to look at this? I am actively looking at it. I am just not finished with it yet. We appreciate your patience.

To post a message in this thread, you need to log in with your Sierra Chart account: