Support Board
Date/Time: Mon, 17 Mar 2025 18:25:49 +0000
[User Discussion] - Can't get rid of unneeded spreadsheet data
View Count: 500
| [2022-09-17 20:51:02] |
| bradyfans - Posts: 16 |
|
I have 2 quick questions. The first is how the "sheets" work. I notice that after adding a few charts to a chartbook with a spreadsheet for trading system, when I go to the spreadsheet there is a dropdown with "sheet 1", sheet 2", etc. I can't figure out what the sheets correspond to, however. I would assume each sheet relates to a different chart, but I'm not sure. I don't see anywhere in the documentation that explains this. The second issue is that I have a spreadsheet that I have unclicked the boxes to "display on spreadsheet" for everything I don't want displayed, both under the settings and inputs as well as the subgraphs tab (each individual SG). But things keep showing up on the left side of the spreadsheet. They're studies I have used in the past or may be somehow based on the main chart, or overlays, but why are they still showing up? I'm sure there's an easy explanation. I'm just not seeing it. Thanks! |
| [2022-09-18 20:10:58] |
| Sawtooth - Posts: 4185 |
|
1. By default, the Sheet# corresponds directly to the Chart#. If you duplicate a chart, and it has a spreadsheet study on it, it will add a corresponding Sheet#. If the Chart# no longer exists, or the spreadsheet study on that chart is Removed, you can delete the spreadsheet Sheet: Spreadsheet >> Delete Sheet 2. Not sure what you mean by the 'left side of the spreadsheet'. If you are referring to the Formula Columns, which still have formulas, they might be referencing columns of studies that are no longer there. This would especially be true if you are using column/row references instead of the recommended referencing method here: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study |
| [2022-09-18 21:03:52] |
| bradyfans - Posts: 16 |
|
Thank you. Really helpful. And I'm sorry, I typed "left" when I meant right. I was referencing cells instead of the recommended way, because some video I saw online said to do it that way. But the recommended way makes much more sense. |
To post a message in this thread, you need to log in with your Sierra Chart account: