Support Board
Date/Time: Fri, 31 Jan 2025 18:56:31 +0000
Post From: calculate bars per x time
| [2019-05-16 09:16:21] |
| User907968 - Posts: 825 |
|
You could substitute FLOOR for MROUND in the formula above. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FLOOR_Function e.g. =FLOOR(A3,5/1440) instead of MROUND(A3,5/1440) This should round down the timestamp to the nearest 5-min, so 09:30:00 to 09:34:59 will all become 09:30:00 |