Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 23:18:50 +0000
Post From: Automatically draw a horizontal line on a chart about 10 ticks apart.
| [2019-09-10 19:49:30] |
| Sawtooth - Posts: 3976 |
|
I have a personal excel file where for each futures and mainly for the bund I have 5 range levels up and 5 down with input the close of the prior day.
You can modify the Line Intervals study to use different offsets for each line.And you can copy/paste the 5 offset values from Excel to the SC spreadsheet. - Use cells I2-I6 for the 5 values. - Use cell J2 for the Close time. - No need to edit Line 1/Line-1 formulas. - For Line 2, edit cell AL3 to reference I3: =$AN3+$J$21*$I$3 - For Line -2, edit cell AP3 to reference I3: =$AN3-$J$21*$I$3 - For Line 3, edit cell AK3 to reference I4: =$AN3+$J$21*$I$4 - For Line -3, edit cell AQ3 to reference I4: =$AN3-$J$21*$I$4 - For Line 4, edit cell AJ3 to reference I5: =$AN3+$J$21*$I$5 - For Line -4, edit cell AR3 to reference I5: =$AN3-$J$21*$I$5 - For Line 5, edit cell AI3 to reference I6: =$AN3+$J$21*$I$6 - For Line -5, edit cell AS3 to reference I6: =$AN3-$J$21*$I$6 |