Support Board
Date/Time: Tue, 26 Nov 2024 04:37:30 +0000
Post From: Spread sheet exit entire position????
| [2014-04-04 19:21:21] |
| Sawtooth - Posts: 4120 |
|
I'll assume that formula is for exiting a long position, so I'll create the opposite direction exit also. Put this in J29, and remove formulas in L3 and N3: =IF(J8>0,OR(AND(AA3<AE3,AA4>AE4),AND(AA3<AG3,AA4>AG4)),IF(J8<0,OR(AND(AA3>AE3,AA4<AE4),AND(AA3>AG3,AA4<AG4)),FALSE)) If you have Signal Only On Bar Close set to Yes, you'll need to increment the rows 1 row higher: =IF(J8>0,OR(AND(AA4<AE4,AA5>AE5),AND(AA4<AG4,AA5>AG5)),IF(J8<0,OR(AND(AA4>AE4,AA5<AE5),AND(AA4>AG4,AA5<AG5)),FALSE)) Date Time Of Last Edit: 2014-04-04 19:24:09
|