Home >> Support Board

Support Board

Date/Time: Sat, 20 Apr 2024 16:23:41 +0000

How to Post a Message for Support

Daily Moving Average On Intraday Timeframe?

View Count: 2515

[2019-01-21 00:45:49] #1 [Go To First Post]
User116783 - Posts: 84
Hello, Is there a way to plot a daily moving average on an intraday chart? For example, I would like to put a 20 day simple moving average on a 1 hour chart. Thanks, ZS Date Time Of Last Edit: 2019-01-21 00:46:07

[2019-01-21 01:05:18] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes. Refer to: Study/Price Overlay Study 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

[2019-01-21 01:28:58] #3 [Go To First Post]
User116783 - Posts: 84
Ok I was able to overlay the 20 day SMA on the 1 HR timeframe, however the values are different. On the daily chart for XBTUSD the 20 day SMA as of 8:28 PM EST is 3727.3 but on the the 1 HR timeframe it's 3741.6. I did double check the study settings (attached pic) and I believe they are all correct. ZS Date Time Of Last Edit: 2019-01-21 02:18:09


Capture.PNG / V - Attached On 2019-01-21 02:17:21 UTC - Size: 137.52 KB - 338 views

[2019-01-21 18:47:48] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We ran a test and do not observe this. We see the latest moving average on the destination chart. Try setting the Bar Time Matching Method study Input to Containing Match. 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

[2019-01-22 01:12:20] #5 [Go To First Post]
User116783 - Posts: 84
I've tried adjusting all the overlay study settings and I couldn't get the destination chart (XBTUSD 1 hr time-frame) to display the correct value from the source chart (XBTUSD daily time-frame). With the exception of changing Match Source Bars To Destination Bars from Yes to No (which gave me the correct value for the 20 day simple moving average but compressed all the candlesticks). I'm officially stumped. I've attached pics of the destination chart, the source chart, as well as the destination study settings and source study settings. If something looks amiss, please let me know. Thanks, ZS Date Time Of Last Edit: 2019-01-22 03:33:35


DAILYCHART.PNG / V - Attached On 2019-01-22 01:10:38 UTC - Size: 54.56 KB - 327 views 1HRCHART.PNG / V - Attached On 2019-01-22 01:10:44 UTC - Size: 62.71 KB - 320 views DAILYSTUDYSETTINGS.PNG / V - Attached On 2019-01-22 01:11:53 UTC - Size: 99.85 KB - 306 views

[2019-01-22 01:13:47] #6 [Go To First Post]
User116783 - Posts: 84
Here are the 1 hour study settings (couldn't include them in the previous post). ZS


1HOURSTUDYSETTINGS.PNG / V - Attached On 2019-01-22 01:13:38 UTC - Size: 127.73 KB - 328 views

[2019-01-23 01:47:49] #7 [Go To First Post]
User116783 - Posts: 84
After trying some more, I believe that this discrepancy isn't due to pilot error. Here are the only steps I'm taking. 1. Add Study/Price Overlay 2. Input Name: Study to Overlay (In:10) 3. Input Value: #1.ID2 4. Based On: <Main Price Graph> 5. Chart Region: 1 6. Value Format: Inherited Results are in the attached picture. Source chart with correct 20 day SMA. Destination chart with incorrect 20 day SMA. Date Time Of Last Edit: 2019-01-23 01:55:26


2019-01-22_20-42-21.png / V - Attached On 2019-01-23 01:47:42 UTC - Size: 66.57 KB - 330 views

[2019-01-25 22:30:14] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Attach those 2 charts as a Chartbook: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile You need to also tell us the time zone for the Intraday chart. Refer to: Time Zone Setting 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

[2019-01-26 02:00:49] #9 [Go To First Post]
User116783 - Posts: 84
Thanks. The file is attached. Time zone is New York EST. ZS EDIT: I just added the study/overlay again, and now it's working perfectly fine. Strange. Date Time Of Last Edit: 2019-01-26 02:05:22


XBTUSD Perpetual Swap.Cht - Attached On 2019-01-26 02:00:12 UTC - Size: 109.4 KB - 280 views

[2019-01-27 02:35:27] #10 [Go To First Post]
User116783 - Posts: 84
Not so fast. I just logged back into SC and the 20 daily moving average is incorrect again that is overlayed on the 1 hour chart. ZS

[2019-01-29 18:38:18] #11 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
The problem is that if you look at the historical daily chart, the date is in the next day. Make sure that chart itself is set to the New York time zone: Time Zone Setting: Using Different Time Zone in Individual Charts If you still have a problem use Intraday data instead for the daily bars: Chart Session Times: Creating Daily Bars with Custom Session Times 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 Date Time Of Last Edit: 2019-01-29 18:38:48

[2019-01-30 01:26:31] #12 [Go To First Post]
User116783 - Posts: 84
NM Date Time Of Last Edit: 2019-01-30 03:36:44

[2019-01-30 02:40:40] #13 [Go To First Post]
User116783 - Posts: 84
NM Date Time Of Last Edit: 2019-01-30 03:37:01

[2019-01-30 03:20:44] #14 [Go To First Post]
User116783 - Posts: 84
Ok, I think I've made a breakthrough. XBTUSD's clock runs off UTC (Universal) Time. 7 PM EST is equal to 0:00:00 UTC-5 Time and is the beginning of a new day. So any time between 7:00 PM-11:59 PM EST will read as one day ahead. Although this doesn't apply to intraday charts, which still show today's date. Why the discrepancy between the two, I don't know...... But yes, if you could add UTC-5 time, I believe that will solve the problem. :) ZS Date Time Of Last Edit: 2019-01-30 03:36:14

[2019-01-30 04:33:03] #15 [Go To First Post]
User116783 - Posts: 84
Fiddling around a bit more, and I still can't fix things. These are my settings on both the daily chart and the 60 minute chart (I believe the UTC Offset of -05:00 is equal to EST). Chart Settings -> Advanced Settings -> Time Zone -> Other/Custom DST -> UTC Time Zone -> UTC -05:00 Global Settings -> Data/Trade Service Settings -> Time Zone -> Other/Custom DST -> UTC Time Zone -> UTC Offset -05:00 Not only is the study/overlay still incorrect, but time itself is incorrect when scrolling over candles on the 60 min chart. I'm attaching another chartbook. Please let me know if there is a workable solution. ZS Date Time Of Last Edit: 2019-01-30 04:40:56


XBTUSD Perpetual Swap.Cht - Attached On 2019-01-30 04:32:44 UTC - Size: 138.83 KB - 278 views

[2019-01-31 17:22:58] #16 [Go To First Post]
User116783 - Posts: 84
I've found a solution: Put both the daily chart (source chart) and the 1 Hour chart (destination chart) to UTC (+0 UTC). Chart Settings -> Advanced Settings -> Time Zone -> UTC (+0 UTC) Global Settings -> Data Trade Service Settings -> Time Zone -> UTC (+0 UTC) Works like a charm. ZS Date Time Of Last Edit: 2019-01-31 17:23:21

[2019-01-31 18:49:45] #17 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Specifically set the Time Zone on the Daily bar chart to US Eastern (New York). Not UTC -5. When using Intraday data to create the daily bars, those daily chart bars will be slightly different compared to the actual historical daily data but that is how it has to be. 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 Date Time Of Last Edit: 2019-01-31 18:51:20

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