Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 11:36:14 +0000



Unable to Output Study Data to Spreadsheet Study

View Count: 1305

[2018-06-29 15:32:49]
TapeReader - Posts: 88
Hi,

Something has gone awry with my ability to output data to a spreadsheet study.

In the attached example RSI study data is outputted, however, there is no RSI study on the chart.

However, there is a Zig-Zag study and none of this study's output is not written to the .scss file (Note - Additional Output for Spreadsheets = Yes).

I have tried a bunch of permutations with different machines, different spreadsheet studies, different .scss files and different sheets in .scss files, but the behavior remains the same.

I have revved to build 1772 and the behavior remains the same.

Can SC Engineering open the attached chartbook and scss file to see of the behavior is consistent on your side of the fence?

Thanks,
C
attachmentZZ Output.Cht - Attached On 2018-06-29 15:30:18 UTC - Size: 39.25 KB - 342 views
Private File
Attachment Deleted.
[2018-06-29 21:41:37]
Sierra Chart Engineering - Posts: 104368
We took a look and you did not have the option for Include in Spreadsheet selected for the Zig Zag study. This is necessary, even if you select Yes to Additional Output for Spreadsheets.

As to the RSI information, this spreadsheet must have been used previously with that study included in it. Although once you correct the issue with the Zig Zag, it will overwrite the columns from the RSI that were there.
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
[2018-07-01 13:38:04]
TapeReader - Posts: 88
Hi,

I am now able to output the SG.1 From Zig-Zag, however, the cells in the remaining subgraphs columns in the .scss file (SG.2 - SG.9) are blank.

Any insights here?
attachmentZZ Output_02.Cht - Attached On 2018-07-01 13:37:23 UTC - Size: 39.25 KB - 234 views
attachmentTemp.scss - Attached On 2018-07-01 13:37:28 UTC - Size: 137.34 KB - 265 views
[2018-07-01 14:00:23]
TapeReader - Posts: 88
Update....I see now that there are multiple check-boxes in the Zig-Zag study for 'Include in Spreadsheet'.

One is on the 'Settings and Input' tab and one is exposed on the 'Subgraphs' tab for each subgraph.

I am now able to output the data.

All's good.

This issue is closed.
Date Time Of Last Edit: 2018-07-01 14:42:56
[2018-07-01 14:34:28]
Sierra Chart Engineering - Posts: 104368
For future reference here is the relevant documentation:
Using the Spreadsheet Study: Solving Study Not Displaying On Spreadsheet Sheet
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