StockFetcher Forums · General Discussion · Newbie Filter Help Required<< >>Post Follow-up
timfor
17 posts
msg #70955
Ignore timfor
1/26/2009 11:31:27 AM

Hello,

I am struggling with a basic filter and as a newbie I'm hoping someone can help me. I've read the instructions, etc. but I must be doing something wrong. I hope someone will be willing to help me out.

What I want is a filter that looks for stocks that have a total price movement of at least four dollars on average over a period of 5 days. For clarification sake, here is what I mean by "total price movement".

Fictitious stock ABC Corp has the following price action:

Day 1: Low $10, High $15...total price movement for day = $5 ($15-$10=$5)
Day 2: Low $12, High $15...total price movement for day= $3 ($15-$12=$3)
Day 3: Low $12, High $17...total price movement for day= $5 ($17-$12=$5)
Day 4: Low $14, High $18...total price movement for day= $4 ($18-$14=$4)
Day 5: Low $12, High $15...total price movement for day= $3 ($15-$12=$3)

So, total of $5+$3+$5+$4+$3 = $20 divided by five days and you get an average of $4 of total price movement per day.

Here is the filter I wrote:

Average Day Point Range(5) greater than or equal to 4.0
and Average Volume(90) above 500000
and Open above 7.00
and Close below 40


This doesn't seem to be giving me the results that I think it should.

Can someone please point out what I'm doing wrong?

Thanks in advance for any assistance you can provide.

Tim

johnpaulca
12,036 posts
msg #70958
Ignore johnpaulca
1/26/2009 12:14:47 PM

Clickable:

Fetcher[
Average Day Point Range(5) greater 4
Average Day Point Range(5) is equal to 4
and Average Volume(90) above 500000
and Open above 7.00
and Close below 40
]



heypa
283 posts
msg #70962
Ignore heypa
1/26/2009 2:20:31 PM

You have a conflict.
Use the phrase"Average Day Point Range(5) is greater than 4.0" only.
All you need except for any qualifiers you want to add.

timfor
17 posts
msg #71054
Ignore timfor
1/29/2009 3:24:11 PM

Thanks to you both for helping out. Things are working properly now.

Much appreciated.

Tim

StockFetcher Forums · General Discussion · Newbie Filter Help Required<< >>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.