Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 06:26:56 +0000



Attached orders based on price / study calculations?

View Count: 97

[2024-03-27 18:54:33]
mattvk - Posts: 32
I’d like to set targets (and stops) immediately upon order fill using a price / study calculation (price +/- ATR). I can’t figure out how to do this using the "Trade Management By Study”. I have referenced “Attached Orders: Study Controlled Targets and Stops” as well and it doesn’t seem to work for my use case.

Example / ideal flow:

- Buy order fills via spreadsheet trading system buy entry signal, quantity 2, @ price X
- Target 1, quantity 1, price = order fill price + 1*ID1.SG1 (assume ID1=ATR for example)
- Target 2, quantity 1, price = order fill price + 2*ID1.SG1
- Stop 1&2 = order fill price - 0.5*ID1.SG1

I’d like to be able to keep executing orders if signals are generated, with max quantity set only in the spreadsheet trading system “Maximum Position Allowed” field. I want the attached targets and stops to be set immediately upon order fill, and not modified after.

Is this possible?
[2024-03-27 19:38:10]
John - SC Support - Posts: 31293
Make sure you have the ATR on the chart that also has the Spreadsheet System for trading. In this case, the ATR information will be in the first non-calculation column in the spreadsheet (typically starting at column AA).

Then in cell J80 (using the V1 ordering) you put in the offset for the Target you want and in cell J81 you put in the offset for the Stop you want. For the Target you would have a formula like the following:
=MROUND(2 * ID1.SG1@3, $J$21)

And for the Stop it would be the following:
=MROUND(.5 * ID1.SG1@3, $J$21)

Where ID1 is the ID of the ATR study and SG1 is the first subgraph from the study (i.e. the ATR itself). the @3 specifies the current bar, or row 3 in the spreadsheet. $J$21 is the Tick Size (again in V1 of the I/J column ordering).

There is not a way to specify multiple targets within the spreadsheet, so you would have determine how best you want to handle that.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-27 20:19:50]
mattvk - Posts: 32
Thanks for your reply. Multiple targets within the spreadsheet is actually what I need in this case. It would be great to be able to specify "OCO Group X Attached Order Target Offset", with the ability to have separate quantities for each OCO Group. I guess it would require dedicated rows in I for each group target and stop. Feature request +1

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

Login

Login Page - Create Account