Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 10:10:50 +0000



Missing data

View Count: 779

[2015-10-10 21:12:09]
User713273 - Posts: 409
Please review attached docs, looking at the sec data, is there a filter to enable all columns to be filled?
imageimage.png / V - Attached On 2015-10-10 21:12:01 UTC - Size: 244.22 KB - 239 views
[2015-10-10 21:26:55]
User713273 - Posts: 409
I checked the "include columns with no data" in the chart settings, so im just looking to fill said columns with last value.
[2015-10-10 22:23:21]
Sierra Chart Engineering - Posts: 104368
We do not understand the question here. Include Columns with No Data will do what you want.

Please understand our time is very valuable, and only post when necessary, and be very clear about what it is you are asking about.
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: 2015-10-10 22:23:46
[2015-10-10 22:37:26]
User713273 - Posts: 409
For instance in these columns/rows (BU - 23142 - 23133 & BX 23140 - 23133), the data is not established I believe due to the 1 sec data indicator arent outputting data. I would need these data points to be produced, even if it means duplicating the prior cells data.

I understand your time is valuable, thx again.
[2015-10-10 22:39:33]
Sierra Chart Engineering - Posts: 104368
What studies are in those Sheet columns?
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
[2015-10-10 22:43:53]
User713273 - Posts: 409
Those are study angle values. I also attached a 2nd screenshot highlighting RSI values which are also 0 in some instances.
imageimage (2).png / V - Attached On 2015-10-10 22:43:38 UTC - Size: 231.13 KB - 243 views
[2015-10-10 23:56:48]
Sierra Chart Engineering - Posts: 104368
If they are zero, then they are zero. Zero is the result of the calculations being performed by the study. This cannot be changed.
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
[2015-10-11 00:45:41]
User713273 - Posts: 409
I have attached another screen shot that I would like for you to look at. These RSI data points on the 1 sec chart stay at that numerical rate from 6:33:51 - 6:48:44 on 10/9 for symbol AAPL. Is this normal? I did recalculate the chart.
imageimage (3).png / V - Attached On 2015-10-11 00:42:58 UTC - Size: 185.95 KB - 254 views
imageimage (4).png / V - Attached On 2015-10-11 00:45:27 UTC - Size: 188.77 KB - 234 views
[2015-10-11 01:49:56]
User713273 - Posts: 409
It seems to outlay correctly when not using "include columns with no data". I can't use this setting, thx.
Date Time Of Last Edit: 2015-10-11 02:01:09
[2015-10-12 15:25:16]
User713273 - Posts: 409
This might be the root of the problem, i can also send the log or chartbook for review. Thx

Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:38 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:38 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:40 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:41 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:42 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:43 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:43 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:45 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:45 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:46 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:47 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:47 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:48 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:48 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:50 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:51 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:52 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:52 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:53 *
Chart: AAPL 1 Sec #1 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-10-12 08:22:53 *
[2015-10-12 16:52:41]
Sierra Chart Engineering - Posts: 104368
What we need you to do is to attach the Chartbook file you are using and the DefaultSpreadsheetStudy.scss file.

These can be privately attached. Here are instructions:
https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile


Open the Message Log with Window >> Show/Hide Message Log if it is not already open.

Go to the very top of that log. There is a line that indicates whether you are running New Spreadsheets or Old Spreadsheets. It will be the second line from the top. What are you running?
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
[2015-10-12 16:58:04]
User713273 - Posts: 409
Running new spreadsheets, will follow w/ chartbook.
[2015-10-12 17:33:37]
User713273 - Posts: 409
For your review
attachmentDefaultSpreadsheetStudy.scss - Attached On 2015-10-12 17:33:02 UTC - Size: 116 B - 267 views
attachmentChartbook-AAPL.cht - Attached On 2015-10-12 17:33:14 UTC - Size: 263.56 KB - 255 views
[2015-10-12 18:05:03]
Sierra Chart Engineering - Posts: 104368
We are testing this and have not yet encountered any exceptions.

We noticed that the Number of Rows setting is quite high. This should not cause an exception though.

However, we recommend reducing that to a lower number. Unless there is a specific reason it needs to be 999999, we recommend using a number like 10000. Reduce it and see if you still notice 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
[2015-10-12 19:21:31]
User713273 - Posts: 409
Ive lowered the setting on the amount of rows and it does seem to be more efficent. Ive also set the chart update interval to 999 miliseconds as im using the sec chart and it seemed the most resonable. Notiched some lag but much improved.
[2015-10-13 01:06:20]
User713273 - Posts: 409
Just you to be aware im still receiving sporadic RSI data on the 1 sec chart. From 630:16 - 7:54:41, I receivid 0 as the value. Please advise.
Date Time Of Last Edit: 2015-10-13 01:07:13
imageimage.png / V - Attached On 2015-10-13 01:06:53 UTC - Size: 217.73 KB - 248 views
[2015-10-13 02:01:09]
Sierra Chart Engineering - Posts: 104368
Once again, if RSI is giving a result of 0 that is the result based upon the data and the RSI formula. You can always create your own RSI study to do what you require.
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