Login Page - Create Account

Support Board


Date/Time: Sun, 19 Jan 2025 00:02:07 +0000



Post From: Spreadsheet Entries and Exits

[2018-02-26 22:06:51]
Sawtooth - Posts: 4154
Yes, all of this is possible with the Spreadsheet System for Trading study, and the Trade Management by Study study.

It is too detailed to share exactly how in this venue, but here is an overview:
-Use cells K3 and M3 to trigger the entries.
-Use cells J22 and J24 to set the Buy/Sell Stop entry prices.
-Use cells J71 and J73 to set the order type to S.
-Use cell J27, or J78, to cancel unfilled working orders.
-Use the Trade Window's Attached Orders config to place the target offset at 4 ticks and the stop offset to n ticks, with a move to breakeven offset.
-Use Formula Columns to create persistent variables of the stoploss prices.
-Use two instances (one for longs and one for shorts) of the Trade Management by Study study to move the Attached Order's n stoplosses, referencing the persistent variables.

Here are some links to get you started:

Attached Orders: Study Controlled Targets and Stops
Spreadsheet Systems, Alerts and Automated Trading
Spreadsheet Example Formulas and Usage
Date Time Of Last Edit: 2018-02-27 13:58:26