Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 05:59:29 +0000



[Programming Help] - spreadsheet - only one trade per day

View Count: 610

[2020-04-19 23:47:02]
arruga - Posts: 249
Hi
I got a spreadsheet system...
I get TRUE, order placed...
Few bars later, exit triggered, I'm out.
Few bars later, it if gets true again, will place new order, but I only want to place an order at the first TRUE signal
What's the best way to constraint the system to a single trade per day and ignore all TRUE signals that may happen thereafter?
[2020-04-20 13:11:48]
Sawtooth - Posts: 4000
- You could reference cell J52.
In K3/M3:
=AND($J$52=0,YourConditions)
or in J28:
=J52<>0

- You could compare the Date of J41 to the Date of J42 or J43:
In K3/M3:
=AND(INT($J$41)>INT($J$42),YourConditions)
or in J28:
=INT(J41)=INT(J42)
[2020-04-20 20:28:28]
arruga - Posts: 249
That's great.. many thanks!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account