StockFetcher Forums · Filter Exchange · The Grinch is in dire need of these two filter this Christmas season & beyond!<< 1 2 >>Post Follow-up
nikoschopen
2,824 posts
msg #57486
Ignore nikoschopen
modified
12/3/2007 9:42:55 PM

Alright, I already made this same request in the "SF pro wish list" thread dedicated to that elusive SF Santa, but I fear the jolly old man might overlook this request . So here I repeat verbatim.

There are in fact two things that I badly need this Christmas season. They're both a variation on the theme of days() function.

1) I need to calculate how many days a stock took to, say, run up 5% or more. Currently, the days() only tells us how many days ago the criteria was met but it doesn't tell us just how long it took to meet those criteria.

2) I need to use the value derived from the days() as a variable nested in another expression. Take "set{x, days(price reached a new 52 week high,10)}" for example. Suppose it spits out 2 as its value. Now I would like to find out whether there was a volume spike to support the new 52 week high by writing "count(volume x days ago is more than 200% above avgvol(50),1)" Unfortunately, this doesn't go down very well under the current system.


These two, in my otherwise myopic opinion, would literally change the way we write filters. That is, if they ever become a reality.

luc1grunt
622 posts
msg #57487
Ignore luc1grunt
12/3/2007 9:47:06 PM

Niko, I'm too thin to be a Santa, wish I could help.

Did you get my e-mail concerning futs?

TheRumpledOne
6,359 posts
msg #57526
Ignore TheRumpledOne
modified
12/4/2007 1:07:02 PM

*** WORK IN PROGRESS ***

Fetcher[

set{ cc1, close - close 1 day ago }
set{ cc1p , cc1 / close 1 day ago }
set{ cc2, close - close 2 days ago }
set{ cc2p , cc2 / close 2 days ago }

set{ test1 , count( cc1p above .0499, 1) }
set{ test2 , count( cc2p above .0499, 1) }

set{ pick , test1 + test2 }

add column cc1p
add column cc2p

pick above 0

]



This is for price increase by 5% or more in 1 or 2 days.

Of course, you can expand it to 3 or more days.

HTH.




nikoschopen
2,824 posts
msg #57529
Ignore nikoschopen
12/4/2007 1:19:00 PM

Grunt,

A reply has been sent!

nikoschopen
2,824 posts
msg #57530
Ignore nikoschopen
12/4/2007 1:23:34 PM

TRO,

Thanks for ure input, but I'm afraid that's not what I asked for. What I'm after is for the SF to tell me how many days have passed for the stock to rise 5 percent or more. Ure filter, on the contrary, requires you to manually specify the duration for this to happen (eg. 1 or 2 days).

TheRumpledOne
6,359 posts
msg #57568
Ignore TheRumpledOne
12/4/2007 8:31:53 PM

LOL...yes but while you wait, you can still have the results you want.

I don't know how many days before you don't care... 5 or less, 10 or less, etc.. So I just wrote a simple filter that you can expand on.



nikoschopen
2,824 posts
msg #57573
Ignore nikoschopen
12/4/2007 10:52:44 PM

Actually, there IS a way to manually calculate the number of days involved but as you will about to see SF is outta whack.

Fetcher[
set{pv, close * 20}
set{5pct, pv / 21}
set{dayz, days(price below 5pct,10)}
add column 5pct
add column dayz
]


The present value ("PV") of the price before the 5% move is shown on the column labeled "5pct" and the number of days that a stock took to gain 5% is shown in the "dayz" column. But, as you can see, only values shown for the "dayz" is -1.

I really hope SF personnel will have a chance to look into this or, better yet, hard code this feature.

guru_trader
485 posts
msg #57577
Ignore guru_trader
12/5/2007 12:20:22 AM

For the 5% rule ...
Is there a maximum or minimum number of days within which this event can occur? Can there be losing days between the start of the trend and the end?

guru_trader
485 posts
msg #57582
Ignore guru_trader
modified
12/5/2007 1:12:31 AM

I see what you mean ... I tried changing the formulas around a little with no luck ...

Fetcher[
and not otcbb
and set{cls,close}
and set{five_pct,cls / 1.05}
and add column five_pct
and draw five_pct
and draw cls on plot five_pct
and set{dysnc,days(cls below five_pct,100)}
and add column dysnc
and draw dysnc
]



guru_trader
485 posts
msg #57583
Ignore guru_trader
modified
12/5/2007 1:26:03 AM

As for your 2nd request, I would love to have that ability also ... and the ability to test on intraday data.

Done manually,
Fetcher[
and not otcbb
and close gained more than 5% in last 10 days
and set{vol_spike,count(volume 10 days ago greater than avgvol(50),1)}
and add column vol_spike
and draw vol_spike
and vol_spike > 0
]



StockFetcher Forums · Filter Exchange · The Grinch is in dire need of these two filter this Christmas season & beyond!<< 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 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