Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 14:43:50 +0000



Post From: Back testing - Parabolic Indicator

[2013-07-10 08:19:36]
User59357 - Posts: 15
Hi there,

I am new to Sierra Chart and I would like to use Parabolic SAR as indicator for BUY/SELL entries
via the Spreadsheet System for Trading.

The Parabolic SAR Indicator writes its values at: AD3 / AD4
So I wrote this small formula to get the BUY / SELL Entries (TRUE or FALSE) values at K3 and M3:

Buy Entry:
=AND(AD4>E4,E3>AD3) (Last Prices compared with corresponding PSAR Values)

Sell Entry:
=AND(AD4<E4,E3<AD3) (Last Prices compared with corresponding PSAR Values)

The spreadsheet indicates the error message: "Invalid Formula"
I assume it should return "TRUE" or "FALSE" in this case.

Maybe you could help me in this case?

Thank you in advance!