Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 13:35:43 +0000



Buy Exit not Triggering Fills

View Count: 1735

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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

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: 9
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:

Login

Login Page - Create Account