Support Board
Date/Time: Fri, 07 Feb 2025 17:49:02 +0000
Float values instead
View Count: 826
| [2020-06-11 03:19:20] |
| trading2themoon - Posts: 46 |
|
Some weeks ago my SC started using float values in my charts. This is causing a lot of problems calculating equivalents. How to fix? :) Example: https://share.getcloudapp.com/RBuq0N1w |
| [2020-06-11 05:00:17] |
| |
|
Refer to these two sections: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons Spreadsheet Menu: Spreadsheet >> Number Format 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 |
| [2020-06-11 12:43:08] |
| trading2themoon - Posts: 46 |
|
Why would this happen? Why would SC not fix this permananetly? This is not a feature, it is clearly a bug. I've never seen software in 20 years of development that ships with this problem for its customers.
|
| [2020-06-11 12:56:02] |
| trading2themoon - Posts: 46 |
|
Everything is set to default values. I don't want to change that because it will cause problems when I have other data types in a cell (for example a 1 or a text value).
|
| [2020-06-11 15:12:11] |
| Sawtooth - Posts: 4173 |
|
The Number Format doesn't remove float values; it only removes them from displaying. You can use a formula in column H to remove the float values. Start by removing them in the Tick Size, e.g. H21: =1/ROUND(1/J21,0) Spreadsheet Example Formulas and Usage: Removing Floating Point Imprecision |
To post a message in this thread, you need to log in with your Sierra Chart account: