Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 03:42:10 +0000



Spreadsheet uneven numbers

View Count: 297

[2023-03-15 19:49:18]
Emp0rt - Posts: 3
All numbers from column A-G are fine, but when I look at numbers in column I, J and all the custom studies columns all numbers look like this 95.80999755859375 (number from the box next to "Bid (read-only):").

Why is that?
[2023-03-15 21:11:18]
John - SC Support - Posts: 36350
They are not specifically formatted to only show a certain amount of the number. Additionally, the number is a Floating Point, which is kept in the computer in that style. Refer to the information here:
Working with Spreadsheets: Floating-Point Values and Comparisons When Using the Spreadsheet Study
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:

Login

Login Page - Create Account