Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 16:55:15 +0000

How to Post a Message for Support

Too many decimal places in spreadsheet study

View Count: 43

[2024-05-02 17:22:21] #1 [Go To First Post]
User454729 - Posts: 15
Hi there, my goal is to do an analysis on the opening range, 1st 30 and 60min of cash open on CL. I have separate charts to set the time session to reflect each of that. I added a spreadsheet study on the first chart (1st 1min - session time is 900:00 to 9:00:59) and then added a study/price overlay to bring in the 30min and 60min bar so that I can study it all on one spreadsheet study. the issue I encountered is that for the price/study overlay of the 30min and 60min, the price will be 85.6500015287..... instead of just 85.65. This creates a problem for my analysis. Why is this happening? Thank you.

[2024-05-02 17:23:14] #2 [Go To First Post]
John - SC Support - Posts: 31704
This is due to Floating Point resolution. Refer to the following: 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: