Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 21:55:37 +0000

How to Post a Message for Support

limit orders on SST not place it at desired level at certain conditions

View Count: 490

[2024-02-08 19:46:07] #1 [Go To First Post]
User555185 - Posts: 8
Hello Support I am trying to create a spreadsheet auto trading system but the entry order is not the one specified by the formula and value that I have on J22. for example I am using the Gann hi-lo activator on AD and when this one indicates a turn (k3=1), I want a limit order indicated by j22 2 ticks above the previous reading (AD4+(2$j$21)), it works great when the close is below AD4, so when price reaches the order, it buys the order, BUT, if price closed above the previous activator (AD4), let's say it closed 5 ticks above the previous activator, which is higher than the level (AD4+(2$j$21)) it places the order at that last close level and I will prefer to be placed exactly 2 ticks above the previous reading and get activated if price comes back. going through the documentation I found this is worked around with buy triggered limit orders, how can they be applied to the spread sheet auto trading? or if there is another turn around or value/formula in another cell I am missing out, will you please tell me how to do it or point me in the right direction?

[2024-02-08 19:51:18] #2 [Go To First Post]
John - SC Support - Posts: 31704
From what you are stating, it sounds like you would need to use a "Stop-Limit" rather than a Limit. Refer to the following: Order Types: Stop-Limit For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-02-09 20:29:28] #3 [Go To First Post]
User555185 - Posts: 8
Thank you for the response, indeed Stop-limit was the first option. So the question will be: How can a stop limit order be placed below the last trade price on the spread sheet system for trading? As mentioned before, when the close is below where the price that is suppose to be set at the stop limit once the signal is triggered, it works find, but when the signal is triggered, and Close is above the desired price for the stop limit, order is triggered at the market price and receive the next error: Buy stop must be at or above last trade price but I am specifying that it should be in a level that sometimes will be below the last trade price. Below you will find 3 examples, also with screens of the cells at which the stop limit bust be places and the type of order, in the first two images are showing the behavior on entry ant a not desired entry price and the third one show that it works perfectly when last price is below the desired entry price price. Cell J71, it is set to: SL https://www.sierrachart.com/image.php?Image=1707508709597.png https://www.sierrachart.com/image.php?Image=1707509369186.png https://www.sierrachart.com/image.php?Image=1707509667252.png I have also went to global settings> chart trade settings> General> Reject stop orders that will immediately Fill set to YES and it did not make a difference. Also, noticed that when stop limit is triggered is buying a random number of contracts which is not desired. How can it be set up on the spread sheet system for trading to just buy/sell a specific number of contracts? Maximum position allowed is set to 1 for the moment and you can see that the order bought 4. https://www.sierrachart.com/image.php?Image=1707510076270.png


SL-1.jpg / V - Attached On 2024-02-09 19:50:00 UTC - Size: 99.42 KB - 40 views SL-2.jpg / V - Attached On 2024-02-09 19:50:07 UTC - Size: 158.2 KB - 38 views SL-3.jpg / V - Attached On 2024-02-09 19:50:13 UTC - Size: 60.5 KB - 39 views

[2024-02-09 21:13:35] #4 [Go To First Post]
John - SC Support - Posts: 31704
On the Trade Window for the chart that is associated with the spreadsheet, there are options in the "Set" tab for "Stop-Limit Order Limit Offset". Make sure this is set how you want. It sounds like you want these to be 0. We are not sure we are following the situation. But here are the things to keep in mind. If you are wanting to place a working order at a price that is in your favor (e.g. a Buy order at a price less than the current market price) then you would enter a Limit order. If you are wanting to place a working order at a price that is not in your favor (e.g. a Buy order at a price higher than the current market price) then you would enter a Stop-Limit. It sounds like you may need to change your order type depending on where exactly you are wanting to place the trade. You can set the Order Type in cell J71 using a condition like the following: =IF($E$3 > 1800.00, "L", "SL") For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-02-16 00:24:52] #5 [Go To First Post]
User555185 - Posts: 8
John: Thank you very much! both the suggestions about the offset and idea to place a formula for both Limit and SL , worked wonderful! Just as general Knowledge, why it is necessary to adjust the offset on the trade window , since not using attached orders for the spread sheet?

[2024-02-16 14:24:22] #6 [Go To First Post]
John - SC Support - Posts: 31704
There are two offsets in that section, one for "Primary Orders" and one for "Attached Orders". You would be changing it for the "Primary Orders", which are the non-attached orders. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-05 10:32:42] #7 [Go To First Post]
rahul.pitty - Posts: 13
HOW TO PLACE ORDER AT SPECIFIED PRICE ONLY. I HAVE TRIED USING STOP LIMIT WITH OFFSETS SET AT 0. BUT THEN ALSO IT IS NOT PLACING ORDER AT CORRECT PRICE IT IS PLACING AT PRICE ABOVE IT. I WANT MY ORDER TO PLACED AT EXACT THAT PRICE. BASICALLY I WANT LIMIT ORDER TO BE PLACED AT EXACTLY TO THE VALUE WHICH IS IN W3 CELL Date Time Of Last Edit: 2024-04-05 11:23:38

[2024-04-05 15:10:03] #8 [Go To First Post]
John - SC Support - Posts: 31704
Is this a Primary order or an Attached order? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-08 05:52:02] #9 [Go To First Post]
rahul.pitty - Posts: 13
Its a primary order

[2024-04-08 15:55:35] #10 [Go To First Post]
John - SC Support - Posts: 31704
How are you entering this order? Are you using a Spreadsheet System for Trading or are you using something else? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-09 06:45:52] #11 [Go To First Post]
rahul.pitty - Posts: 13
Yes, I am using spreadsheet system for trading.

[2024-04-09 14:27:17] #12 [Go To First Post]
John - SC Support - Posts: 31704
From what you are stating, you should be able to set the following in the spreadsheet (note that the cell references are for Version 1 of the I/J columns, so these may not match your locations, but look for the same naming): - J22 (Limit or Stop Price - Buy Entry (K): Enter the price point where you want the Stop Limit to be located. - J71 (Buy Entry: Order Type, M=Market...): SL Then when your "Buy Entry" is activated the order will be set as a "Stop Limit" at the price defined in cell J22. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-09 15:30:44] #13 [Go To First Post]
rahul.pitty - Posts: 13
I exactly did that. But the thing is it sometimes places limit order on price higher than the price in J22. Also some times lower. Making it clear that j22 cell derives its value from w3 cell.

[2024-04-09 18:21:13] #14 [Go To First Post]
John - SC Support - Posts: 31704
Please do a very simple test. Enter a price in cell J22 that is a reasonable amount away from the current price, something that will not be touched by normal price movement. Then enter a "1" in the "Buy Entry" (K3) cell. It should put a Stop Limit at the price point you had defined in J22. Let us know what you get. If it is not at the correct price then we need an image showing the Stop Limit on the chart at the wrong price and what price you had entered in J22. Follow these instructions to get us an image: Support Board Posting Information: Attaching or Posting a Screenshot/Image (Optional) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-11 08:44:01] #16 [Go To First Post]
rahul.pitty - Posts: 13
I did that using limit order and it worked fine. But that is not the case when I am deriving the limit price value from a formula or maybe near to the current price. https://www.sierrachart.com/image.php?Image=1712827150358.png https://www.sierrachart.com/image.php?Image=1712827250290.png Humbly request you to help me solve the issue on priority. Date Time Of Last Edit: 2024-04-11 09:24:47

[2024-04-11 11:24:36] #17 [Go To First Post]
rahul.pitty - Posts: 13
https://www.sierrachart.com/image.php?Image=1712834384128.png https://www.sierrachart.com/image.php?Image=1712834426275.png https://www.sierrachart.com/image.php?Image=1712834632843.png this is the example of simple limit order placed through spreadsheet which got filled at wrong price.

[2024-04-11 15:04:30] #18 [Go To First Post]
John - SC Support - Posts: 31704
Is the issue where the Limit is being placed to begin with, or is it the price at which it fills? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-12 05:58:04] #19 [Go To First Post]
rahul.pitty - Posts: 13
it is entering limit order at wrong price so I am not getting fills at desired price. Date Time Of Last Edit: 2024-04-12 12:37:21

[2024-04-12 14:11:15] #20 [Go To First Post]
John - SC Support - Posts: 31704
Given the test that you already did previously in which you verified that the Limit order is being placed at the appropriate level when you enter a certain value in the J22. We have to believe that what you are seeing is simply a change in the price of the cell after the order has been placed. That is, the price is correct in cell J22 when the order is put in, but then when you look at it in the spreadsheet it has already changed to some other value, which makes you think it was not put in correctly. But in reality, it was put in at the price that was specified at that time. One thing you can do to verify is to run a replay and pause it just before a point where you know the order will be entered. Then step forward in 1 trade increments to where the order is put in and see what the values are. The price at which the Limit order is being entered will match what is in cell J22 at that moment. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-12 14:28:36] #21 [Go To First Post]
rahul.pitty - Posts: 13
I think that is not the case even if I am keeping the fixed price in J22 cell it is not placing order at the desired price.

[2024-04-12 15:21:28] #22 [Go To First Post]
John - SC Support - Posts: 31704
You stated the following when we asked you to do a test with a static value in cell J22: "I did that using limit order and it worked fine" If this is not working, then we would need to know what exactly you are seeing. Do not give us any other information other than when you have a static number in cell J22. What is the value you enter and what is the value of the order on the chart. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-14 08:03:16] #23 [Go To First Post]
rahul.pitty - Posts: 13
That was the case when price was far away from current price. I have also shared in before threads the screenshots of wrong placement of limit order when there is static price in J22 cell and I am manually entering buy entry/sell entry signal.

[2024-04-15 16:28:48] #24 [Go To First Post]
John - SC Support - Posts: 31704
It does not matter where the Limit order is placed in relation to the current price. We asked you to place it far away as a test so it would not get filled. The situations you are describing keep conflicting, so we are not able to figure out what is occurring. Please do the test again of placing a static value in cell J22 and place it anywhere you want. Then do whatever you need to do to generate a "Buy Entry" condition to place the order at J22. Then, please tell us the following: - Value of cell J22 - Price of Limit Order as it is entered on the chart. Not the filled price, the price that it is actually located at as soon as the Buy Entry generates an order. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-04-17 10:55:31] #25 [Go To First Post]
rahul.pitty - Posts: 13
https://www.sierrachart.com/image.php?Image=1713350136168.png https://www.sierrachart.com/image.php?Image=1713350165281.png https://www.sierrachart.com/image.php?Image=1713350215516.png Hope this makes everything clear. Static value in J22 cell is -24. Limit order is placed at -20.

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