Support Board
Date/Time: Thu, 28 Nov 2024 00:34:57 +0000
How many decimal points can custom spreadsheet graphs output?
View Count: 270
| [2023-06-13 17:36:39] |
| User480109 - Posts: 36 |
|
please see attached picture. I know the formula has more significant digits but we only see -43.50, where do I go to change the precision?
|
 SC Granular.JPG / V - Attached On 2023-06-13 17:36:31 UTC - Size: 111.61 KB - 89 views |
| [2023-06-13 18:44:34] |
| John - SC Support - Posts: 36350 |
|
Refer to the following: Chart Studies: Settings and Inputs Tab >> Value Format For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-13 21:08:25] |
| User480109 - Posts: 36 |
|
John- I tried your suggestion but the output still doesn't play the granular decimal places it should. As you can see, the formula circled(attached pic) is a weighted average price based on the volume on bid and the volume on offer. You can imagine this figure changing and can be something like -45.45895850, for example. |
| [2023-06-13 21:25:21] |
| John - SC Support - Posts: 36350 |
|
When we use your formula and set the Value Format to show a large number of decimal places, we see values like 4372.652832. Attached is an image showing this. Are you not getting something like this?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
 ChartImage.bmp - Attached On 2023-06-13 21:25:17 UTC - Size: 4.24 MB - 246 views |
| [2023-06-13 21:29:48] |
| User480109 - Posts: 36 |
|
can you please screenshot me your chart studies setup and also scales
|
| [2023-06-13 22:07:35] |
| John - SC Support - Posts: 36350 |
|
Attached are the Spreadsheet Formula Inputs and the Scale Settings. Nothing special about either one. But, we did notice one thing, when there was no data coming into the system, the Spreadsheet Formula was not updating properly (so from 16:00 - 17:00 Central US time when the ES is not trading). At that time, we saw only a single value, but once it was after 17:00 everything updated properly. We do not know how this would relate to what you are seeing, but wanted to pass it along in case there is some relevancy. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| SpreadsheetFormulaInputs.png / V - Attached On 2023-06-13 22:07:27 UTC - Size: 36.62 KB - 65 views SpreadsheetFormulaScaleSettings.png / V - Attached On 2023-06-13 22:07:33 UTC - Size: 35.08 KB - 74 views |
| [2023-06-14 08:48:37] |
| User480109 - Posts: 36 |
|
i tried your suggestions but i still cannot get the precision from decimal points. I also have a real-time quote spreadsheet too and it updates the bid price bid volume offer price and offer volume. I've attached 2 pics to help. Any more suggestions?
|
Attachment Deleted. Private File Private File |
| [2023-06-14 14:04:21] |
| John - SC Support - Posts: 36350 |
|
The suggestion we have is to take the formula piece by piece. Make sure you get the correct Price for Ask and Bid by using them by themselves. Then add each item piece by piece and see what happens. The other option would be to use the Spreadsheet Study. You would have to add other studies to get the Ask Price, Bid Price, Ask Volume and Bid Volume. Then use those to make the calculation in 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: