Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 02:59:45 +0000



Post From: Create a Trading System with Spreadsheet

[2014-12-19 15:14:21]
Sawtooth - Posts: 4141
The formula does not give an error when I try it.

A buy exit formula would go in cell L3, and would most likely not use an absolute reference to E3

=OR(AND($J$8>0,E3<=$J$9-1),AND($J$8>0,E3>=$J$9+2))

You could also write the formula this way:
=AND($J$8>0,OR(E3<=$J$9-1,E3>=$J$9+2))