Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 15:00:18 +0000

How to Post a Message for Support

Spreadsheet trading

View Count: 1053

[2016-11-12 17:55:27] #1 [Go To First Post]
User261741 - Posts: 22
Dear Support team, Is it somehow possible via spreadsheet automated trading to: 1. Cancel stop limit entry order after 2 bars (or x minutes) if it isn't filled? 2. Move initial stop loss to break even after x profit or x price move? Thanks in advance...

[2016-11-12 20:46:59] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
1. This could be done with this Sheet cell: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#CancelWorkingOrders However, you would have to determine what formula to use. It would have to involve the current bar time and the entry time. Refer to: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#CellJ42 2. For this you need to use Attached Orders with Move to Breakeven for Stop settings enabled on the Stop order. Refer to: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#UsingManualOrAttachedOrdersExits 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

[2016-11-13 11:15:26] #3 [Go To First Post]
User261741 - Posts: 22
1. I need to cancel only unfilled entry orders after 2 bars or x minutes. Cell J42 is refering to last trade entry time (filled orders)... I am assuming that my setup is no longer valid after 2 bars for example and I want to delete all of my working orders if not entered after 2 bars (or x minutes)... 2. With this feature it is not possible to move to breakeven after X profit right (only after x ticks or % or at specific price)? Thanks!

[2016-11-14 01:49:44] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
1. Yes, you are correct, Last Entry Trade Date-Time would not work because it only gives the Date-Time of a filled order. So in this case you need to compare the Date-Time of the last bar using: https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#CellJ41 With the time of the order entry but you would have to remember that somehow. That is not very easy to do with Spreadsheets. 2. Only after the specified number of ticks. Not a percentage. 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: 2016-11-14 01:50:25

[2016-11-14 11:59:34] #5 [Go To First Post]
User261741 - Posts: 22
1. Is it possible to use array formulas within spreadsheet (like in excel)? If yes than I would be able to do that... 2. I need to move my initial stop loss to breakeven after some amount of profit... so there is none chance of doing that with spreadsheet? Thanks

[2016-11-14 17:18:18] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
1. No. But there still should be another way to do this. We will see about adding a new cell indicating the Date-Time of the last order submission. Just give us a few days to look into this. 2. This can be done through the Attached Orders functionality: http://www.sierrachart.com/index.php?page=doc/AttachedOrders.html#MoveBreakevenForStop 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

[2016-11-14 18:02:12] #7 [Go To First Post]
Sawtooth - Posts: 3992
We will see about adding a new cell indicating the Date-Time of the last order submission If you are talking about buy limits or buy stops, I would also like this. But the problem is making it persistent in a Formula Column. 1. If the entry signal is at close of bar, you can do it using the timestamp of the bar after the buy signal bar, with a formula like this, e.g. in cell Z3: =IF(AND(K5=FALSE,K4),A3-INT(A3),Z4) Then compare it to J41 with a formula like this (cancelling a long), e.g. in cell J27: =J41-INT(J41)-Z3>=n/1440) where n is minutes. 2. Attached Orders cannot trigger a MBE based on profit, at least not one based on a spreadsheet formula, but it could be done using a price level in a Formula Column via a formula referencing J10, then using the Trade Management By Study study to move the Attached Order. You may also need to use a Lock A Condition True formula.

[2016-12-14 15:11:06] #8 [Go To First Post]
User261741 - Posts: 22
Tom many thanks for your kind help!!!

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