Hi, I was wondering if anyone has been working with the new ROUND() function released with version 1.4?
I have had success rounding simple formulas like CLOSE()/OPEN() but have not had much luck with more complex formulas, for example:
BARDATE()/7 + MOD(VALUE=30, 19 * MOD(VALUE=19, YEARNUM()) - 7) * 0.14;
I've tested this formula using two custom labels on the cursor, the first label using the ROUND function as follows:
testdate = BARDATE()/7 + MOD(VALUE=30,19*MOD(VALUE=19,YEARNUM())-7) * 0.14;
v1 = ROUND(testdate, DECIMALTYPE=0.00) ;
v1
and the second label not using the ROUND function at all as follows:
testdate = BARDATE()/7 + MOD(VALUE=30,19*MOD(VALUE=19,YEARNUM())-7) * 0.14;
testdate
With the cursor hovering over 12 April 2019 (BARDATE()=43567), both custom labels return 6227.777143. I would have expected that the label using the ROUND function should have returned a value of 6227.780000.
However, if I substitute the testdate variable with a simple formula like CLOSE()/OPEN(), the two custom labels return values as expected. For example, on the daily SPY (WI) on 12 April 2019, the custom label using ROUND returns 1.000000 while the custom label not using ROUND returns 1.002258.
Has anyone had a similar experience or can give me a clue on what I have missed?
Many thanks