Login Page - Create Account

Support Board


Date/Time: Tue, 28 May 2024 05:05:54 +0000



spread sheet alert formula

View Count: 123

[2023-11-20 07:44:21]
User928353 - Posts: 8
hi i have tried every possible combination but i keep getting syntax error for formula i am developing here what i want if the value in ID4.SG1 has 5 character like 12345 and the value in ID4.SG2 has 4 character number like 1234 it then Triger buy as it has more number in it, dosent just have to be greater but has to be greater then by a extra numerical number as compared to the other number , i came up with this but it still give me error can you help please
=IF(LEN(MID(ID4.SG1, 3, 100)) > LEN(MID(ID4.SG2, 3, 100)) .

Thank You
[2023-11-20 21:53:05]
John - SC Support - Posts: 31885
We do not know what study you are using to get your values (ID4), but you are using Text functions on number values, which is why what you are trying to do will not work.

You need to do something along the lines of the following:
=AND(ID4.SG1 >10000, ID4.SG2 < 10000)
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