Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 04:32:21 +0000



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

[2022-12-15 04:08:41]
Sawtooth - Posts: 4123
The TMS study moves Attached Order targets or stops, so you'll need to create a Trade Window config that places 2 targets at some initial offsets when your system triggers an entry.

The TMS study only sees row 3 of a spreadsheet column, IOW, only the most recent value.
So you would only need to us a simple formula like this in cell O3:
=IF($J$8=2,AA3,IF($J$8=1,AB3,0))
This formula is for Longs Targets only.
Use another instance of the TMS study, and another spreadsheet Formula Column, for Short Targets.

When price trades through AA3, the Attached Order target will fill because the TMS study moved it there.
Same with AB3.