Login Page - Create Account

Support Board


Date/Time: Fri, 22 Nov 2024 00:50:33 +0000



Post From: Spreadsheet Formula help

[2024-11-01 14:57:20]
User321897 - Posts: 3
I'm trying to write a formula that buys long when the bar closes above the MA and the bar open is above the previous bar open. It closes out the trade when the bar closes below the moving average. What I have doesnt seem to be working though.... Does anyone see what I'm doing wrong?

Buy Entry:
=CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID3.SG1@3:ID3.SG1@4)=AND(ID0.SG1@3 > ID0.SG1@4)

Buy Exit:
=CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4, ID23.SG1@3:ID3.SG1@4)

It seems to signal all the time and doesnt close when below the moving average.