Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 10:58:31 +0000



Spreadsehhet formula Don't works whit multiple formulas

View Count: 273

[2023-05-15 20:45:23]
Hopeman - Posts: 166
Hi,

I'm trying to create several crossover conditions, they are simple crossovers, these crossovers go together with some conditions in the cells O3,Q3,X3,Y3,AD3,AF3,AK3,AM3,AO3,AT3,AZ3) the formula is as follows
=AND(OR(CROSSFROMBELOW (ID0.SG4@3:ID0.SG4@5, ID7.SG1@3:ID7.SG1@5), OR ( ID0.SG4@3:ID0.SG4@5, ID7.SG2@ 3:ID7.SG2@5), OR( ID0.SG4@3:ID0.SG4@5, ID3.SG3@3:ID3.SG3@5), OR( ID0.SG4@3:ID0.SG4@5, ID3.SG19@3:ID3.SG19@5)),O3,Q3,X3,Y3,AD3,AF3,AK3,AM3,AO3,AT3 ,AZ3)

I have tried several configurations and none of them work changing the parentheses, even creating a crossfrom to each of the formulas and it doesn't work, would you be so kind as to help me solve the problem,

thanks
[2023-05-15 20:45:50]
John - SC Support - Posts: 36350
What exactly are you getting in terms of an error? Or are you not getting an error, is it just not working as expected?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account