Support Board
Date/Time: Mon, 25 Nov 2024 13:41:46 +0000
Sell Exit for Spreadsheet
View Count: 1980
| [2014-02-05 04:40:18] |
| Litz - Posts: 131 |
|
Trying to figure out setting stop on my sell exit came up with this but it is not accepted as a correct format. =OR(AND($J$8>0,$E$3<=$J$91),AND(CROSSFROMABOVE(AH3:AH5,AJ3:AJ5)) instead of just =CROSSFROMABOVE(AH3:AH5,AJ3:AJ5) When I attempted to use attached order stop order via the Trade Window, orders are all ignored because working orders exist. Without attached order seems to work fine on replay backtest. |
| [2014-02-05 18:48:09] |
| vegasfoster - Posts: 444 |
|
This part is not valid AND(CROSSFROMABOVE(AH3:AH5,AJ3:AJ5), should be just CROSSFROMABOVE(AH3:AH5,AJ3:AJ5) or you need to add another condition, e.g. AND(CROSSFROMABOVE(AH3:AH5,AJ3:AJ5), CROSSFROMABOVE(AI3:AI5,AI3:AI5)). For the last part, is J62 = True? |
| [2014-02-05 19:15:28] |
| Litz - Posts: 131 |
|
Thanks for the response I will try that tonight. Allow entry with working orders currently set to NO
|
| [2014-02-05 19:25:04] |
| |
|
This is missing a parentheses at the end: =OR(AND($J$8>0,$E$3<=$J$91),AND(CROSSFROMABOVE(AH3:AH5,AJ3:AJ5)) For help with using Attached Orders and also the Buy/Sell Exit columns at the same time, refer to: https://www.sierrachart.com/index.php?l=doc/doc_AutoTradeManagment.php#SupportAttachedOrdersForTrading Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-02-05 19:25:18
|
| [2014-02-07 12:44:57] |
| Litz - Posts: 131 |
|
I got the attached order working thanks for the help. I have read the "Disappearing Arrows" documentation and am analyzing the problem of trades being 'true' and happening as per the positions and order, alert manager, and the trade activity manager. A replay from this morning ES trades reveals my entries are good, but the trade is often cancelled and reversed due to the price crossing over the short term moving. See attached file for example. Spreadsheet setting included. I have no clue on how to prevent this from occurring. The trade service log just has ignores (attached. Date Time Of Last Edit: 2014-02-07 12:55:50
|
 1feb7am.JPG / V - Attached On 2014-02-07 12:25:11 UTC - Size: 278.89 KB - 397 views 1TradeserviceLog.JPG / V - Attached On 2014-02-07 12:38:21 UTC - Size: 295.75 KB - 383 views 1TradeActivityLog.JPG / V - Attached On 2014-02-07 12:55:44 UTC - Size: 157.19 KB - 410 views |
To post a message in this thread, you need to log in with your Sierra Chart account: