New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Relative performance of sectors (or stocks/ETFs) vs their 52-week highs
Is there a way to put several sector ETFs or stocks on one perf chart showing their respective performance vs their respective 52-week highs?
0
Comments
In theory, you could download the data and calculate the differences in excel and upload the results as user defined indexes (if your subscription allows).
Maybe someone else has a better idea?
A potential problem is if the chart time frame is too short, the upper price channel won't show.
A way around that is to use Fast Stochastics instead, with parameters 251,1 for daily, or 52,1 for weekly. Stochastics shows where price is in relation to the range of the specified period. So, for instance, if XYZ is near the top of its 52 week range, %K will be in the 80s or 90s; if it's mid range, in the 40s to 60s, and so on.
The advantage of the Stochastic indicator is it actually gives you a numerical value.
In fact, you could run a scan on a list of ETFs ranking by Fast K and it would list in order those closest to their respective highs. Then put the results in a list and candleglance it so they appear in order best to worst.
You could do it two different ways.
This way would express the location as a per cent of the total range, with the highest value being the closest to the high; in other words, the per cent of the range above the low. e.g. right now Utilities are closest at about 74% above its low and Materials the worst at about 4%.
// scan to rank by K
[ favorites list is ?? ]
rank by Fast Stoch %K(251,1)
// end scan
Or, you could do this:
// scan to rank by K
[ favorites list is ?? ]
rank by [100 - Fast Stoch %K(251,1)]
// end scan
That would give you the per cent off the high, so the lowest per cent would be the best - so Utilities would be about 26 % off its high (as a per cent of *range*, not price) and Materials 96% off.
You can sort the results on the rank by column ascending or descending, then replace your list, preserving the sort order by checking the box.
A visual that might help perhaps, is one I use related to Price Channels. I love them. I display them as an Area. I use two price channels. A short/intermediate term (like 8 or 13 week), and the 52 week. Color them the same color and make the short term a level or two higher in Opacity than the 52.
This will show you a couple of things quickly. It will show you where the short term (more current) activity is compared to the 52 week range. If you see the lighter color of the 52 price channel above and/or below the short term channel (darker color) you can tell approximately where the security is currently trading within it's 52 week channel. I do mostly all of my "line chart" work on Weekly and monthly charts as a supplement to my Point and Figure chart work.
Also, flat spots in the top and bottom of the channels show you where support and resistance may lie. I like to view longer flat spots as where SOS and SOW in Wyckoffian terms can appear.
I incorporate an awareness of different price channels into scans and alerts as well as my charts and custom CandleGlance.
I've attached a Snip of a weekly chart of ABT. You can see where the short term and the long term channels appear. Zigzag lines display what I try to interpret in a Wyckoffian way.
This is the 3 box reversal PnF chart for the approx period 2015 up to end of 2017
This is the 1 box reversal PnF chart for the "accumulation and breakout period"
Really appreciate the ideas and help!!
@_personalviews, I had some great teachers who taught me that the best way to learn is to practice, experiment and ask questions. I include markd in my group of teachers.