Home >> Support Board

Support Board

Date/Time: Sat, 27 Jul 2024 02:23:17 +0000

How to Post a Message for Support

spread sheet alert formula

View Count: 159

[2023-11-20 07:44:21] #1 [Go To First Post]
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] #2 [Go To First Post]
John - SC Support - Posts: 33316
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: