Login Page - Create Account

Support Board


Date/Time: Tue, 16 Sep 2025 19:09:45 +0000



Place A Trade At The Last Bar

View Count: 670

[2020-07-23 15:27:20]
User483852 - Posts: 19
Hello,

I built a spreadsheet trading system with a buy and sell entry price as per the attached screenshot.
The system is supposed to place buy / sell stop limit order at the price in column K / M. But, when I run the system, it just places a trade at market even when I change the type of entry to "Stop Limit" in the Trade Window. Could you please advise on how I can make the spreadsheet system place a buy / sell stop limit trade at the specified price in the spreadsheet.

Thanks and Regards,
R
imageAMP Question.JPG / V - Attached On 2020-07-23 15:24:21 UTC - Size: 142.9 KB - 282 views
[2020-07-23 16:30:51]
Sawtooth - Posts: 4263
Cells K/M are the T/F signals. They are boolean: any non-zero is TRUE, and zero is FALSE.

You set the Stop Limit prices in J22/J24.

You set the order types in J71/J73.

Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices (read/write) [[v1:J22,v2:J78], [v1:J23,v2:J79], [v1:J24,v2:J80], [v1:J25,v2:J81]
Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type (read/write) [v1:J71, v2:J73]
Date Time Of Last Edit: 2020-07-23 16:32:36
[2020-07-23 19:19:55]
Sierra Chart Engineering - Posts: 104368
Yes you need to set the order type and price, if necessary, on the corresponding spreadsheet cells:
Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type (read/write) [v1:J71, v2:J73]
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: 2020-07-23 19:21:36

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account