Support Board
Date/Time: Sat, 10 May 2025 21:46:59 +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)) |