Support Board
Date/Time: Fri, 20 Mar 2026 08:22:53 +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)) |