Login Page - Create Account

Support Board


Date/Time: Fri, 10 May 2024 10:42:08 +0000



Post From: Spreadsheet alert/trading incorrect execution

[2017-05-11 01:35:13]
User269983 - Posts: 31
I have a simple trailing system below. On long, it trail by the low of last 2 bars - 2 ticks, and for short, high of last 2 bars + 2 ticks. However, it is not working.

The screenshots show the condition evaluated true when low of current bar is lower the than low of previous 2 bar. It should only evaluate true if the current low is lower than previous 2 bar by 2 ticks.

On the example:
47.46
47.47 [-1]
47.47 [-2]

47.46 should be false. When it hit 47.45, then it is true.

Buy Exit:
=AND(J8>0, A3>J42, D3<(MIN(D4, D5) - 0.01))

Sell Exit:
=AND(J8<0, A3>J42, C3>(MAX(C4, C5) + 0.01))
imageSC-Spreadsheet.png / V - Attached On 2017-05-11 01:28:05 UTC - Size: 37.54 KB - 230 views
imageSC-Spreadsheet-details.png / V - Attached On 2017-05-11 01:28:08 UTC - Size: 14.33 KB - 195 views