Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 13:50:37 +0000



Missing one (one before last) bar data for custom studies in spreadsheet

View Count: 648

[2016-11-15 15:01:33]
wat - Posts: 67
I have a problem with missing data for my custom studies in spreadsheed generated by spreadsheetstudy. The difference is that the one before last bar is missing in scss (see attached images) making whole data off by one bar.

The problem is probably caused by one of following settings in study (as that is pretty much all that is there):

sc.CalculationPrecedence = VERY_LOW_PREC_LEVEL;
sc.MaintainAdditionalChartDataArrays = 1;
sc.MaintainVolumeAtPriceData = 1;

Result:
2013-01-02 12:05:00 46
2013-01-02 12:00:00 44
2013-01-02 11:55:00 43

Expected:
2013-01-02 12:05:00 46
2013-01-02 12:00:00 45
2013-01-02 11:55:00 44

SierraChart version 1481
Date Time Of Last Edit: 2016-11-16 13:09:45
imagetest_graph.png / V - Attached On 2016-11-15 15:00:11 UTC - Size: 42.96 KB - 188 views
imagetest_scss.png / V - Attached On 2016-11-15 15:00:14 UTC - Size: 58.33 KB - 199 views
Attachment Deleted.
Attachment Deleted.
Attachment Deleted.
Attachment Deleted.
Attachment Deleted.
[2016-11-15 16:30:53]
Sierra Chart Engineering - Posts: 104368
This is not within the scope of our support.

We do not understand what you are trying to say.

If there is missing data in the underlying chart bars, and you think there is a data problem we need to look into a for particular symbol and a particular Date-Time, let us know what that is. Otherwise we cannot help with this.

Your Sierra Chart account is also expired.
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: 2016-11-15 16:31:18
[2016-11-15 19:13:34]
wat - Posts: 67
Please check attached images. The data ouputted by Spreadsheet Study is not same as in graph for some settings of custom studies (from what I tested).

Last bar is correct. The last-1 bar has incorrect value in produced spreadsheet (having value of last-2 bar). As for 12:00:00 there should be value 45, instead of 44.

This seems like a bug of spreadsheet study (because chart data are correct).

Provided testing study just increases value by 1 for every bar. To see it more clearly that in scss there is difference by 2.
[2016-11-16 03:27:49]
Sierra Chart Engineering - Posts: 104368
The data outputted by Spreadsheet Study is not same as in graph for some settings of custom studies (from what I tested).
This is a calculation precedence/order issue.

This is documented here:

http://www.sierrachart.com/index.php?page=doc/ChartStudies.html#StudyCalculationPrecedence

There definitely is not a bug in the Spreadsheet study. That is not even possible.

We have seen the kind of issue you describe before. And the cause is as explained.
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