Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 14:22:11 +0000



Missing Spreadsheet Rows

View Count: 682

[2016-08-16 07:27:14]
User787778 - Posts: 139
On a 1 minute ZBU6 chart today, spreadsheet rows are missing for the following bars, time(New York) 02:51:00, 02:33:00, 02:34:00 and there are more.
On the Bar Chart, the bar is shown.
I have tried starting a new Chart Book.
I have tried "Delete all Data and Down Load".
Thanks in advance.
[2016-08-16 17:35:54]
Sierra Chart Engineering - Posts: 104368
This does not make sense.

The data that is in the chart will be outputted to the Spreadsheet Sheet when using the Spreadsheet study. There is not anything that can go wrong with this.

If not, check the Number of Rows Input setting and make sure you are looking at the correct Sheet. Refer to:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#NumberofRows
http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#ChartDataOutputSheetNumber

After further review, the problem is simply that the market did not trade at those times. We verified that. So the data is not in the chart either.
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-08-16 17:36:20
[2016-08-16 17:44:42]
User787778 - Posts: 139
Thanks.

What I want to do, is show the MACD, under the current bar(on a minute bar) but exactly a week previously. I accept that no trading activity may cause some "blanks".

I thought I could do this by referencing to the relevant row in the spreadsheet, but if rows are missing the this is not possible.

How else could I do it.
[2016-08-16 18:18:13]
Sierra Chart Engineering - Posts: 104368
Refer to this Chart Setting: http://www.sierrachart.com/index.php?page=doc/ChartSettings.html#IncludeColumnsWithNoData
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