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.
Percentage above the 52-Week Low
I'm new to writing scans. I want to scan for stocks that are 50% or more above the 52-Week Low. Is this correct? Thx in advance.
and [close >= Min(253, Daily Low) * 0.5]
If you ask for 0.5 x the base value, you are asking for half the base value - in other words, values BELOW min(253,low).
But, you want prices 50% higher than the base value - or, another (better - meaning more clear) way of saying that is, 150% of the base value, or in decimals, 1.5 x the base value.
So, this should work:
and [close >= Min(253, Daily Low) * 1.5]
and [[[Max(253,High) - Min(253,Low)] / [Min(253,Low)]] * 100 > 50]
and [close > min(253,low) + [[max(253,high) - min(253,high)] * .5]]
A similar, but not identical scan would be
and [close > middle Price Chan(253)]
//Select one or more of your lists using the dropdown in the workbench
My List #1
or My List #14
Rank by [close / middle Price Chan(253)]
This will sort your list(s) in descending result of the rank by statement. It will also show the result of the rank by in the last column in the results. You can then save your results in that order if desired. The Value won't be stored, the ranking will. If you want to have the value stored, you'd have to export to csv and then import the properly formatted csv into a chartlist.
In this case they would be ranked in descending Percentage value away from the middle price channel specified. With the ones higher percent above the MPC listed 1st.
If your last column in the results is not the rank by value then you have an issue with the rank by statement that it didn't like, so therefore, ignored. Fix it and try again.
Also make sure that you SELECT your chartlist(s) using the dropdown in the workbench. DO NOT type them in.
Properly formatted csv is Column A imported into the Symbol Column B is imported into the Name field Column C is imported into the Notes field. No header row allowed.