Support Board
Date/Time: Fri, 29 Nov 2024 12:43:19 +0000
Post From: Spreadsheet System for Trading, K3=1 but didn’t send BuyEntry
| [2023-02-15 01:05:15] |
| PeaceFrog - Posts: 105 |
|
Hi John, I’m glad I asked that question. Thanks for your explanation. It’s clearer now. So, because the System returned a value of “45.120000000000005”, in the Delta formula, do I need to go to as many (15) decimal points? Say for example I use a Delta of 0.1, would this work: AND(AJ3 > 45.110000000000000 and AJ3 < 45.130000000000000) Even though the largest decimal place in Number Formats is 9? Would this be equivalent (and more efficient): AND(AJ3 > 45.11 and AJ3 < 45.13) |