Support Board
Date/Time: Sat, 10 May 2025 17:14:30 +0000
Spreadsheet System for Trading - Static Columns
View Count: 942
| [2016-02-13 11:05:38] |
| User553714 - Posts: 184 |
|
Hi, I am finding Column-H very useful as it is a static (read/write) column (dose not recalculate and keeps user defined values/formula) and was wondering if there is anyway to add a 2nd static column beside this I.E to have two static columns side-by-side to allow me to set my own Settings Labels/Values similar to the Spreadsheet System for Trading Study Settings Labels/Values defined in columns J&K (which are not static). I tried inserting a column before Column "I" but when the sheet re-calculated it re-inserted the labels of the old Column "I" into the new column "I" so I was left with the single static column "H". If there is a way to insert a NEW static column can the same be done to insert a new static Row - say Row-2 to become static also? REgards |
| [2016-02-13 18:11:32] |
| |
|
You cannot insert Columns or Rows like this. You just need to use an available column towards the right side of the Sheet after the studies. Obviously there are a huge number of them available. 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 Date Time Of Last Edit: 2016-02-13 22:57:41
|
| [2016-02-13 18:22:41] |
| Sawtooth - Posts: 4214 |
|
Cells E1:Z1...BR1 (depending on the Number of Formula Columns setting) are static cells also. Columns to the right of the study output columns are static, but if you add a study, they will be overwritten. |
To post a message in this thread, you need to log in with your Sierra Chart account: