Support Board

Date/Time: Tue, 07 May 2024 10:39:45 +0000

Post From: calculate bars per x time

[2019-05-16 09:16:21] Link To Thread - Link To Post [Go To First Post]
User907968 - Posts: 802
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