Login Page - Create Account

Support Board


Date/Time: Sun, 12 May 2024 07:08:50 +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.