Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 20:28:09 +0000

How to Post a Message for Support

Post From: Some more alert help please...

[2024-02-06 20:53:12]
[Go To First Post]
User719512 - Posts: 264
The key to debug your alert formula is breaking down the pieces and ensuring each piece works.
Does CROSSOVER(ID1.SG1, ID8.SG1) work as expected?
Does C>=ID14.SG1-TICKSIZE*4 work as expected?

Then you can see you need to tweak that part to be more like what cmet posted.
AND(C<ID14.SG1, C>=ID14.SG1-TICKSIZE*4)

^^ this might be correct based on my assumptions of your intended alert. If not, it should put you on the correct path.

Then your original solution might work as:
AND(CROSSOVER(ID1.SG1, ID8.SG1), OR(AND(C < ID14.SG1, C>=ID14.SG1-TICKSIZE*4), AND(C > ID14.SG1, C<=ID14.SG1+TICKSIZE*4)))

Note, you can use multiple lines in alert formulas, but the dialog is small for that sometimes but can help readability.
AND(CROSSOVER(ID1.SG1, ID8.SG1),
OR(AND(C<ID14.SG1, C>=ID14.SG1-TICKSIZE*4),
AND(C>ID14.SG1, C<=ID14.SG1+TICKSIZE*4)
)
)
Date Time Of Last Edit: 2024-02-06 20:53:43