Login Page - Create Account

Support Board


Date/Time: Sat, 11 May 2024 22:35:04 +0000



Automated spreadsheet system error: Target/Stops NoMatch

View Count: 656

[2017-03-21 19:06:09]
User0123 - Posts: 36
Hi,
I put together an automated spreadsheet trading system and have successfully tested it in one product, but am having execution problems in another product. I wrote the spreadsheet the same way as I had in the prior version, and set up some attached orders for execution, using an attached trade window. The quantity is set to 6 contracts and I have matched targets and stops on the other side. When I enter an order manually via the trading chart DOM everything fills in just the way it should, but when a the spreadsheet system triggers an entry, the quantity entered changes to 1 and cancels itself because 1 no longer matches the 6 targets/stops on the other side.

I have reset all the spreadsheet settings, rewritten the spreadsheet entirely, and tested the attached orders from the trade window manually and everything seems to be in order... until an automated signal is generated, and the quantity entered once again inexplicably drops to 1 and cancels itself.

The message on the Trade Service Log reads: "Trade Order Error: The order quantity for the Parent is 1 and this is less than the total order quantity of 6 for the Attached Orders. Adjust the order quantities so the parent is greater or equal to the Attached Orders."

Any help in resolving this issue is VERY much appreciated.

Thank you
Date Time Of Last Edit: 2017-03-21 19:28:14
[2017-03-21 20:45:41]
Sierra Chart Engineering - Posts: 104368
The order quantity is controlled through this Sheet cell:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#CellJ26

You will need to set it to 6.
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:

Login

Login Page - Create Account