StockFetcher Forums · Filter Exchange · Is it possible to create this scan?<< 1 2 >>Post Follow-up
waldo1323
14 posts
msg #52813
Ignore waldo1323
7/5/2007 5:34:47 PM

can you create a scan which lists stocks that have closed 1.618% ABOVE their 13, 21 or 55sma on the first day?

Thanks

alf44
2,025 posts
msg #52818
Ignore alf44
modified
7/5/2007 9:51:29 PM

...could you possibly make that criteria a little MORE precise ? lol

First, I see the "fib specific" requirements of the filter you're attempting...but, MAN...

You're asking a filter to return a percentage Close (carried to three decimals) above any ONE of any THREE different SMAs...

That's a challenge !

That "1.618% Close ABOVE" is also so precise that it would seem to be a tad too restrictive. imo

I looked at it a bit...perhaps others will give it a shot !


Regards,

alf44


guru_trader
485 posts
msg #52819
Ignore guru_trader
7/5/2007 11:50:42 PM

What do you mean by "on the first day"?

nikoschopen
2,824 posts
msg #52822
Ignore nikoschopen
7/6/2007 12:06:39 AM

A literal word-for-word translation of "stocks that have closed 1.618% ABOVE their 13, 21 or 55sma" is rather easy to write.

But I too don't believe that's what he had in mind, considering that the Fib number is growling for lion share of the attention. BTW Fib levels are calculated based on the high and low of the x-period range (eg. the difference between the high and the low of the 3-month range divided by 0.614). Hence, are you looking for 0.618 retracement level to be above those moving averages in question?

SAFeTRADE
644 posts
msg #52827
Ignore SAFeTRADE
7/6/2007 12:57:12 AM

This is my literal translation of your request. Sort on whatever MA you want to see.

Fetcher[
set{m13, ma(13) * 1.618}
set{m21, ma(21) * 1.618}
set{m55, ma(55) * 1.618}



set{ m13x, count(close crossed above m13 in the last 1 day,1)}
set{ m21x, count(close crossed above m21 in the last 1 day,1)}
set{ m55x, count(close crossed above m55 in the last 1 day,1)}

add column m13x
add column m21x
add column m55x

set{sub, m13x + m21x}
set{tot, m55x + sub}

tot > 0

draw m13 on plot price
draw m21 on plot price
draw m55 on plot price
]



alf44
2,025 posts
msg #52830
Ignore alf44
modified
7/6/2007 10:28:55 AM

...looks good SAFeTRADE...EXCEPT as I read it he's asking for a 1.618 percentage close ABOVE...

so...the MAs in those first 3 set statements SHOULD be multiplied by .01618...then THAT amount added to each MA.

Am I right or wrong on this ?


Regards,

alf44


nikoschopen
2,824 posts
msg #52831
Ignore nikoschopen
7/6/2007 12:45:07 PM

But then the question is WHY? I'm still beating my addlebrain on what the rationale is behind this scan.

alf44
2,025 posts
msg #52832
Ignore alf44
modified
7/6/2007 1:00:55 PM

...this is the scan waldo's after (if I understand correctly)...

----------------------------------
Fetcher[/* waldo's 1.618% close ABOVE either 13/21/55 MA scan */

set{m13%, ma(13) * .01618}
set{m21%, ma(21) * .01618}
set{m55%, ma(55) * .01618}

set{13fib, ma(13) + m13%}
set{21fib, ma(21) + m21%}
set{55fib, ma(55) + m55%}

set{m13x, count(close crossed above 13fib in the last 1 day,1)}
set{m21x, count(close crossed above 21fib in the last 1 day,1)}
set{m55x, count(close crossed above 55fib in the last 1 day,1)}

add column m13x
add column m21x
add column m55x

set{sub, m13x + m21x}
set{tot, m55x + sub}

tot > 0

Market is NASDAQ 100

draw ma(13)
draw ma(21)
draw ma(55)

chart-time is 3 months

and date offset is 1
]



-----------------------------------

As "SAFeTRADE" said in his post..."Sort on whatever MA you want to see."

Keep in mind that when you look at the chart it is showing a Close ABOVE the "MA + 1.618%"...not the MA itself !

Likewise with the column info...a "1" will appear in the m13x/m21x/m55x columns IF the Close is ABOVE that "MA + 1.618%" level.

A "1" in more than one column would mean that it has Closed ABOVE that "MA + 1.618%" level on more than one MA...on that same day.

The filter reflects a 1 day offset AND is applied to the NASDAQ 100 ! fwiw




Regards,

alf44


SAFeTRADE
644 posts
msg #52834
Ignore SAFeTRADE
7/6/2007 3:38:07 PM

Perception is reality. Until he is more specific, we have done all we can do.
Just because it doesn't make sense to me, doesn't mean it doesn't make sense.

waldo1323
14 posts
msg #52838
Ignore waldo1323
7/6/2007 7:59:41 PM

Thanks alf and the rest of you guys for helping me, I really appreciate it. To be honest with you a good friend of mine asked me if i could create a scan like what i asked for since he knows that i am a subscriber to this site. I have only been using my own basic "breakout" type scans which work pretty good for about a year. So if you need more specifics to actually narrow it down for another scan I will email him and post what he says asap. But by the looks of it Alf seems to be pretty close based on what my original question was.

I guess maybe i didn't word my original question properly but i think what my friend was asking is if it's possible to create 1 scan that would show the results of stocks that have closed 1.618% above either their 13 or 21 or 55sma and when i added "on the first day" i meant if stock XYZ gained .10 on the day is that the 1st day it was either above the 13-21 or 55sma? But like i said the scan alf posted seems like what the answer is or maybe i'm not smart enough yet to figure out what exactly i'm suppose to be asking, but i appreciate your time and help.

StockFetcher Forums · Filter Exchange · Is it possible to create this scan?<< 1 2 >>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.