Login Page - Create Account

Support Board


Date/Time: Fri, 27 Dec 2024 07:20:10 +0000



Post From: Multiple Entries

[2015-12-16 00:49:38]
Sawtooth - Posts: 4143
In that case, try this:
1) Add the Trading: Total Quantity Filled study, and check Hide Study. The formulas below assume its output is in column AA.
2) In a spare Formula Column, e.g. column P, put this in cell P3:
=AA3>AA4
This marks TRUE the bar when an entry or exit occurred.
3) Put this in cell H1:
=IF(AA3=0,0,INDEX(A3:A1002,MATCH(TRUE,P3:P1002,0),1))
This returns the DateTime from column A of the most recent TRUE in column P.
4) Put this in cell H2:
=INT(J41)>INT(H1)
This compares the date of the most recent fill (H1) with the date of the last chart update (J41). It will return TRUE if J41 is a later date than H1.
5) Include a reference to H2 in your entry K3 formula:
=AND(H2,YourEntryConditions)
This looks for a TRUE in H2 before your other entry conditions can be TRUE.
6) Leave J28 blank, unless you want to use it for other reasons.

This assumes the following:
-'Allow Multiple Entries in Same Direction' is set to Yes
Date Time Of Last Edit: 2015-12-16 05:09:19