Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 21:05:57 +0000

How to Post a Message for Support

Post From: Formula plot-subchart study

[2016-11-13 14:21:12] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
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