Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 05:43:51 +0000



Post From: SPREADSHEET FORMULA DISAPPEAR AFTER SAVING AND CLOSING CHARTBOOK

[2019-05-22 00:03:55]
User807128 - Posts: 18
I entered the formula on sheet #4 and sheet #8 as well. it seems to be working.

so it seems I have to enter formula on both sheets. please see if this is correct.

I have one more question...

after replaying the chart >> I see order entry right after market opens on May 17 NQ chart. I do not see order enrty box where we enter stop loss value etc.

after order gets open up , it does not show buy exit around 950 AM even though moving average cross over is there.

=AND (ABS($J$8)=0,CROSSFROMBELOW(AR3:AR4,AS3:AS4),A3-INT(A3)>TIMEVALUE("09:30:00")) . buy entry formula.

=OR (AND(ABS($J$8)<>0,CROSSFROMABOVE(AR3:AR4,AS3:AS4)),A3-INT(A3)>=TIMEVALUE("15:55:00")) . buy exit formula.
Private File