Support Board
Date/Time: Sun, 22 Dec 2024 16:40:42 +0000
Additional formula columns in existing spreadsheet
View Count: 1481
| [2015-08-13 14:04:13] |
| User911705 - Posts: 89 |
|
Hello, Given an existing spreadsheet (new style), is there a way to add additional formula columns to the spreadsheet such that the existing formulas and columns don't get messed up? Can I just use existing columns starting after the study columns? Thanks. |
| [2015-08-13 14:37:08] |
| Sawtooth - Posts: 4141 |
|
Given an existing spreadsheet (new style), is there a way to add additional formula columns to the spreadsheet such that the existing formulas and columns don't get messed up?
Unfortunately, no. If you had used the ID#.SG# reference (instead of a column reference) when the spreadsheet was first built, you could increase the Number of Formula Columns and the references would be retained, but this assumes you didn't delete that study and add another that took the same ID#. http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy Can I just use existing columns starting after the study columns?
You can only use columns to the right of the study output columns as non-repeating cells; they won't autofill below. And if you add any study, it's output appears in those columns.
|
| [2015-08-13 15:11:19] |
| User911705 - Posts: 89 |
|
Thank you Tom! Helps a lot. Actually, knowing I can using the columns/cells to the right of the studies as non repeating might do the trick for me. I'm creating a position sizing formula based on the stop offset for attached orders, and the fact that the offset is right only is making me have to duplicate that formula and the formulas are getting sort of bloated, if you know what I mean:) |
| [2015-08-13 18:42:57] |
| |
|
For the first post, you need to use this cell referencing method: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy To avoid any problems when using more formula columns. 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: