Support Board
Date/Time: Mon, 23 Dec 2024 16:38:39 +0000
Missing data
View Count: 867
| [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?
|
| [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] |
| |
|
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] |
| |
|
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.
|
 image (2).png / V - Attached On 2015-10-10 22:43:38 UTC - Size: 231.13 KB - 269 views |
| [2015-10-10 23:56:48] |
| |
|
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.
|
| image (3).png / V - Attached On 2015-10-11 00:42:58 UTC - Size: 185.95 KB - 283 views image (4).png / V - Attached On 2015-10-11 00:45:27 UTC - Size: 188.77 KB - 262 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] |
| |
|
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
|
 DefaultSpreadsheetStudy.scss - Attached On 2015-10-12 17:33:02 UTC - Size: 116 B - 379 views Chartbook-AAPL.cht - Attached On 2015-10-12 17:33:14 UTC - Size: 263.56 KB - 385 views |
| [2015-10-12 18:05:03] |
| |
|
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
|
| [2015-10-13 02:01:09] |
| |
|
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: