Support Board
Date/Time: Fri, 31 Jan 2025 19:09:09 +0000
Post From: calculate bars per x time
| [2019-05-16 05:09:59] |
| Sawtooth - Posts: 4164 |
|
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'. |