Login Page - Create Account

Support Board


Date/Time: Tue, 11 Mar 2025 17:26:54 +0000



Post From: Eliminating consecutive Buy/Sell Entry signals

[2018-05-08 14:57:58]
User606491 - Posts: 164
Regarding the spreadsheet system for trading:

Certain formulas trigger multiple consecutive entry signals. How do I adjust my formulas so that I'm only executing an entry (and receiving an alert) on the first signal?

A formula such as =if($J$8>0,[buy formula]=0,[buy formula]) will not work because I want to execute later entries (alerts) for pyramiding purposes.

One method may be =if(and($J$8>0,[buy formula]@4:@10=1),0,[buy formula]), but this isnt elegant.

Do you suggest another way to receive only one entry signal