StockFetcher Forums · General Discussion · Betty Needs help with this filter<< >>Post Follow-up
billyspradling
13 posts
msg #69317
Ignore billyspradling
11/21/2008 3:28:00 PM

i am trying to find a filter that will show me the actual % loss of a stock in the past 1 year





price > 5
volume > 250000
Close dropped more than 60 Percent over the last 365 days


i have tried the filter above but it only gives me a defined percentage like 60% or 80 %

i am trying to make one that i can sort the actual percentages loss of all stocks in a column.

Many Thanks
Happy Holidays
Betty Spradling

dwiggains
370 posts
msg #69318
Ignore dwiggains
modified
11/21/2008 4:19:58 PM

Hi
Try this for a start

Fetcher[
set {drop, close / close 250 days ago} and add column drop and close > 5 and volume > 250,000 and sort column 5 ascending and drop > .01
]



Their are about 250 trading days in 1 year.
I had to make the drop > .01 or you get several companies that have not been around for 1 year.

See Ya
David

chetron
2,817 posts
msg #69320
Ignore chetron
11/21/2008 7:37:05 PM

or maybe.....

Fetcher[

/* tachikawa */

set{var1,close 250 days ago }
set {drop, var1 - close }
set{var2,drop / close}
set{dropper,var2 * 100}

add column drop
add column dropper

close > 5
volume > 250,000
sort column 6 descending
dropper > 1

]



StockFetcher Forums · General Discussion · Betty Needs help with this filter<< >>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