Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 10:40:08 +0000



Slippage on Limit Order via Spreadsheet For Trading

View Count: 1512

[2015-06-12 18:04:22]
absorrel4 - Posts: 92
I set up the Spreadsheet for Trading and have my Trade Window attached to my chart. My Trade Window orders are to enter with a limit order and exit at the target via a limit order (or exit via a stop loss order at my stop level). I have the spreadsheet settings to only signal at the bar close with Strict Signal Only On Bar Close Evaluation. When the bar closes, my orders appear on the chart as expected. However, I desire to enter at the bar closing price (limit order)...but, I continually get filled with a 1 or 2 tick slippage...as if it were a Market Order. I double checked my Trade Window order configuration for the Limit Order and on the Set tab of the Trade Window I have the "Stop-Limit Order Limit Offset" set to 0.00 for the Primary Orders and the Attached Orders. How can I avoid the slippage and have the Limit Order placed only at the bar closing price?
[2015-06-12 19:09:30]
Sierra Chart Engineering - Posts: 104368
You cannot. The order will always be filled against the current bid and ask prices if it is capable of being filled according to the rules here:
http://www.sierrachart.com/index.php?page=doc/doc_TradeSimulation.php#HowOrdersAreFilled

This is just how it works and it cannot be changed.
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
[2015-06-12 19:12:13]
Sawtooth - Posts: 3993
With a formula, set a price in J22 & J24, and set J71 & J73 to 'L'

For close of bar, reference row 4 in J22 & J24.
[2015-06-12 19:19:08]
Sierra Chart Engineering - Posts: 104368
We may have misunderstood the first post. We assumed that the Spreadsheet Trading study itself is set up to submit a limit order but maybe not.

The information given in post #3 explains how to use a Limit order directly from the Spreadsheet.

But still what we said in post #2 is still valid when it comes to the filling of the orders.
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
[2015-06-12 21:35:57]
absorrel4 - Posts: 92
Will this always be the case (even when trading live) or is this approach only used by Sierra Chart when in trade simulation?
[2015-06-15 19:31:06]
Sierra Chart Engineering - Posts: 104368
In the case of live trading, the conditions which control the filling of orders is determined by the exchange.
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