Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 04:53:55 +0000



Post From: Need Help With Spreadsheet Automated Trading Using Multiple Profit Targets

[2022-12-17 18:27:09]
Sawtooth - Posts: 4123
Try this:

Use Attached Orders with 2 targets and a common stop, and 4 instances of the TMS study...

Long target, cell O3: =IF($J$8=2,AA3,IF($J$8=1,AB3,0))
Short target, cell P3: =IF($J$8=-2,AA3,IF($J$8=-1,AC3,0))
Long stop, cell Q3: =IF($J$8=2,$J$48-$J$21*n,IF($J$8=1,$J$48,0))
Short stop, cell R3: =IF($J$8=-2,$J$48+$J$21*n,IF($J$8=-1,$J$48,0))

-where n is the initial stoploss offset, in ticks.