Login Page - Create Account

Support Board


Date/Time: Thu, 16 May 2024 18:46:12 +0000



Chart Sync

View Count: 1127

[2017-05-18 17:07:38]
User170575 - Posts: 221
Good afternoon,

I have a 1 minute chart with study overlays from 5 minute charts ---as the bars form in the 1 minute chart the
study from the 5 minute overlay does not maintain it's sync though it is several bars back. These overlays are used
in a spreadsheet study--as the study changes the spreadsheet number changes on more than one row---most often 4-6.

Is there a way to set the overlay so the shorter term chart will simply undate the most recent single cell.

Here are a couple of files to illustrate. On the first two files note the crosshair is on the same time and the lower indicator
is has changed. The 3rd file is just of the spreadsheet changing multiple cells.

Hope this makes sense---and thanks you@!!

Cy
imagesc1.jpg / V - Attached On 2017-05-18 17:04:23 UTC - Size: 112.64 KB - 268 views
images2.jpg / V - Attached On 2017-05-18 17:04:35 UTC - Size: 85.11 KB - 261 views
imagesc3.jpg / V - Attached On 2017-05-18 17:04:44 UTC - Size: 20.66 KB - 270 views
[2017-05-18 22:32:57]
Sierra Chart Engineering - Posts: 104368
These are the relevant sections which may help with this:


Study/Price Overlay Study: Inconsistent Dependent Results Between Full Calculation and Real-Time Updating

Study/Price Overlay Study: Data Changing at Chart Bars Earlier Than Being Referenced in Source Chart


Also review the other sections on the page in case any of them has helpful information for the particular issue you are having:
Study/Price Overlay Study

Otherwise, this is not within the scope of our support. We can refer you to a programmer that can help you for an additional cost.
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: 2017-05-19 05:57:55
[2017-05-19 06:00:37]
Sierra Chart Engineering - Posts: 104368
You are also running an old version of Sierra Chart.

You will need to update to the current version because the problem you are having may already be resolved. If not, you will need to seek the help of a paid programmer.

Refer to:
Software Download: Fast Update
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-05-19 14:17:16]
User170575 - Posts: 221
Many thanks, one thing---if the spreadsheet study is on a one minute chart---will the spreadsheet shift the bars down every
minute? Seems to do that with the 15min chart just fine.

Images for your review.

Thanks for all the help!
Cy
imagesc4.jpg / V - Attached On 2017-05-19 14:14:24 UTC - Size: 56.93 KB - 353 views
imagesc5.jpg / V - Attached On 2017-05-19 14:14:33 UTC - Size: 57.28 KB - 289 views
[2017-05-20 14:30:49]
Sierra Chart Engineering - Posts: 104368
Yes, but if there is a study you are using which is changing values at earlier chart bars other than the last bar and for any new bars added, this can be a problem.

This is explained here:
Study/Price Overlay Study: Data Changing at Chart Bars Earlier Than Being Referenced in Source Chart

In this Sheet image:
https://www.sierrachart.com/Download.php?Folder=SupportBoard&download=12092

we can see repeating times. Why is that the case? Do those chart bars have the same time? If not, this is a problem.
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-05-22 17:33:41]
User170575 - Posts: 221
Good afternoon,

The only studies are VWAP and CCI(source chart)...which I dont think cause changing values?

As for the repeating it is contingent on how many spreadsheet studies are in the destination
chart---if I add in 16---it will have 16 repeats. Your thoughts appreciated.


Many thanks,
Cy
imagesc8.jpg / V - Attached On 2017-05-22 17:33:24 UTC - Size: 45.99 KB - 235 views
[2017-05-22 17:44:12]
Sawtooth - Posts: 3997
You cannot use multiple instances of the same-named spreadsheet study in the same chartbook.
You cannot use the same-named spreadsheet study concurrently in multiple chartbooks.
Date Time Of Last Edit: 2017-05-23 03:12:03
[2017-05-22 18:20:07]
User170575 - Posts: 221
Thanks Tom---I will rewrite it to just one--appreciate all your help, Cy
[2017-05-23 01:47:42]
Sierra Chart Engineering - Posts: 104368
Are you using the same Spreadsheet Sheet from multiple Spreadsheet Studies within the same chart? If so, that is not going to work right at all.


This is either vague, or not correct:
You cannot use multiple instances of the same-named spreadsheet file in the same chartbook.
It is not possible for there to be multiple instances of a spreadsheet file to begin with. Are you referring to multiple instances of the Spreadsheet Study using the same Spreadsheet file within the same Chartbook? If so, there is no problem with this that we are aware of.
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-05-23 03:48:31]
Sawtooth - Posts: 3997
Are you referring to multiple instances of the Spreadsheet Study using the same Spreadsheet file within the same Chartbook?
I am referring to multiple instances of any spreadsheet study using the same-named spreadsheet file within the same chartbook.
In some configurations, as in the OP's, it can exhibit duplicate rows of the same datetime, as shown in sc4.jpg in post #4.

I also referred to the concurrent use of a same-named spreadsheet study in more than one chartbook.
In some situations, it can exhibit continual recalculations.

To avoid problems, I always use uniquely-named spreadsheet studies.
[2017-05-23 04:12:08]
Sierra Chart Engineering - Posts: 104368
I am referring to multiple instances of any spreadsheet study using the same-named spreadsheet file within the same chartbook.
There should most definitely never be a problem with this as long as each instance of the Spreadsheet Study is using a different Sheet within the Spreadsheet.

We are not aware of any issue with this. If there is, we need a test Chartbook demonstrating this.


In some configurations, as in the OP's, it can exhibit duplicate rows of the same datetime, as shown in sc4.jpg in post #4.
We have no definite knowledge as to what their configuration is at this point in time. We can only speculate.
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: 2017-05-23 04:15:04
[2017-05-23 06:08:57]
Sawtooth - Posts: 3997
There should most definitely never be a problem with this as long as each instance of the Spreadsheet Study is using a different Sheet within the Spreadsheet.
The OP was using the same sheet in each same-named spreadsheet study. This is the default setting, since they were all on the same chart. Using different sheets would have solved the problem, but he solved it by combining everything into a single spreadsheet study.
[2017-05-23 13:13:43]
User170575 - Posts: 221
"We are not aware of any issue with this. If there is, we need a test Chartbook demonstrating this."

Files attached. Just duplicate one of the SS studies and it will add another row at the time
interval.

Thanks for the help---it should be resolved, as Tom indicated, I rewrote it just to one SS study.

Cy
Attachment Deleted.
Private File
Private File
[2017-05-23 14:19:04]
Sierra Chart Engineering - Posts: 104368
We do not need to look at this.


Just duplicate one of the SS studies and it will add another row at the time
interval.
You are already explaining the issue here. When you duplicate a Spreadsheet study on the same chart, both the same Sheet and Spreadsheet are going to be used to contain the chart data and studies an additional time from the same chart. This is not only inefficient, it is going to cause conflicts. This is unresolvable and we do not even understand why this is being done to begin with. It should be obvious it does not make sense.
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

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

Login

Login Page - Create Account