Support Board

Date/Time: Sun, 05 May 2024 22:29:47 +0000

[Programming Help] - Round inputs or output data to speadsheet. removing flowinf points in aa-zz collumn

[2019-09-19 22:04:17] #1 [Go To First Post]
ozunainc - Posts: 16
how do I round the floating point from column aa-zz. please give me step by step. I read the process of h21, but I don't understand it. I think I attached a pic. sorry if it not attached, but where do I place the spreadsheet formula? what formula do I use? The following formulas can be used to remove floating point imprecision from various items in the Spreadsheet Studies. Remove Floating Point Imprecision of the Tick Size in cell J21. Place this formula in cell H21: =1 / ROUND(1 / J21, 0) Remove Floating Point Imprecision of a Calculated Value to a Multiple of the Tick Size (see above formula): =MROUND(CalculatedValue,$H$21) In this case the CalculatedValue could be any formula or another cell. Remove Floating Point Imprecision of the OHLC Values to a Multiple of the Tick Size (see above formula): =MROUND(B3, $H$21) =MROUND(C3, $H$21) =MROUND(D3, $H$21) =MROUND(E3, $H$21)

To post a message in this thread, you need to log in with your Sierra Chart account: