Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 07:50:02 +0000



Post From: Programming help-automate with spreadsheet-trigger when bar CLOSES above

[2023-09-06 23:11:06]
Sawtooth - Posts: 4120
Would you be able to tell me how to make it just a cross/touch?
The spreadsheet syntax CROSSFROMBELOW/CROSSFROMABOVE functions requires two ranges, separated by a comma.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMABOVE_Function

Try this:
=CROSSFROMBELOW(C3:C4,ID19.SG1@3:ID19.SG1@4)
This uses the High, so with Signal Only On Bar Close set to Yes, it will not require a crossover of the Close, at bar close.