Support Board
Date/Time: Wed, 03 Sep 2025 19:24:18 +0000
Post From: Spreadsheet trading question about using IF for multiple entries??
| [2014-06-06 17:32:01] |
| Sawtooth - Posts: 4261 |
|
Assuming your order quantity is 1, and you only want to add to the position once, here's a simplistic way: =OR(AND($J$8=0,AA4>AG4,AA5<AG5,AG4>AC4,AG4>AE4,E4>AG4),AND($J$8=0,AA4>AE4,AA5<AE5,AE4>AC4,AE4>AG4,E4>AE4),AND($J$8=1,AA4>AC4,AA5<AC5,AC4>AG4,AC4>AE4,E4>AC4)) There are other more involved ways to do it in different situations. |