Support Board
Date/Time: Sun, 02 Feb 2025 19:48:39 +0000
Buy Exit not Triggering Fills
View Count: 2037
| [2018-05-08 15:38:33] |
| User172040 - Posts: 70 |
|
I know SC does not accommodate specific formula questions. I'm merely asking a general one. I'm coding my Buy Exit in the spreadsheet study and I'm using the documented examples from here - Spreadsheet Systems, Alerts and Automated Trading: Multiple Exit Automated Trading Example and here - Spreadsheet Systems, Alerts and Automated Trading: Buy Exit (column L) All I want to do is to trade 2 contracts (J26 Formula). If price = avg price + 20 points take off 1 contract. If price = avg price + 40 points take off the last contract. If price = avg price -10 points exit or if closing price on row 3 is smaller than low of row 6 then exit or if 5MA cross 9MA from above, then exit. Problem is, when I backtest and 'Use attached orders' are disabled (so L column will be used for exits) then I get no actual fills on the backtest. But I also get no kind of error on any of these formulas. When I clear L column (no formulas) and tick 'Use attached orders' I get my fills and exits in the backtest. Why would I not get fills on the backtest when entering buy exit criteria? Below the basic formula I'm using J26 (Order Quantity): =IF( ABS(J8) = 2, 1, IF( ABS(J8) = 1, 1, 0)) L3: =OR(AND($J$8 = 2, ID0.SG4@$3 - $J$9 > 20, AND($J$8 = 1, ID0.SG4@$3 - $J$9 > 40), OR(ID0.SG4@$3 <= $J$9-10, ID0.SG4@3 < ID0.SG3@6, CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID3.SG2@3:ID3.SG2@4)))) |
| [2018-05-08 18:40:46] |
| |
|
This is a general question? It is a very detailed question which would require comprehensive analysis and testing on our part. This is not within the scope of our support. Understand there simply is no way we can get involved in these at all. This would have to be for an additional cost and as of yet, we do not offer that service. This is explained in detail here: http://www.sierrachart.com/index.php?page=doc/AutoTradeManagment.php#TroubleshootingAutoTradingSystemBehavior Refer to: http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#IgnoredSignalsWithSpreadsheetSystemsOrAlerts 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: 2018-05-08 19:01:04
|
| [2018-05-08 19:38:48] |
| User172040 - Posts: 70 |
|
😁 Look, I'm a SC convert. I wont go anywhere. SC is phenomenal software. But 1 area you lack is proper coding support. For non coders to learn, there need to be more support. Support does not mean having to look at every users code base. But more real life examples of code options will go a far way. Videos of best practice will also help immensely. I think there's a nr of non coders who would love to learn and utilize the power of SC fully. If you have a Ferrari in your hands, you're not doing that vehicle a favor by driving in 2nd gear all the time. If you trade on SC but not making use of ASCILL / Spreadsheets, then we drive in 2nd gear. Let your customers come to appreciate the true value of SC. Make effort with code support and code training. You'll have clients for life!! I'm one anyway. |
| [2018-05-08 19:52:18] |
| |
|
Providing free programming help has been looked at many times, and it is not practical for us to get involved in this. We hope to offer a separate paid service for this. And offer that at a low cost like 35 USD per hour. The only fear though is whether the person helping is less skilled than the person asking the questions. Then we are just looking like a bunch idiots from our side. And also, sometimes and often it is easiest that a user just expresses in plain English what they want to do and we then create that, rather than try to figure out and correct what a user has already done. Anyway getting back to the first post, does the formula even return true? That is the first thing to look at and also look at the formula expression tree: http://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ViewingFormulaExpressionTree 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: 2018-05-08 19:54:24
|
| [2018-05-08 19:56:10] |
| |
|
But more real life examples of code options will go a far way. Videos of best practice will also help immensely. Yes we agree, and that is the intent of this page:http://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php And really videos are hard to maintain. It is best for us to use static images with supporting text. 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: 2018-05-08 19:56:38
|
| [2018-05-09 04:01:54] |
| User172040 - Posts: 70 |
|
Yes we agree, and that is the intent of this page:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php I get that and I'm making use of that page. But that is not enough. We need more examples. I think the link quoted above should be expanded continuously with new examples. If you look at MT5, they have 1000's of code examples. It helps the user to see what others did and to apply it to their own code / formulae. I'll step off this topic now. |
| [2019-10-03 11:14:06] |
| User814318 - Posts: 11 |
|
Dear @OP and anyone else stumbling on this topic of buy-sell exits of spreadsheet study not triggering, please take a look at: Spreadsheet Systems, Alerts and Automated Trading: System/Alerts and Draw Style Spreadsheet Systems, Alerts and Automated Trading: Buy/Sell Arrows Do Not Mean Trade Signals For me the solution was 1. Setting draw style to up/down arrows for study columns L and N 2. Turning off "Use Attached Orders" Date Time Of Last Edit: 2019-10-03 11:18:15
|
To post a message in this thread, you need to log in with your Sierra Chart account: