Support Board
Date/Time: Fri, 31 Jan 2025 03:12:15 +0000
[Programming Help] - Using Spreadsheet System for Trading Study
View Count: 789
| [2019-04-01 16:40:55] |
| User94606 - Posts: 327 |
|
I am currently using the Spreadsheet System for Trading study for "entries" only. I am manually closing the entries and noticed that as soon as my closing orders are executed, the Spreadsheet System for Trading executes a new buy/sell entry immediately. If am closing the entries manually, is there a way to automatically disable executing a new entry by the Spreadsheet System for Trading? |
| [2019-04-02 09:39:19] |
| |
|
You can control that with this particular cell: Spreadsheet Systems, Alerts and Automated Trading: Disable Auto Trading [J28] 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 |
| [2019-04-02 10:36:02] |
| User94606 - Posts: 327 |
|
I am currently using cellJ28 to disable autotrading for specific thresholds such as max loss and do not want to override it. Is there another approach available only for manual exists to disable autotrading?
|
| [2019-04-04 01:08:00] |
| User94606 - Posts: 327 |
|
Any updates on my follow up question?
|
| [2019-04-04 09:30:56] |
| TechTrader - Posts: 116 |
|
User 94606 Could be that cells K3 and M3 are maintaining true causing an immediate buy/sell on manually exiting existing position. Modifying formulas to be true only on one bar/cell could possibly solve the issue. |
| [2019-04-04 16:44:15] |
| User94606 - Posts: 327 |
|
You are right. How do you modify the formula so it is only true for one bar only?
|
| [2019-04-04 17:21:10] |
| TechTrader - Posts: 116 |
|
User 94606 Following is a simple example. Say you have two lines in columns P and Q. Buy entries when P crosses Q to the upside. Sell entries when P crosses Q to the downside. K3 Formula: =IF(AND(P4<=Q4,P3>Q3),1,0) M3 Formula: =IF(AND(P4>=Q4,P3<Q3),1,0) |
| [2019-04-04 23:11:17] |
| User94606 - Posts: 327 |
|
Thanks. I don't see with the example provided that this will only be true for one bar only? For the buy entry example, as long as previous (P4 <= Q4) and the current (p3 > q3), it will continue to be true - wouldn't it? Or am I missing something?
|
| [2019-04-05 00:05:40] |
| TechTrader - Posts: 116 |
|
User 94606 No, because the spreadsheet rows step down with the start of every new bar. So the formulas are only true if row 4 is not true and row 3 is true. The formula prints 1(true). The next bar causes row 4 to be true but row 3 is not true in relation to row 4 so the formula prints 0(not true). The rows will continue to print 0 until the true condition occurs again. ie row 4 not true, row 3 true. SC has extensive documentation on spreadsheets and lists many formula examples. |
| [2019-04-05 05:34:55] |
| User94606 - Posts: 327 |
|
Thanks. I need to review this over the weekend
|
To post a message in this thread, you need to log in with your Sierra Chart account: