Support Board
Date/Time: Sun, 22 Dec 2024 05:32:04 +0000
Post From: Cell J23 when using column L for BuyExit and Stop
| [2015-07-14 13:01:31] |
| Sawtooth - Posts: 4141 |
|
Formulas in J22:J25 need to produce a price, not a TRUE/FALSE, which is used when K3:N3 go TRUE You can also use a formula in J72 based on a condition: =IF(J10>0,"L","M") Creating targets and stops with spreadsheet formulas can get complicated. I find it is usually easier to use the Trade Management for Study study to manage Attached Orders that are optionally placed with formulas in J80, J81. An additional advantage is OCO orders at the exchange in case of connection issues. The Trade Management for Study study is set to reference a spreadsheet subgraph (formula column) and the price-controlling formula is in row 3. Zeros are ignored. You can use two instances and two formula columns if you want to separate longs and shorts, or targets and stops. http://www.sierrachart.com/index.php?page=doc/doc_AttachedOrders.html#StudyControlledTargetsStops You can also combine it with exit formulas in L3, N3. (set "Cancel All Working Orders On Exit' to Yes). |