Support Board

Date/Time: Tue, 23 Apr 2024 07:31:01 +0000

Post From: Cell J23 when using column L for BuyExit and Stop

[2015-07-14 13:01:31] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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).