Support Board
Date/Time: Mon, 27 Oct 2025 16:57:50 +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)) |