Support Board
Date/Time: Wed, 27 Nov 2024 14:33:22 +0000
Post From: Help removing 2 decimal places when displaying text of a spreadsheet study
| [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 |