This is a very simple Alert being used

=CROSSFROMABOVE(ID18.SG1, ID19.SG1) to create a Color Bar Alert ID14.SG1

=ID14.SG1@3>0 is entered in cell M3 for Sell Entry. The Color Bar Alert is set to -Evaluate on Close-.

The Alert appears under the correct conditions on the close of the bar/candle (it's a Range bar), the trade arrow appears under the Alert indicator (Diamond) but the trade entry is not on the next bar but on the second bar after the alert.

What am I missing here ?

thanks!

You could bypass the color bar output and instead directly use the spreadsheet's syntax for the signal in M3:
=CROSSFROMABOVE(ID18.SG1@3:ID18.SG1@4,ID19.SG1@3:ID19.SG1@4)

Will eliminating the color bar alert and using the above code in the spreadsheet eliminate the lag in trade execution?

Or, is the lag in execution simply part of using Evaluate on Close parameter?

OK, I tried it both ways, Color Bar Alert/Evaluate on Close and the Spreadsheet Syntax that you suggested.

I have both versions of alerts for buy entry K3 and sell entry M3. It's about as simple alert as there is.

Both entries with each version were one bar late running in simulation mode. Screen caps attached.

Is there something in the Spreadsheet Study parameters that would cause this?

I can put up screen capture of how that is set.

Current version of SC. I really don't get this... and I appreciate the help greatly.

Standby, I may have spoken too soon, something else is going on.

It seems like with the Spreadsheet Syntax it's not waiting for the Evaluate on Close, but doing the trade in the bar that has the alert as soon as the alert goes off.

Let me run thru this a few more times.

oatwillie 

Standby, I may have spoken too soon, something else is going on. It seems like with the Spreadsheet Syntax it's not waiting for the Evaluate on Close, but doing the trade in the bar that has the alert as soon as the alert goes off. Let me run thru this a few more times.

You must set 'Signal Only On Bar Close (K,M)' to Yes.

The Alerts tab is not used in this study, except that 'Enabled' must be checked. The other check boxes on the Alerts tab are ignored.

Ok let me set that up.

Thank you!

"we are not worthy, we are not worthy..."

That did it.
I also tried it with the Color Bar Alert but with the Alert not having the Evaluate on Close parameter in the Alert but in the 'Signal Only On Bar Close (K,M)' parameter set .

It's confusing as I thought having the Alert with Evaluate on Close would give the same result but it obviously (now to me anyway) does not. I think I understand why.

Thank you so much Tom.

@tomgilb Please can you help? I'm testing out a simple auto trade strategy but the market orders are filling 5 points from arrows. Any way I can combat this? Thanks