Support Board
Date/Time: Thu, 09 Jan 2025 19:05:01 +0000
Error while spreadsheet backtesting
View Count: 808
| [2016-08-06 22:53:00] |
| User48942 - Posts: 9 |
|
Support Team, I am working on spreadsheet trading system. When I run the back test I get the below error. I have enabled "Use Attached Orders" to use OCO with 2 quantities. As soon as I run it goes back to 1. Trade Order Error: The order quantity for the Parent is 1 and this is less than the total order quantity of 2 for the Attached Orders. Adjust the order quantities so the parent is greater or equal to the Attached Orders. | 2016-08-06 18:44:49 * |
| [2016-08-07 00:23:56] |
| |
|
You need to set the order quantity that you want to use through this spreadsheet cell: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#CellJ26 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 |
| [2016-08-07 01:51:37] |
| User48942 - Posts: 9 |
|
I got it. How can I set in the code to take orders only during RTH hours ?? Thank you. |
| [2016-08-07 19:28:42] |
| |
|
Refer to this Spreadsheet cell: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#DisableAutoTrading 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 |
| [2016-08-07 19:55:31] |
| User48942 - Posts: 9 |
|
Thank you so much. One last thing if you could help. I have 3 EMAs on my chart. 8, 15 and 34. I was able to build auto trading when price crosses 8/15 above and below. I want to add one more parameter to the condition. i.e. when prices should be above 34 EMA. I tried using AND condition but was not successful. |
| [2016-08-08 00:57:01] |
| |
|
In what way were you not successful and what is the specific formula you are using?
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 |
| [2016-08-08 01:00:26] |
| User48942 - Posts: 9 |
|
My strategy is if 8ema crosses 15 ema from below and price is greater than 34 EMA go long and vice versa with sell side. Here is my formula I am trying in Spreadsheet trading. =AND(ID12.SG1@3>ID0.SG4@3,CROSSFROMBELOW(ID8.SG1@3:ID8.SG1@4,ID9.SG1@3:ID9.SG1@4)) |
| [2016-08-08 01:05:02] |
| |
|
The syntax/format of the formula is correct and should not give any error. Whether it has the intended result or not, is another question and that is for you to resolve.
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: 2016-08-08 01:09:21
|
| [2016-08-08 01:08:54] |
| User48942 - Posts: 9 |
|
No problem. Thank you so much for your support with all my questions. Could you point me to important documentation for spreadsheet automated tradings. Any links etc. |
| [2016-08-08 23:59:16] |
| |
|
The only relevant documentation is what we have here: https://www.sierrachart.com/index.php?page=doc/Spreadsheets.html https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#AutomatedTrading Is the formula not returning TRUE when you would expect it should be? 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: