Support Board
Date/Time: Fri, 28 Feb 2025 08:58:20 +0000
Post From: how to add a list of vertical lines to a chart?
| [2021-07-27 13:07:00] |
| Sawtooth - Posts: 4177 |
|
Assuming the chart bars are daily bars, you could: Add the Spreadsheet Study study - Give it a name in the Spreadsheet Name field - Set the Chart Region to 1 - Check 'Draw Study Underneath Main Price Graph' - Set the 'Number of Formula Columns' to 60 - Set the Draw Style to Background, and the Width/Size to 2, of all 60 subgraphs - Use a formula like this in row 3 of any column, K to BR: =INT(A3)=DATEVALUE("07/23/2021") Alternatively, you could create a list of dates in column H, and use a formula like this in row 3 of any column, K to BR: Cell K3: =INT(A3)=$H$1 where the date in H1 is in this format: 2021-07-23 Increment the referenced column H cell for each column, K to BR, e.g.: Cell L3: =INT(A3)=$H$2 Cell BR3: =INT(A3)=$H$60 The max number of columns is 60, so the max number of dates is 60. Dates do not need to be in order. Date Time Of Last Edit: 2021-07-27 20:00:17
|