Support Board

Date/Time: Thu, 25 Apr 2024 20:51:57 +0000

Post From: Reset Condition on New Bar- J72

[2020-02-13 22:41:38] Link To Thread - Link To Post [Go To First Post]
User190501 - Posts: 92
Thanks a lot tomglib for the response. As stated, the objective is to cancel all working orders except attached working orders whenever a condition of new entry holds true. From the main settings of the spread sheet study you can reset K3, M3 at the start of a new bar. for example, if a down bar comes in an up trend , I set entry stop order 1 tick above the high , and got up bar in a down trend, I set a sell stop order 1 tick below the low, this will form K3, M4 conditions --- The same condition but at 4 not at 3 , i.e K4, and M4 is used for the cancellation in J78 as J column cannot accept update from 3 for some reason ! The problem happens if there is a series of down bars after each other in up trend or a series of up bars after each other in a down trend, the conditions for entry will not change as it holds true all the time from 4 stand point in the J column but for sure K3, M3 are reset at each new bar condition. I have added your suggestion and still it doesn't work and the formula is as below ... I would appreciate your kind support.. =AND( OR(K4,M4), AND(FRACTIME(J41)>=FRACTIME(A3),FRACTIME(J41)<FRACTIME(A3)+5/86400) )