Login Page - Create Account

Support Board


Date/Time: Tue, 01 Apr 2025 22:45:26 +0000



Post From: Spreadsheet Syntax

[2022-12-06 16:43:09]
Dean Roberts - Posts: 79
Hi - Tom was helping me with some trading via alert but I have moved up to spreadsheets and I am getting a syntax error...

=AND(CROSSFROMABOVE(C,BF), CROSSFROMABOVE(DU,EG), AO>=8,AO<=16, AO[-1]>=8,AO[-1]<=16, AO[-2]>=8,AO[-2]<=16)

First test is for a cross over of a VA line, second is a VA line in Region 2 for an study/price overlay of a symbol for another chart, and the last three checks are to limit ATR to between 8-16 for the last three candles.
Is there an obvious error in the spaces etc. or am I adding in incorrect column references?

Thanks
Cad