Login Page - Create Account

Support Board


Date/Time: Thu, 16 May 2024 12:02:51 +0000



problem with spreadsheet study

View Count: 1884

[2017-10-23 21:08:35]
User807026 - Posts: 86
I have set up 2 different charts of CL, one with a 5 minute time frame and the other with a 30 minute time frame. I have put a zigzag study on both with only the lines and the length of the line being displayed. I then set up 2 different spreadsheets one for each chart and put a spreadsheet study on both. The settings on both spreadsheets studies are identical. The data on the 5 minute spreadsheet shows all the data from the chart, the data on the 30 minute spreadsheet does not show the length of the zigzag line which is the one piece of data that I am looking for. I have deleted the 30 minute spreadsheet and set it up several time. I have tried reloading and recalculating the chart several times and the data for the length of the zigzag line does not show up on that spreadsheet like it does on the 5 minute spreadsheet.
[2017-10-24 21:02:40]
User807026 - Posts: 86
I posted this over 24 hours ago with not response.
[2017-10-24 23:12:22]
Sierra Chart Engineering - Posts: 104368
A question like this can take more than a day for an answer.

Make sure this Input with the Zig Zag study is set to Yes:

Zig Zag: Additional Output for Spreadsheets
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-10-25 00:45:35]
User807026 - Posts: 86
It is.
[2017-10-25 02:11:16]
Sierra Chart Engineering - Posts: 104368
Where the Zig Zag study Subgraph is being outputted to the Sheet, do you see a column named Zig Zag Line Length?

There are not going to be nonzero values at each row in the Sheet. Only where there is a change in the Zig Zag line.
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-10-26 20:05:06
[2017-10-25 12:14:51]
User807026 - Posts: 86
I understand that it only will print when there is a change. It is working fine on the 5 minute chart just not on the 30 minute chart with the exact same settings.
[2017-10-25 17:18:49]
User807026 - Posts: 86
Seems to be working now, I didn't change anything. I will let you know if this changes. Thanks.
[2017-10-25 17:26:28]
Sierra Chart Engineering - Posts: 104368
The question is do you see the column? Attach a screenshot of the Sheet showing what you see. Here are instructions:
https://www.sierrachart.com/index.php?page=PostingInformation.php#Image
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-10-25 17:27:02
[2017-10-25 21:56:03]
User807026 - Posts: 86
http://www.sierrachart.com/image.php?Image=1508968545226.png
[2017-10-26 20:04:48]
Sierra Chart Engineering - Posts: 104368
We are not understanding this because we do see this information on the sheet provided in post #9:
the data on the 30 minute spreadsheet does not show the length of the zigzag line which is the one piece of data that I am looking for. I

We clearly see the Zig Zag Line Length column with data.
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-10-26 20:05:52
[2017-10-26 20:40:27]
User807026 - Posts: 86
It does show now, it wasn't previously.

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

Login

Login Page - Create Account