Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 19:15:50 +0000

How to Post a Message for Support

[Programming Help] - Disable Spreadsheet Trading

View Count: 1639

[2017-10-26 01:54:43] #1 [Go To First Post]
User104854 - Posts: 441
I just put together a simple spreadsheet to automate my exits. I do not see how I can enable or disable the spreadsheet as sometimes I want it active and other times not. I know it can be programmed to be active at certain times and all that but I just simply want to manually disable and enable it. Please advise on how to do this. Thank you.

[2017-10-26 20:09:50] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Here is the documentation for this: Spreadsheet Systems, Alerts and Automated Trading: Halting Order Entry You basically will want to use the Trade >> Auto Trading Enabled commands. 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 Date Time Of Last Edit: 2017-10-26 20:10:21

[2017-10-26 22:19:01] #3 [Go To First Post]
User104854 - Posts: 441
Ok. Thank you for the reply. If I disable auto trading will that affect attached orders or the 'trade management by study' study?

[2017-10-26 22:53:26] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
It will not affect Attached Orders but it will stop trading from the Trade Management by Study study. But what you can do is use Trade >> Auto Trading Enabled - Chart to disable automated trading for an individual chart. In this case, trading related studies in other charts will not be affected. We will update the documentation about 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, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2019-02-11 22:41:21

[2017-10-26 23:35:24] #5 [Go To First Post]
Sawtooth - Posts: 3976
You can also use cell J28. Enter a 1 and the autotrading will be disabled for the respective chart. You can also reference a more convenient cell: Enter 1 in cell H1. Enter =H1 in cell J28.

[2017-10-27 05:26:46] #6 [Go To First Post]
User104854 - Posts: 441
Perfect. Thanks a lot Tom.

[2019-02-10 04:32:59] #7 [Go To First Post]
User917679 - Posts: 76
Is there a way to disable/enable 'trade management by study' through the spreadsheet study? Date Time Of Last Edit: 2019-02-10 04:33:14

[2019-02-10 04:54:14] #8 [Go To First Post]
Sawtooth - Posts: 3976
Is there a way to disable/enable 'trade management by study' through the spreadsheet study? Not directly, but if the formula it references returns a zero, the Trade Management by Study will do nothing.

[2019-02-10 14:28:35] #9 [Go To First Post]
User917679 - Posts: 76
Is it possible to change the subgraph input that is referenced by TMbS through spreadsheet? In other words, can you change TMbS' (In:3) via spreadsheet?

[2019-02-10 16:29:59] #10 [Go To First Post]
Sawtooth - Posts: 3976
can you change TMbS' (In:3) via spreadsheet? No, but you can use multiple instances of the Trade Management by Study study, that each reference a different subgraph.

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