Support Board
Date/Time: Wed, 27 Nov 2024 12:37:30 +0000
Help removing 2 decimal places when displaying text of a spreadsheet study
View Count: 361
| [2023-08-09 01:35:28] |
| HumblyTrading - Posts: 179 |
|
Hello SC Team, I love the Spreadsheet study! I did not understand it for awhile, but once you get your head around it, wow! :) I have a very simple formula which is just showing me the amount of time of the last candle. It currently includes 2 decimal places when I use the Text Display for Study. I have tried the Round and Trunc functions, but still I get the decimals. I would like it to display simply "16," not "16.00." I'm probably missing something obvious. Would you mind pointing out my error please? =ROUND(((A3-A4)*24*60),0) Same thing when showing the Tick Size for a Tick-Based Candle. This is just a simple way of displaying the time frame or tick count as a sort of watermark. https://www.sierrachart.com/image.php?Image=1691544626680.png |
| [2023-08-09 13:47:27] |
| John - SC Support - Posts: 36309 |
|
You have to change the "Value Format" of the "Text Display for Study" study. 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-08-09 15:11:20] |
| HumblyTrading - Posts: 179 |
|
Funny! I've somehow never selected that dropdown before. :) Thank you Mike |
To post a message in this thread, you need to log in with your Sierra Chart account: