Support Board
Date/Time: Mon, 08 Sep 2025 03:43:11 +0000
Post From: Spreadsheet System for Trading
| [2015-07-01 23:36:22] |
| TechTrader - Posts: 116 |
|
Another solution is to utilise the 'Chart Start Time' J75 and the 'Seconds Per Bar' J36 from your spreadsheet. The following formula will add one intraday bar to the Chart Start Time. AND(MOD(TEXT(A3,"HH:MM:SS"),100)>$J$75+1/(86400/$J$36)) |