Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 07 May 2024 20:01:27 +0000

How to Post a Message for Support

Post From: calculate bars per x time

[2019-05-16 05:09:59]
[Go To First Post]
Sawtooth - Posts: 3993
1. There are 1440 minutes in 24 hours, so 5/1440 is equal to 5 minutes in Serial DateTime format.
Spreadsheet Functions: Serial DateTime Values
The MROUND function in the formula rounds the bar timestamp up or down to the nearest 5 min interval.

2. The easiest way is to set the Session Start time to 09:30:00, and check 'New Bar At Session Start'.