Support Board
Date/Time: Mon, 03 Feb 2025 07:02:30 +0000
Very long Values in Spreadsheet Cells that does not exist
View Count: 833
| [2019-10-29 08:33:33] |
| User164131 - Posts: 19 |
|
Hello guys. I have a Volume By Price Study that translate SG2 value (Point of control) to the Spreadsheet System for Trading study (please see screenshot attached) In this example I have RTY futures. Settings Chart settings >> tick size >> 0.100000 Chart settings >> price display format >> 0.1 VolumeByPrice study >> Ticks per volume bar >> 1 VolumeByPrice study >> Value Format >> Inherited Spreadsheet System for Trading study >> Value Format >> Inherited In spreadsheet all values in columns ID0.SG1, ID0.SG2 etc — looks great 1575.5 1576.2 1576.1 But in ID5.SG2 I see 1575.4000244140625 1574.4000244140625 1576.2000732421875 How can it be and what should I do to fix it? I already read all parts of documentation about spreadsheet and can't find the answer((. Date Time Of Last Edit: 2019-10-29 08:37:31
|
 Screenshot (169).png / V - Attached On 2019-10-29 08:34:21 UTC - Size: 25.23 KB - 230 views |
| [2019-10-29 19:34:25] |
| |
|
You need to change the Number Format for that column: Working with Spreadsheets: Cell Formatting Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2019-10-29 19:35:24
|
To post a message in this thread, you need to log in with your Sierra Chart account: