StockFetcher Forums · General Discussion · Big gain AND Big Vol<< >>Post Follow-up
tylercabral
23 posts
msg #161298
Ignore tylercabral
modified
8/11/2024 11:18:01 AM

Hi,
I am having trouble creating a filter that shows 20% gain in the past 5 days along with 20 mil vol in the past 5 days. I'd like to filter for when both instances occur on the same day. I edited this filter another user helped create but it says I need to get the advanced sub to run. I think there might be an easier way to solve this. Any help is appreciated.

***********************************************************************

set{volume,close/open}
set{gain,close/open}
set{20vol,count(volume above 20,000,000,5)}
set{20%gain,count(gain above 1.20,5)}
set{x1,count(volume >= 20vol,1)}
set{x2,count(volume >= 20%gain,1)}
set{trigger1,x1+x2}
set{trigger,count(trigger1 equals 2,7)}
x1 > -1
x2 > -2
trigger > 0

add column trigger {No. times both conditions met in last 5 days}
sort column 5 descending


tylercabral
23 posts
msg #161299
Ignore tylercabral
modified
8/11/2024 2:53:39 PM

Ok I think I have a working solution but...I have no clue. Seems to be outputting data I am looking for:

close is between 1 and 20
volume is above 100,000

set{gain,close/open}
set{20%gain,count(gain greater than 1.20,1)}
set{biggervol,count(volume greater than 20,000,000,1)}

set{both, 20%gain + biggervol}

set{both2, count(both equals 2,120)}

add column both2

both2 > 0

xarlor
580 posts
msg #161300
Ignore xarlor
8/12/2024 10:08:53 AM

That definitely looks like my coding, but the edits made it... an abomination.

If all you're looking for is tickers that hit 20 million volume at the same time they jumped 20%, this is it at its simplest:

Fetcher[
close between 1 and 20
volume > 20,000,000
Close-to-open gap >= 20
]



snappyfrog
721 posts
msg #161302
Ignore snappyfrog
8/12/2024 10:05:56 PM

Maybe I'm not reading your post right?

But, you said volume for the last 5 days over 20 mil, as in above 4 mil * 5 days?

And close more than 120% of 5 days ago?

Fetcher[
close between 1 and 20
volume > 4,000,000 for the last 5 days
Close > close 5 days ago * 1.20
]



StockFetcher Forums · General Discussion · Big gain AND Big Vol<< >>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.