Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 00:46:49 +0000



Shifting spreadsheet columns when adding studyt to spreadsheet trading system

View Count: 923

[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: 4120
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