Support Board
Date/Time: Wed, 21 Jan 2026 11:08:54 +0000
What is the compelling reason for the spreadsheet studies Version 2?
View Count: 220
| [2025-12-06 18:17:42] |
| Sawtooth - Posts: 4309 |
|
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: 22470 |
|
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: 4309 |
|
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: 175 |
|
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: 22470 |
|
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: 4309 |
|
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 - 24 views |
To post a message in this thread, you need to log in with your Sierra Chart account: