webstar187 1 posts msg #143344 - Ignore webstar187 |
4/25/2018 12:37:26 PM
How to add a column that will show me a percentage above a close 52 week low? I tried, "and add column percent above close 52 week low" but it did not understand. Below is my current filter that I'd like to add this to.
Thanks,
Newbie
show stocks where the average day range (100) is above 4.5%
and Price is between $0.001 and $10
and Average volume (30) is greater than 4000000
and Low is less than 25% above low 52 week low
and chart-length is 730 days
and Market cap is greater than 0.25 million
and not etf
add column Average Volume (30)
add column Average Day Range (30)
add column market cap
and add column low 1 year low
and add column close 1 year low
and add column close 2 year low
and add column close 3 year low
and add column percent above close 52 week low (THIS DOES NOT DO ANYTHING)
|
Mactheriverrat 3,156 posts msg #143346 - Ignore Mactheriverrat |
4/25/2018 2:29:58 PM
add column low 52 week low
|
mahkoh 1,065 posts msg #143347 - Ignore mahkoh |
4/25/2018 4:10:19 PM
set{x, close - close 52 week low}
set{x1, x / close 52 week low}
set{pctabove, x1 * 100}
add column pctabove
|
Mactheriverrat 3,156 posts msg #143349 - Ignore Mactheriverrat |
4/25/2018 4:18:51 PM
Nice code mahkoh!
also can sort by using the 52 week high
---------------
set{x, close - close 52 week high}
set{x1, x / close 52 week high}
set{pctabove, x1 * 100}
add column pctabove
|
Mactheriverrat 3,156 posts msg #143383 - Ignore Mactheriverrat |
4/28/2018 8:58:39 PM
draw high 13 week high
set{x, close - close 13 week high}
set{x1, x / close 13 week high}
set{pctabove, x1 * 100}
add column pctabove
One can sort by highest to lowest. 0.00 means price is rear near 13 week high.
|
Mactheriverrat 3,156 posts msg #143384 - Ignore Mactheriverrat |
4/28/2018 9:03:51 PM
draw pctabove line at -5.00
and pctabove is above -5.00
|