Login Page - Create Account

Support Board


Date/Time: Mon, 15 Sep 2025 23:03:31 +0000



Post From: Spreadsheets automatically changing numbers

[2021-09-22 16:59:06]
John - SC Support - Posts: 41827
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:
Support Board Posting Information: Attaching a File (Optional)
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing