StockFetcher Forums · General Discussion · Is there a way to add a column that shows the difference between<< >>Post Follow-up
RocketFetcher
59 posts
msg #36313
Ignore RocketFetcher
6/13/2005 6:05:01 PM

the day's close, and the 52 week high?
I think it involves the 'diff' function, but I've been experimenting and don't have it right yet.
Thanks in advance!


TheRumpledOne
6,411 posts
msg #36321
Ignore TheRumpledOne
6/14/2005 8:39:17 AM

Fetcher[

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 1000000
SORT COLUMN 6 DESCENDING
]



I added the DIFFPCT variable/column and sorted DESCENDING so you can see the percentage drop from the 52 week high.

Change the price and volume to fit your needs.

MAY ALL YOUR FILLS BE COMPLETE.



TheRumpledOne
6,411 posts
msg #36322
Ignore TheRumpledOne
6/14/2005 8:44:56 AM

Thought you might like this one too:

Fetcher[
SET{LOW52W, LOW 1 YEAR LOW}
SET{DIFF, CLOSE - LOW52W }
SET{X, DIFF / LOW52W}
SET{DIFFPCT, X * 100}

ADD COLUMN LOW52W
ADD COLUMN DIFF
ADD COLUMN DIFFPCT

CLOSE ABOVE 1
VOLUME ABOVE 1000000
SORT COLUMN 7 DESCENDING
]



Use this filter to see which stocks have made the biggest percentage moves off their 52 week low.

MAY ALL YOUR FILLS BE COMPLETE.


TheRumpledOne
6,411 posts
msg #36323
Ignore TheRumpledOne
6/14/2005 8:55:40 AM

Had another bright idea:

Fetcher[

SET{HIGH52W, HIGH 1 YEAR HIGH}
SET{DIFF, HIGH52W - CLOSE}
SET{X, DIFF / HIGH52W}
SET{DIFFPCT, X * 100}
SET{HDAYS, DAYS(HIGH EQUAL HIGH52W, 100)}

ADD COLUMN HIGH52W
ADD COLUMN DIFF
ADD COLUMN DIFFPCT
ADD COLUMN HDAYS

CLOSE ABOVE 1
VOLUME ABOVE 1000000
SORT COLUMN 7 DESCENDING
]



The HDAYS variable/column tells you the number of days since the last 52 week high.

NOTE: due to 100 day SF limitation, if the 52 week high occurred more than 100 days ago, the value for HDAYS will be -1.

MAY ALL YOUR FILLS BE COMPLETE.


RocketFetcher
59 posts
msg #36344
Ignore RocketFetcher
6/15/2005 8:20:18 AM

These are great; thanks Rumpled! I especially like the addition of 'HDAYS' to get the number of days since the last 52 week high.


StockFetcher Forums · General Discussion · Is there a way to add a column that shows the difference between<< >>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.