Support Board
Date/Time: Tue, 14 Jan 2025 22:26:47 +0000
Post From: Multiple Exit Automated Trading question
| [2017-05-09 22:22:45] |
| traderacefly - Posts: 57 |
|
Trying to build a formula for the buy/sell exit in my automated trading spreadsheet which utilizes an exit with two targets. The trade would be a 2 lot entry at the same price but the exits would be one off as each condition occurs. I am looking at the "Multiple Exit Automated Trading Example" from: Spreadsheet Systems, Alerts and Automated Trading: Initiating Trades with Auto-Trading and Using Manual or Attached Orders Exits but do not understand how to apply my logic. These are the separate conditions for the "Buy Exit" column. I would like to combine them to take one contract off as each condition is met: =AND(ABS($J$8)<>0,CROSSFROMABOVE(E3:E4,AA3:AA4)) =AND(ABS($J$8)<>0,AM3=0) Thanks in advance for any ideas. |