Support Board
Date/Time: Wed, 01 Jan 2025 13:29:24 +0000
Post From: Spreadsheet-Rare bug in Greater than or Equal?
[2016-05-13 18:56:53] |
Sierra Chart Engineering - Posts: 104368 |
This is almost certainly not a bug. This is merely a floating-point error comparison issue. Refer to: https://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php#ImprecisionOfFloatingPointNumbers To confirm this is the case, change the formula to: (E3-E4)>= 0.74 I'm sure you've done it, but I urge you to someday have someone spend a few days doing what I've done, looking for these 3 or 4 bugs and others, slowing it down, testing an assortement of operators. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |