Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 09:16:09 +0000



Shifting spreadsheet columns when adding studyt to spreadsheet trading system

View Count: 869

[2014-10-26 17:08:25]
dimeetrees - Posts: 27
How do I preserve my formulas to work if I want to add more studys to the spreadsheet system without having the original columns shift one way or another?
[2014-10-26 18:21:30]
Sawtooth - Posts: 3992
These are the workarounds:

1) Use the New Spreadsheets version so you can use the new ID#.SG#@# format:
New Non-CLR Spreadsheet Study Study Reference Method | Post: 40080

2) Do not remove a study (Hide it if necessary), do not rearrange the order of the studies in the Studies to Graph list, and always add new studies to the bottom of the list.

3) Always change the default setting of the Number of Formula Columns from 16 to the maximum of 60, before you write any formulas.
[2014-10-28 04:00:01]
Sierra Chart Engineering - Posts: 104368
1. If you are using New Spreadsheets, then refer to this video for a new study referencing method:
https://www.sierrachart.com/Videos/New%20Spreadsheets.wmv

Tom did indicate this above.
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:

Login

Login Page - Create Account