Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 14:53:29 +0000



Spreadsheet System for Trading - Static Columns

View Count: 941

[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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account