Support Board
Date/Time: Fri, 27 Jun 2025 21:36:12 +0000
Spreadsheets automatically changing numbers
View Count: 547
| [2021-09-22 16:18:12] |
| User647607 - Posts: 19 |
|
When I input a value into my spreadsheet study, sometimes it will automatically add or subtract a tiny amount to the value. I've attached a screen shot. Both values I put in myself. The Call IV column had the value of 20.48. It changed it automatically. There isn't a formula in the field. I can't find a setting somewhere that is obvious to affect changing the values. Please help.
Date Time Of Last Edit: 2021-09-22 16:20:37
|
 2021-09-22 09_19_34-Clipboard.png / V - Attached On 2021-09-22 16:20:10 UTC - Size: 1.78 KB - 168 views |
| [2021-09-22 16:59:06] |
| John - SC Support - Posts: 40645 |
|
Generally, that kind of situation is a typical floating point precision issue. But, you should not be getting that for data that you have manually entered. So if you actually typed in "20.48" it should be showing 20.48. First, refer to the following regarding Float Point precision: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons If you are typing in that value and then it is changing as you are stating, then we would like to see your spreadsheet. Follow these instructions to get us your spreadsheet: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-09-22 19:41:46] |
| User647607 - Posts: 19 |
|
Yes, it should not be a floating point issue as I'm entering it manually. I've attached the spreadsheet as requested.
|
Private File |
| [2021-09-22 23:37:50] |
| User647607 - Posts: 19 |
|
The issue will also happen like this. The formula in M3 is =(K3+L3)/2 but it removes .000000000000002 from the result. I've attached the screenshot. When the spreadsheet adds or removes .000000000000002 from a field is inconsistent.
|
| 2021-09-22 16_26_54-Clipboard.png / V - Attached On 2021-09-22 23:32:25 UTC - Size: 2.37 KB - 167 views |
| [2021-09-22 23:40:49] |
| John - SC Support - Posts: 40645 |
|
Sorry, we forgot that although it generally does not come up with entered values, the floating point imprecision can display sometimes even with entered values, of which you just happened across one of them. It really should not interfere with your calculations, as long as you are not needing anything with that number of significant digits. And in order to change the display so you do not see all of the values, select Spreadsheet >> Number Format and set the display type that you want in the window that comes up. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: