StockFetcher Forums · Filter Exchange · Filter which gives % diff between 52 wk high and low?<< >>Post Follow-up
karennma
6,827 posts
msg #122208
Ignore karennma
12/11/2014 9:07:00 PM

For example, the filter says:
add column high 52-week high
add column low 52-week low
THEN, I want the % diff between the two columns.
Anyone know how to write that filter?


four
3,998 posts
msg #122210
Ignore four
modified
12/11/2014 9:12:39 PM

http://www.mathsisfun.com/percentage-difference.html

Fetcher[

set{x, abs(high 52-week high - low 52-week low)}
set{xx, high 52-week high + low 52-week low}
set{z, xx / 2}
set{zz, x / z}
draw zz
sp500

]



karennma
6,827 posts
msg #122211
Ignore karennma
12/11/2014 9:34:12 PM

SET{HIGH52W, HIGH 1 YEAR HIGH}
SET{DIFF, HIGH52W - CLOSE}
SET{X, DIFF / HIGH52W}
SET{DIFFPCT, X * 100}

ADD COLUMN HIGH52W
ADD COLUMN DIFF
ADD COLUMN DIFFPCT

CLOSE ABOVE 1
VOLUME ABOVE 500000
SORT COLUMN 6 DESCENDING

Found one! Compliments of TRO.


StockFetcher Forums · Filter Exchange · Filter which gives % diff between 52 wk high and low?<< >>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 2016 - 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