StockFetcher Forums · Filter Exchange · How to count number of times a stock made the same change as today ?<< >>Post Follow-up
7 posts
msg #108908
Ignore hazan
11/19/2012 6:06:03 AM


I want to create a filter that shows how many days the stock had a change in the range of the current day change +- 0.5 percent.
e.g. if the stock XXX went up 3%, then I want to show how many times it had a change between 2.5% to 3.5% in the last 100 days
The filter will show all stocks and just add a column that shows the number of times it was in the range in the last 100 days..

I tried to do it as below, but it doesn't work, any suggestions ?
It shows 100 for "inRangeCount" column all the time because it refers to "dayChange" of the day it checks and not the last day.

set{dayChange, close/open}
set{lowerDayRange, dayChange - 0.005}
set{upperDayRange, dayChange + 0.005}
set{aboveLowerDayRange, count(dayChange > lowerDayRange,1)}
set{belowUpperDayRange, count(dayChange < upperDayRange,1)}
set{isInRange, aboveLowerDayRange + belowUpperDayRange}
set{inRangeCount, count(isInRange > 1 ,100)}

close < 100 and
Average Volume(30) is above 200000

add column inRangeCount


431 posts
msg #108909
11/19/2012 7:01:46 AM

Try this filter found on the forums change to your liking.

close is between 1 and 15
average volume(90) above 50000
average volume(10) above 250000
offset is 0

set{volcnt, count(volume above 50000, 100) }
set{volzero, count(volume equal 0, 100) }

set{x1, high - open}
set{Long_Profit, x1/open }

set{C1A, count(Long_Profit > .04 , 100)}
set{C2A, count(Long_Profit > .09, 100)}
set{C0010, C1A - C2A}

set{D1A, count(Long_Profit > .09 , 100)}
set{D2A, count(Long_Profit > .19, 100)}
set{D1020, D1A - D2A}

set{E1A, count(Long_Profit > .19 , 100)}
set{E2A, count(Long_Profit > .29, 100)}
set{E2030, E1A - E2A}

set{F1A, count(Long_Profit > .29 , 100)}
set{F2A, count(Long_Profit > .39, 100)}
set{F3040, F1A - F2A}

set{G1A, count(Long_Profit > .39 , 100)}

and add column daychg2
and add column C0010 {4_9}
and add column D1020 {10_19}
and add column E2030 {20_29}
and add column F3040 {30_39}
and add column G1A {40+}
and add column C1A {ttl}

sort column 6 descending

7 posts
msg #108920
Ignore hazan
11/20/2012 7:50:04 AM

Thanks, but this filter shows how many times the stock was in specified range.
Anyway, SF support returned to me with saying that SF don't support this functionality :(

Thanks anyway.

StockFetcher Forums · Filter Exchange · How to count number of times a stock made the same change as today ?<< >>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