Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 08:51:45 +0000



Adding more formula columns to a ---Spreadsheet System/Alert--- study

View Count: 1438

[2014-04-19 23:25:50]
moonmist - Posts: 127
Hi,

Few months ago, I created a "Spreadsheet System/Alert" study to mark some special bars. At that time, I thought 16 formula columns is more than enough. Now, I need more than that.

Can I just select setting and increase the number of formula columns of the old spreadsheet from 16 to 25 ?


Thanks.




[2014-04-19 23:42:29]
Sierra Chart Engineering - Posts: 104368
Yes you can but you need to be aware that the starting column for the studies outputted to the Spreadsheet will be shifted further to the right to allow room for the additional 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
[2014-04-20 00:54:24]
Sawtooth - Posts: 4120
If you change the Number Of Formula columns, all formulas referencing formula columns will need to be edited.
[2014-04-20 00:58:24]
Sierra Chart Engineering - Posts: 104368
all formulas referencing formula columns will need to be edited.
Can you give an example of why this would be the case.

We would expect only the formulas referencing the study data columns beginning at the previous AA column would need to be edited, since the new formula columns are to the right of the existing unchanging 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
Date Time Of Last Edit: 2014-04-20 00:58:42
[2014-04-20 01:17:05]
Sawtooth - Posts: 4120
I should have said 'all existing formulas referencing Formula Columns will need to be edited.
Formula references do not follow the insertion of new columns.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account