Support Board
Date/Time: Wed, 27 Nov 2024 15:34:19 +0000
[User Discussion] - Auto Trade entry price
View Count: 1366
| [2014-09-15 00:51:26] |
| User11734 - Posts: 9 |
|
hi - I am using the spreadsheet auto-trade feature with rules for entry on cell K3 . I have all the signals working correctly, and the exact time when a trade should trigger, and it seems to work as expected. However, the entry price is always the close of the current or previous bar on the chart. I know the exact entry price and got it to show on a spreadsheet column (i would like it to be one tick above signal bar) but could not find documentation on how to set it. The only example that's available, is for a crossover of the EMA. How do I set it to trade a stop order one tick above a given signal bar? thank you!
|
| [2014-09-15 10:15:23] |
| |
|
This is not controllable. Refer to the documentation here for about how orders are filled during a replay. http://www.sierrachart.com/index.php?page=doc/doc_TradeSimulation.php#TradeSimulationBidAskPrices When an order is submitted, it will be filled based upon the most latest trade, bid and ask prices. 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: 2014-09-15 10:16:20
|
| [2014-09-15 13:17:59] |
| Sawtooth - Posts: 4120 |
|
You can use cells J22 and J24 to set a Stop Entry price, then set J71 and J73 to 'S'. Date Time Of Last Edit: 2014-09-15 13:34:33
|
| [2014-09-15 15:05:28] |
| User11734 - Posts: 9 |
|
tomgilb, i tried that idea with J22 and J71 - what do you out in J22? something like =K4 would work? (i can put the entry value in another column)
|
| [2014-09-15 15:46:57] |
| Sawtooth - Posts: 4120 |
|
Yes, =K4 would probably work. But since you only need one price value, you could put the formula directly in J22. Also, column J cells are not affected by a Yes setting of Signal Only On Bar Close, so if you want an intrabar trigger, reference row 3, and if you want a close-of-bar trigger, reference row 4. I like to use an IF statement, like this: =IF(conditions,C4+J21,0) that only offers a price when conditions are met. Date Time Of Last Edit: 2014-09-15 16:18:17
|
| [2014-09-21 00:07:33] |
| User11734 - Posts: 9 |
|
I've tried setting J22 to the value as suggested, but it seems like the fill values are almost randomly set.. I even see the all green arrows pointing correctly to the signal bar, but the fill is incorrect. To simplify, I tried a trivial K3=c3<c4 and J22=c4+0.25, just to see what it does with a simple example, and it seems to almost always pick the entry price at the close of the current bar. (this example calls for a Stop-limit order of previous bar plus a tick, whenever a bar high is less than previous bar high) any ideas?? |
| [2014-09-21 03:09:50] |
| Sawtooth - Posts: 4120 |
|
If you want a buy limit order 1 tick above the high of the previous bar at the close of the current bar, try this: -Set 'Signal Only On Bar Close' to Yes -in cell K3: =C3>C4 -in cell J22: =IF(C4>C5,C5+J21,0) |
To post a message in this thread, you need to log in with your Sierra Chart account: