StockFetcher Forums · General Discussion · How to add a 52 Week Low Column<< >>Post Follow-up
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

StockFetcher Forums · General Discussion · How to add a 52 Week Low Column<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.