StockFetcher Forums · General Discussion · want to combine results<< >>Post Follow-up
rsingh
51 posts
msg #33577
Ignore rsingh
10/15/2004 1:28:32 PM

Let's say I have 2 filters one showing stocks
that moved above MA(50)
and other filter showing stocks that moved above MA(20)
but I want to display results from each of these on one page.
Is it possible????

So, X Y AND Z results from filter 1
and A B AND C results from filter 2
and the result I want to see is

X
Y
Z
A
B
C


DasKapital
36 posts
msg #33579
Ignore DasKapital
10/15/2004 2:15:24 PM

hey rsingh,

this might get ya close...
Fetcher[set{c1,count(close is above ma(50),1)}
and set{c2,count(close is above ma(20),1)}
and set{OR1,c1 + c2}
and find stocks where c1 is above 0
and add column ma(50)
and add column ma(20)
and add column c1 {>ma50}
and add column c2 {>ma20}
and add column OR1 and sort column 9 ascending
and draw ma(50)and draw ma(20)and do not draw c1
]


It selects stocks where the most recent close is above ma50 (OR1=1).
If most recent close is above ma20, OR1 = 2. The logic was originally
provided by TheRumpledOne, I think.

Enjoy!

DK


DasKapital
36 posts
msg #33580
Ignore DasKapital
10/15/2004 2:19:08 PM

rsingh,
Now that I see the results, I realize this may not be what you were looking for after all...maybe you or others can modify.

DK


DasKapital
36 posts
msg #33581
Ignore DasKapital
10/15/2004 2:34:41 PM

I think this might be better...
Fetcher[set{c1,count(close crossed above ma(50),1)}
and set{c2,count(close crossed above ma(20),1)}
and set{OR1,c1 + c2}
and find stocks where c1 is above 0
and add column ma(50)
and add column ma(20)
and add column c1 {>ma50}
and add column c2 {>ma20}
and add column OR1 and sort column 9 ascending
and draw ma(50)and draw ma(20)and do not draw c1
]



DK


rsingh
51 posts
msg #33582
Ignore rsingh
10/15/2004 2:38:02 PM

First, thanks for your feedback, but let me be more specific.
Let's say you have 2 filters and they give you 2 set of results.
I don't want to go to each filter and see the results separately.
I want to combine the results into one big result set. Can that be done, if yes then how?



cegis
235 posts
msg #33585
Ignore cegis
10/15/2004 7:30:50 PM

How 'bout just setting up a watch list??

HTH,

C


StockFetcher Forums · General Discussion · want to combine results<< >>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.