Support Board
Date/Time: Tue, 26 Nov 2024 20:41:20 +0000
Post From: Day/Date display on TPO bars
| [2021-11-23 16:22:18] |
| Sawtooth - Posts: 4120 |
|
You would use the example in post#2: - You would set the Number of Formula Columns to 60. - You would find the 9:30 bars with a formula like this in a Formula Column: =IF(MROUND(FRACTIME(A3),1/86400000)=TIME(09,30,00,000),C3*(1+$BR$3),0) where BR3 is the Display Offset This formula rounds the bar timestamp to the millisecond (to remove any floating point imprecision), and compares it to the TIME to the millisecond. When TRUE, it returns the price location for the alpha display of the Text To Draw. - You would replicate this formula in other Formula Columns, one column for each 30 min bar, editing the TIME for each. - You would use the Text To Draw fields of each SG# to label the alpha. - You would want to edit the Formula Column name in row 2 to match the alpha. |