StockFetcher Forums · Filter Exchange · Hi Low Filter<< >>Post Follow-up
7 posts
msg #121106
Ignore Gurok
7/26/2014 9:13:01 PM

Hello Everyone,

I am new to stockfetcher and not learned how to program yet. The type of instrument that I trade it is best for me to catch the high and low of a particular stock. The way I am thinking how to achieve this comes from therumbledone(TRO) milking the cow filter idea. What I would like to do is create a filter in which for the last 100 days the high has been a certain percentage above the open price. Here is an example say for instance that for the last 100 days the high of the day of a particular stock has been around 40 to 50 cents 80 percent of the time, or the low of the day has been around -40 to -50 cents 70 percent of the time of a particular stock. How would I go about programming a filter that can do this using stockfetcher. Hopefully this makes sense.


206 posts
msg #121119
Ignore djones000buck
7/27/2014 1:13:56 PM

From tro there are many scans that do this if you search his threads. You mentioned percentage but your example was in cents so not sure which you prefer.


set{oplow, open - low}
set{down.10, count( oplow > 0.09, 100 ) }
set{down.50, count( oplow > 0.49, 100 ) }
set{down1,count( oplow > 0.99,100)}
set{down2,count( oplow > 1.99,100)}
set{pct1, down.50 / down.10 }
set{winpctdown, 100 * pct1 }

set{ hiop, high - open }
set{ up.10, count( hiop > 0.09, 100 ) }
set{ up.50, count( hiop > 0.49, 100 ) }
set{ up1, count( hiop > 0.99,100)}
set{ up2, count( hiop > 1.99,100)}
set{ pct2, up.50 / up.10 }
set{winpctup, 100 * pct2 }

add column up.10
add column up.50
add column up1
add column up2
add column winpctup{winup%}
add column down.10
add column down.50
add column down1
add column down2
add column winpctdown{windown%}
add column average day range(10) {adr10}
add column average day range(30) {adr30}
add column average daily volume(90)

add column updownavg

updownavg above 79

average volume(90) above 1000000
average day range(30) above 3

market is nasdaq
price above 40
sort column 14 descending

7 posts
msg #121120
Ignore Gurok
7/27/2014 1:50:59 PM


When I said cents and percentages I was referring to TRO video when he used 100 days to measure 100%( which will be $1.00) so say for instance out of those 100 days, the High of the day was up 60 cents from the open price 50 days out of 100 days which would means 50%(100 days - 50 days = 50) of the time the high of the day was 60 cents above the open. Hopefully that makes sense now. Thank you for replying.

Best Regards,

4,381 posts
msg #121121
Ignore four
7/27/2014 3:23:58 PM

/* for the last 100 days the high has been a certain percentage above the open price */

russell 3000
set{x, high - open}
set{xx, x / open}

set{z, count(xx > .01,100)} /* number of days greater than 1% move from open to high for 100 days*/
add column z
sort column 5 descending
draw xx line at .01 /* 1 percent */

7 posts
msg #121127
Ignore Gurok
7/28/2014 10:00:19 AM

Thank you very much four it is very much appreciated =)!

4,381 posts
msg #121153
Ignore four
7/28/2014 8:31:11 PM


StockFetcher Forums · Filter Exchange · Hi Low Filter<< >>Post Follow-up

*** Disclaimer *** 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. does not recommend particular securities., 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 2018 - 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