Registered User Joined: 9/25/2007 Posts: 2
|
How to get On weekly bars - X months ago high or low.
eg: July High or Low for bar in September
Jan High or low for April
thanks in advance.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can't actually mix time frames. So you can't plot the high of January on a weekly chart in July unless you happen to be in the unusual circumstance of the trading weeks not overlapping into December and/or February.
About the best you can do is plot a number of weeks ago ending on a particular bar. You are probably going to have to assume the month is four weeks long, even though it is a bit longer (to completely include an entire month, you may need to use five weeks).
365.2422 / 7 / 12 = 4.34812142857 (that 142857 part just keeps repeating)
Now you can specify a date as part of that (it would be the last day of the period of interest).
MAXH4.'01/31/2017'
-Bruce Personal Criteria Formulas TC2000 Support Articles
|