Login Page - Create Account

Support Board


Date/Time: Tue, 04 Feb 2025 09:46:46 +0000



Post From: How to flip trades between two conditions?

[2020-01-11 03:56:38]
Sawtooth - Posts: 4166
How will SC know the prior order was a buy or a sell?
J7 will be a positive value if the previous trade was long, and a negative value is the previous trade was short.

How can I maintain the rule of condition 1 and bypass conditions 3 and 4 until condition 2 is reached?
You'll need to create a persistent TRUE in a Formula Column for each condition, then release it with another condition, then in K3/M3 find the transitions from 0 to 1 for the signals.
There is no specific example of how to do this because each system is unique. But here are a few general examples:
Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables