Support Board
Date/Time: Sun, 26 Apr 2026 11:34:02 +0000
What is the compelling reason for the spreadsheet studies Version 2?
View Count: 406
| [2025-12-06 18:17:42] |
| Sawtooth - Posts: 4328 |
|
Recently an option was added to all three spreadsheet study's study settings: 'Use Column I and J Values Version 2 (ln:73)' When this option is set to Yes, all Column I and J cell titles and their functions are rearranged. Some v1 items are eliminated, and new items are added. The v2 rearrangement seems unnecessary and problematic because: 1. New items could simply be added to v1. - Removed items are referenced by existing user formulas. - Converting existing builds from v1 to v2 would be tedious. 2. Support requests would increase. - Support and v1 users will need to transliterate to offer help. - Third party websites and forum post examples will no longer be accurate. 3. Documentation becomes difficult. - Example: Spreadsheet Systems, Alerts and Automated Trading: Special Spreadsheet Outputted Values | Read-Only or Read/Write - The above is in v2 order, not in the legacy v1 order. It seems 'organized in a more logical and updated format' is an insufficient reason by itself, given the downside. https://www.phrases.org.uk/meanings/if-it-aint-broke-dont-fix-it.html |
| [2025-12-06 21:22:37] |
| Sierra_Chart Engineering - Posts: 23605 |
|
This is an argumentative post, and we take an exceptionally strong position against not making changes to keep Sierra Chart well organized and clean. If we are following this kind nonsense philosophy of not making improvements, with organization and cleanliness and always working to improve the code base, with performance and organize it better, Sierra Chart gradually would become a mess. We are not going to allow that under any circumstances. Version 2 is well-organized, and all of the fields are included across, all three versions of the Spreadsheet study, unless ones that are trading Inputs and are provided only for the Trading version of the spreadsheet study. This is final and we do not want to hear anything further about it. It is left as an option and we do apologize for the cases where it was inadvertently enabled. This has long been solved by now. And we do not believe in the ain't broke don't fix it mentality. That is a terrible mentality especially in the realm of software engineering. Most software in the world, is very substandard. We are going to be the best, and excel at what we do. And make real improvements and add new features, not just adding, layers upon layers, of messy disorganized code. We will always be clean and efficient and organized. Adding this link: https://hemaks.org/posts/the-fallacy-of-if-it-aint-broke-dont-fix-it-the-case-for-constant-refactoring/ 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-12-06 23:27:08
|
| [2025-12-07 00:57:43] |
| Sawtooth - Posts: 4328 |
|
Sorry, not meant to be argumentative. Would you be willing to add the new items to v1? |
| [2025-12-07 19:26:08] |
| User708541 - Posts: 182 |
|
I'm only asking and not trying to add any tension. When I go to Studies and add a spreadsheet study, there is only one choice and therefore one version. I never knew about multiple versions of this study as there seems to only be one choice. How do we know what version of the Spreadsheet we are using? Can a 'version 1' spreadsheet be easily upgraded to the latest version? Would there be a reason to do this? |
| [2025-12-07 19:30:42] |
| Sierra_Chart Engineering - Posts: 23605 |
|
One thing that we can do and we will make a note of this, is we can add a command, which updates the I and J columns to version 2 and sets the Input with the Spreadsheet study to use version 2, and preserves all of the values and then update all of the References in the Sheet to the new corresponding rows. We just need to establish, the mapping between the two versions. We can programmatically do that. All of this is technically possible. Yes we can do that: Would you be willing to add the new items to v1? Give us some time, to work on all of this. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-12-07 19:32:05
|
| [2025-12-08 00:21:25] |
| Sawtooth - Posts: 4328 |
|
Would there be a reason to [upgrade to v2]?
If the new outputs are added to v1, the only reason to use v2 would be the more logical ordering of the outputs.See attached .xlxs for the list of spreadsheet v1 and v2 outputs in v2813, in row order. All of the links to the documentation have been retained. Date Time Of Last Edit: 2025-12-08 00:25:34
|
 Spreadsheet v1 v2 outputs v2813.xlsx - Attached On 2025-12-08 00:20:32 UTC - Size: 20.95 KB - 122 views |
| [2026-04-01 20:03:27] |
| Sierra_Chart Engineering - Posts: 23605 |
|
In the latest release of Sierra Chart, there is now support for all of the version 2 I and J rows, when not using version 2 for the I and J rows.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-04-06 22:31:38] |
| Sawtooth - Posts: 4328 |
|
In the latest release of Sierra Chart, there is now support for all of the version 2 I and J rows, when not using version 2 for the I and J rows.
In the Spreadsheet System for Trading study, v2891 v1 and v2 match, except for v1's J36-J39 and v2's J201-J225.In both the Spreadsheet Study study, and the Spreadsheet System/Alert study, v2891 has many Spreadsheet System for Trading study outputs in v2. Some of these outputs are from settings that don't appear in those studies. Is this intended? (Those outputs don't appear in v1.) See attached for v1/v2 comparisons of all three spreadsheet studies in v2891. Date Time Of Last Edit: 2026-04-06 23:32:28
|
| Spreadsheet v1 v2 outputs v2891.xlsx - Attached On 2026-04-06 22:30:12 UTC - Size: 68.98 KB - 17 views |
| [2026-04-08 23:19:09] |
| Sierra_Chart Engineering - Posts: 23605 |
|
We are not understanding the purpose of the last post? There are going to be differences between version 1 and version 2. Version 2 is better organized and there are some changes when it comes to bar period types. Other changes as well. For the TPO Chart Values you can control the starting row with a new Spreadsheet Study input. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2026-04-08 23:20:41
|
| [2026-04-08 23:35:07] |
| Sawtooth - Posts: 4328 |
|
We are not understanding the purpose of the last post
I just wanted to point out that in v2 the Spreadsheet Study study, and the Spreadsheet System/Alert study, have outputs from settings that those studies don't have.And that those outputs are from the Spreadsheet System for Trading study. Date Time Of Last Edit: 2026-04-08 23:35:38
|
To post a message in this thread, you need to log in with your Sierra Chart account: