Support Board
Date/Time: Sat, 11 Jan 2025 09:52:29 +0000
Post From: Formula plot-subchart study
| [2016-11-13 14:21:12] |
| Sawtooth - Posts: 4147 |
|
Inserting beyond 20 formula columns would change all the letters
If you use the ID#.SG#@# referencing format, you can insert columns, and studies, without this problem.http://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy If column H does not provide enough cells, you can add a sheet to the spreadsheet that is not associated with a chart to do intermediate calculations and user input tables, then reference them from sheets that are associated with charts. http://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesOtherSheets Here are my recommendations when building a complex system: -Set the Number of Formula Columns to 60. It doesn't hurt to have spares when you're working. You can reduce them later if you must, if you use the ID#.SG#@# referencing format. -Use the ID#.SG#@# referencing format when referencing studies, and use the traditional column/row referencing format for all other columns/cells. With the Number of Formula Columns set to 60, this allows the flexibility to insert/delete columns because references will automatically follow. The only thing you have to manually change is the respective Draw Styles. Caution: if you have formulas in the 60th column, and then insert a column, those formulas will be overwritten by a study output. Leave spare columns to the right of your working columns. -Do not use columns beyond those used by studies. If you add a study, your formulas will be overwritten. Instead, add an unassociated sheet. Date Time Of Last Edit: 2016-11-13 18:14:06
|