Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 19:12:59 +0000



Post From: how to add a list of vertical lines to a chart?

[2018-10-16 05:35:48]
Sawtooth - Posts: 3976
This could be done using the Spreadsheet Study study. There is no known example to follow.
Limitations:
-The spreadsheet study cannot place a text label at the vertical line.
-Maximum of 60 time windows.
-Times would need to be updated daily.
-There is no vertical line Draw Style. You'd have to use the Background Draw Style.
-For exact alignment, this will work best on time-based price bars.
-Some spreadsheet experience is recommended.

This is the basic setup:
-Each sheet is associated with a chart#, and on this sheet would be formulas to draw the vertical background between the start and end time when TRUE.
-A blank sheet would be added to the spreadsheet that is not associated with a chart#, and on this sheet one column would be for start times and another column for end times. The formulas on the chart's sheet would reference these times and compare them to the bar timestamp. You could manually enter the start and end times or paste them from Excel or a text doc.

If you are interested in this solution, post again and I'll give specific instructions.