Support Board
Date/Time: Sun, 24 Nov 2024 18:40:48 +0000
Too many decimal places in spreadsheet study
View Count: 186
| [2024-05-02 17:22:21] |
| User454729 - Posts: 18 |
|
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] |
| John - SC Support - Posts: 36238 |
|
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: