StockFetcher Forums · General Discussion · New Comers to a List<< >>Post Follow-up
ely
6 posts
msg #153530
Ignore ely
8/13/2020 9:22:42 AM

Hi, sorry if that topic has already been discussed, but I couldn't find it...

Currently I have a filter which I ran on daily basis. My idea is to build some new filter or upgrade the current one to see only New Comers - the stocks which were not in the list the day before, but appeared in it on the latest day. Is there any way to do it in StockFetcher?

Many thanks in advance
Evgeny

xarlor
561 posts
msg #153531
Ignore xarlor
8/13/2020 9:26:02 AM

If you are comfortable sharing your filter, I can provide a way to do it using set and count functions.

ely
6 posts
msg #153533
Ignore ely
8/13/2020 9:53:48 AM

Sure! Thank you so much. Here is the filter I use:

Set {ma50d, daily moving average (50)}
Set {ma150d, daily moving average (150)}
Set {ma200d, daily moving average (200)}
Set {ma200d-, daily moving average (200) 4 weeks ago}

Daily close is above ma50d
ma50d is above ma150d
ma150d is above ma200d
ma200d is above ma200d-

Set {52wkhigh, high 1 year high}
Set {FromHigh, daily close / 52wkhigh}
FromHigh > 0.75

Set {52wklow, low 1 year low}
Set {FromLow, daily close / 52wklow}
FromLow > 1.3


xarlor
561 posts
msg #153537
Ignore xarlor
8/13/2020 10:55:22 AM

You most likely require an advanced subscription to run this, but here you go:

Fetcher[

Set{ma50d, daily moving average(50)}
Set{ma150d, daily moving average(150)}
Set{ma200d, daily moving average(200)}
Set{ma200d2, daily moving average(200) 4 weeks ago}

set{var1,count(close is above ma50d,1)}
set{var2,count(ma50d is above ma150d,1)}
set{var3,count(ma150d is above ma200d,1)}
set{var4,count(ma200d is above ma200d2,1)}

Set{52wkhigh, high 1 year high}
Set{FromHigh, daily close / 52wkhigh}
set{var5,count(FromHigh > 0.75,1)}

Set{52wklow, low 1 year low}
Set{FromLow, daily close / 52wklow}
set{var6,count(FromLow > 1.3,1)}

set{trigger1,var1*var2}
set{trigger2,trigger1*var3}
set{trigger3,trigger2*var4}
set{trigger4,trigger3*var5}
set{trigger,trigger4*var6}

trigger > 0
trigger 1 day ago equals 0
]



ely
6 posts
msg #153547
Ignore ely
8/13/2020 1:08:21 PM

That's amazing! Thank you so much Xarlor! Appreciate it!

StockFetcher Forums · General Discussion · New Comers to a List<< >>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.