Support Board
Date/Time: Wed, 27 Nov 2024 08:52:10 +0000
Post From: Spreadsheet syntax vs Alert syntax for price bar colors
| [2023-09-07 19:13:25] |
| John - SC Support - Posts: 36309 |
|
Hi Tom, Sorry, I did not realize this was you asking the question until a few days ago. I finally had a chance to dig into this a bit, but I am not seeing what you are stating. To begin with, I am getting the exact same results with either formula with a standard chart. With the Heikin-Ashi there is one situation where there is a divergence, and for me it is with the Spreadsheet not working properly. The particular case is where the current bar's Open is equal to the Close (a Doji bar - sorry I missed that in your original statement) and the Open of the current bar is equal to the close of the previous bar. In this case, none of the entries are true, so it should fall through to the final "False" entry. But, since the Spreadsheet uses Floating Point values, the Close and the Open are NOT exactly equal to each other, so one or the other of the True parameters works and hence there is a different result. Let me know if you need me to look at this further. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |