Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 15:23:39 +0000



Replay: MTF Crossover Problem

View Count: 5965

[2017-07-31 04:26:40]
User312841 - Posts: 26
http://www.sierrachart.com/image.php?Image=150147385713.png

The crossover always works fine as a Color background on Alert (Blue line)
=CROSSFROMBELOW(ID3.SG1,ID1.SG1)
Magenta line
=(CROSSFROMABOVE(ID3.SG1,ID1.SG1))
ID3 is in a 3T Renko, ID1 is from a 9T Renko chart (Blue and Magenta stair step)

The problem is when using the Spreadsheet to autotrade in Replay Mode. The first trigger places the trade but the Buy Exit never trips.
Spreadsheet Buy Entry
=AND(CROSSFROMBELOW(ID3.SG1@3:ID3.SG1@4,ID1.SG1@3:ID1.SG1@4),$J$8 = 0) **Places trade OK**
Buy Exit
=AND(CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID1.SG1@3:ID1.SG1@4),$J$8 > 0)

Attached is a file with the higher timeframe settings. What am i missing? Thanks
imageCapture.PNG / V - Attached On 2017-07-31 04:22:51 UTC - Size: 24.97 KB - 296 views
[2017-07-31 16:52:39]
Sierra Chart Engineering - Posts: 104368
Update to the current version of Sierra Chart following these instructions:
Software Download: Fast Update

Also try setting Data Copy Mode to Use Latest Value.

Buy Exit
=AND(CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID1.SG1@3:ID1.SG1@4),$J$8 > 0)
Does this formula ever return 1 at any row?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2017-07-31 17:43:44]
User312841 - Posts: 26
Tried using Latest Value - did not help

I never saw a 1, but recall seeing a #VALUE displayed several rows down.
[2017-07-31 18:17:33]
Sierra Chart Engineering - Posts: 104368

I never saw a 1, but recall seeing a #VALUE displayed several rows down.
In this case, then you need to look at the particular cells being referenced by the formula and see why those are not as expected.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account