Support Board
Date/Time: Tue, 21 Jan 2025 04:10:16 +0000
Post From: Weekly high/low horizontal lines
| [2014-05-22 18:20:50] |
| vegasfoster - Posts: 444 |
|
You could probably do this in a spreadsheet study, issue being you may need a really fast computer depending on how far you want to go back and how many other studies you have on your chart. Assuming High is in column AA, in K3, =if(and(K4=0, AA4>0, AA3<>AA4), AA3, K4) -->this will identify first change in pivot and hold that value in L3, =if(and(K3<>0, L4=0, AA3<>AA4), AA3, L4) -->this will mark the next change that occurs and hold the value, but only after a high has been marked in K3, i.e. the second change etc... Just keep doing this for as many prior highs you want to show and replicate for lows and plot these columns. If you just want to show a certain number of the most recent, e.g. 3 most recent, then work it down from top instead of up from bottom. Too lazy to try it, so do one change first to validate and let me know if you have any problems. :-) |