| 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,173 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,173 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,173 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,173 posts
 msg #143384
 - Ignore Mactheriverrat
 | 4/28/2018 9:03:51 PM 
 draw pctabove line at -5.00
 and  pctabove is above -5.00
 
 
 |