Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 07:44:10 +0000



Post From: Attached orders based on price / study calculations?

[2024-03-27 19:38:10]
John - SC Support - Posts: 36238
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