Support Board
Date/Time: Sun, 09 Mar 2025 20:38:25 +0000
Adding an existing study into a spreadsheet
View Count: 635
| [2022-03-07 18:25:49] |
| User837393 - Posts: 143 |
|
Hello, I did some clean up into an existing spreasheet. I've deleted the columns of the studies that I'm not using. Now lets say I would like to add the study back into the spreadhseet, what should I do ? Only way I found was to remove the study from the chart and then add it back, only there it will show back into the spreadsheet. Thank you for the assistance. |
| [2022-03-07 21:16:21] |
| John - SC Support - Posts: 38516 |
|
What method did you use to delete the columns? Selecting Spreadsheet >> Delete Column will temporarily remove the data, but as new bars are added the information will repopulate into Row 3 and then move down as new bars are added. So doing that really does not remove the data. The only way to not have the data display in the Spreadsheet is to use the options on the Study Settings window for Include in Spreadsheet - refer to the following: Chart Studies: Settings and Inputs Tab >> Include in Spreadsheet And also Include in Spreadsheet for each Subgraph - refer to the following: Chart Studies: Subgraphs Tab >> Include in Spreadsheet You would then select these options to get the data back into the spreadsheet. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2022-03-07 21:16:35
|
| [2022-03-08 13:45:04] |
| User837393 - Posts: 143 |
|
What method did you use to delete the columns? Selecting Spreadsheet >> Delete Column will temporarily remove the data, but as new bars are added the information will repopulate into Row 3 and then move down as new bars are added. So doing that really does not remove the data.
-Correct this is what I did. Ack on the repopulate after the new bar.The only way to not have the data display in the Spreadsheet is to use the options on the Study Settings window for Include in Spreadsheet - refer to the following:
-The issue is that when using "Include in spreadhseet" I can only exclude/include individuel "SG" settings and not the entire studies. It is ok though. If this is the way to do it i.e. by individual SG settings then that is fine also, I just want to make sure that this is the way to go.Chart Studies: Settings and Inputs Tab >> Include in Spreadsheet Thank you. Date Time Of Last Edit: 2022-03-08 13:46:24
|
| [2022-03-08 14:50:37] |
| |
|
If you want to exclude an entire study from being outputted to the Spreadsheet Study then use this setting: Chart Studies: Settings and Inputs Tab >> Include in Spreadsheet This is not a Subgraph specific setting but is on the Settings and Inputs tab of the Study Settings window. 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: