Support Board
Date/Time: Thu, 16 Jan 2025 05:00:45 +0000
Reset a Moving Average at the beginnig of each day session ?
View Count: 3946
[2017-10-12 18:35:39] |
User671527 - Posts: 3 |
So the moving average will start fresh every day. I want the moving average to start calculating values from the first price of the day when ther's a gap up in the opening and not to continue from yesterday's price like the SMA in my cap. http://www.sierrachart.com/image.php?Image=1507833181498.png |
[2017-10-12 21:32:28] |
Sawtooth - Posts: 4153 |
This can be done with the Spreadsheet Study study. Put both attached files in your Sierra Chart \Data folder. To add this study to your chart, go to Analysis >> SMA at new day+ Choose No when asked 'Clear existing studies on chart?' The SMA length is set in cell J2 on the spreadsheet. You can minimize it if you want. It is set to average the Last price, starting at the first bar of a new day. |
SMA at new day.scss - Attached On 2017-10-12 21:27:33 UTC - Size: 43.08 KB - 437 views SMA at new day+.StdyCollct - Attached On 2017-10-12 21:27:50 UTC - Size: 9.41 KB - 504 views |
[2017-10-12 22:19:16] |
Sierra Chart Engineering - Posts: 104368 |
Have a look at this new study available in the latest prerelease: Average - Continuous Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
[2017-10-13 00:21:31] |
User671527 - Posts: 3 |
Thanks but both don't work ! 1) added the "sma at new day" changed the J21 cell to my need (21) : sadly nothing appears on the chart. 2) added the Average-Continuous study, but it plot the start of the new sma (pink one) exactly where it was before, even when the "Reset at Start of Trading Day" is set to "Yes". http://www.sierrachart.com/image.php?Image=1507853862477.png Any idea ? |
[2017-10-13 01:09:33] |
Sawtooth - Posts: 4153 |
1) added the "sma at new day" changed the J21 cell to my need (21) : sadly nothing appears on the chart.
The Length is set in cell J2, not J21.
|
[2017-10-13 02:32:46] |
Sierra Chart Engineering - Posts: 104368 |
2) added the Average-Continuous study, but it plot the start of the new sma (pink one) exactly where it was before, even when the "Reset at Start of Trading Day" is set to "Yes". http://www.sierrachart.com/image.php?Image=1507853862477.png Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
[2017-10-13 08:39:21] |
User671527 - Posts: 3 |
My mistakes, both working now! Thanks alot !!!!! Date Time Of Last Edit: 2017-10-13 09:16:23
|
To post a message in this thread, you need to log in with your Sierra Chart account: