Support Board
Date/Time: Thu, 27 Feb 2025 06:57:47 +0000
Post From: Formula ignores 'negative' values ?
| [2021-06-16 16:12:08] |
| John - SC Support - Posts: 38222 |
|
These things are not matching up. The information displayed in 1.png shows that there is an ABS (Absolute Value) being taken of the data. That would explain why you are not getting the negative values. But, the Spreadsheet Formula you show is correct and does not have an Absolute Value. Additionally, the Spreadsheet Formula has a different Short Name than what is shown in 1.png and is also set to display in Region 1, which the formula in 1.png is also not doing (it is in region 3, or possibly 2, depending on the setup). So, there is a mismatch going on. Be sure to use that Spreadsheet Formula as you showed in the image and you should be fine. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |