Login Page - Create Account

Support Board


Date/Time: Fri, 27 Jun 2025 10:57:04 +0000



Spreadsheet Study

View Count: 566

[2021-10-10 03:49:38]
User841161 - Posts: 287
I don't want a separate studies output to be listed in my spreadsheet study. I have unmarked include in spreadsheet box in (settings an input) and in (subgraph of study) but still am getting output from study into my spreadsheet study. What do I need to do?


http://www.sierrachart.com/image.php?Image=1633837628436.png
[2021-10-10 14:31:28]
John - SC Support - Posts: 40626
It is all dependent on the timing of when you selected the options to not display in the Spreadsheet.

If you had added the spreadsheet after you had deselected the option to Include in Spreadsheet, then the study would not show.

But, it sounds like the order of things in your case, was that you had the Spreadsheet added, which then put the study into the spreadsheet, and then you deselected the option in the Bar Numbering for Include in Spreadsheet. Since the data was already there, it was not removed (as you found out). Your options would be to either delete the column(s) of data or you could select Edit >> Reload and Recalculate.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-10-11 01:50:10]
User841161 - Posts: 287
Edit>>Reload and Recalculate did not work. But was able to highlight column and right click and clear selection, instead of deleting whole column.

Also took out study altogether and tried to reload and recalculate, but all numbers from study stayed in column in Spreadsheet study, which I thought was weird. Would have thought if study was deleted, it would be deleted from spreadsheet study because at that point the study didn't even exist?
[2021-10-11 02:53:07]
Sierra Chart Engineering - Posts: 104368
No, this is not the case. Refer to:
Using the Spreadsheet Study: Clearing Old Study and Other Data from 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

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

Login

Login Page - Create Account