Home >> Support Board

Support Board

Date/Time: Sat, 16 Aug 2025 13:50:45 +0000

How to Post a Message for Support

SC2782 Spreadsheet System for Trading Buy/Sell Entry/Exit columns are deleted

View Count: 57

[2025-08-14 14:08:48] #1 [Go To First Post]
User512353 - Posts: 95
SC2782 Chart has 'Spreadsheet System for Trading" study with a spreadsheet loaded. The spreadsheet has been explicitly saved with formulas in the 'Buy Entry", 'Buy Exit", 'Sell Entry', 'Sell Exit' columns. Under the following conditions the formulas in these columns are deleted: 1. [Menu] Trade >> Clear Trade Simulation Orders & Data 2. [Menu] Trade >> Auto Trading Enabled - Global (goes from enabled to disabled) Is that the expected behavior?

[2025-08-14 14:19:12] #2 [Go To First Post]
User512353 - Posts: 95
Deletion also occurs when certain settings in the 'Spreadsheet System for Trading" study are changed. Not sure if this applies to all settings.

[2025-08-14 15:37:45] #3 [Go To First Post]
Sierra_Chart Engineering - Posts: 20642
There must be some explanation of the issue in your case. Neither of those could be causing the problem. This is not technically possible. The most likely explanation is that those are triggering a full recalculation. That by itself is not the problem. Usually the reason for this issue is explained here: Spreadsheet Study Inputs: Formulas Getting Erased 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

[2025-08-15 13:13:53] #4 [Go To First Post]
User512353 - Posts: 95
Needs more investigation, but the problem seems to be: The chartbook has several charts which use Chart >> Chart Settings >> Linking >> Studies = Yes on the same Link Number. This causes all 'Spreadsheet System For Trading' studies in these charts to be forced to the same 'Formula Source Sheet Number" setting. This is not good. Is there any way to circumvent this? Linking the studies is pretty much essential for these charts, but the spreadsheet table content should remain independent.

[2025-08-15 13:54:49] #5 [Go To First Post]
Sierra_Chart Engineering - Posts: 20642
Yes this does make sense and that is the problem: This causes all 'Spreadsheet System For Trading' studies in these charts to be forced to the same 'Formula Source Sheet Number" setting. There is no way around this. You need to not use Study Linking. 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-08-15 13:55:21

[2025-08-15 15:12:17] #6 [Go To First Post]
User512353 - Posts: 95
I want to request an enhancement that would solve this problem: In the settings for 'Spreadsheet System For Trading' study, allow the study setting for 'Formula Source Sheet Number' to be empty, i.e. not copying anything from any other sheet on spreadsheet updates.

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