StockFetcher Forums · General Discussion · 2 conditions: volume spike and 5 mil shares+, looking back 10 days prior<< >>Post Follow-up
tylercabral
23 posts
msg #158710
Ignore tylercabral
3/2/2022 9:04:33 PM

I'm embarrassed I can't write this myself as someone who tinkers with R.

I'm basically looking for a filter that is looking for the following 2 conditions that both occur on a day. If it can look back a week or 10 days and return all stocks that have hit these conditions that would be great:

1. volume 200% over the 10 day average
2. volume of 5 mil shares+

I feel like this probably easy to create. I can make this for a single day, however I can't seem to write a filter that will look back over a week and return the stocks that have these conditions. Thank you for the help!

compound_gains
222 posts
msg #158711
Ignore compound_gains
3/2/2022 9:52:50 PM

Fetcher[
set{x1, count(volume more than 200% above average volume(10) 1 day ago, 1)}
set{x2, count(volume above 5000000, 1)}
set{x3, x1 + x2}
count(x3 equals 2, 10) above 0
/*choose your price / volume filter*/
close between 10 and 50
count(volume above 500000, 20) equals 20
]



xarlor
587 posts
msg #158712
Ignore xarlor
modified
3/2/2022 9:58:51 PM

Fetcher[
set{vol200,average volume(10) 1 day ago * 3}
set{x1,count(volume >= vol200,1)}
set{x2,count(volume >= 5000000,1)}
set{trigger1,x1+x2}
set{trigger,count(trigger1 equals 2,10)}
x1 > -1
x2 > -2
trigger > 0

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



miketranz
969 posts
msg #158713
Ignore miketranz
modified
3/2/2022 10:00:38 PM

Fetcher[volume is more than 200% above average volume(10) 1 day ago
and average volume (30) is above 5000000
and close is between .20 and 100
and date offset is 10 days
]



Mactheriverrat
3,157 posts
msg #158714
Ignore Mactheriverrat
3/2/2022 10:40:50 PM

@ tylercabral
Nothing to be embarrassed about. It will come to you in time.

tylercabral
23 posts
msg #158723
Ignore tylercabral
3/4/2022 2:00:47 PM

Holy cow I am humbled and appreciative! Thank you so much for this help! There is no way I could have gotten this based on the answers, but I will continue learning and trying :D

StockFetcher Forums · General Discussion · 2 conditions: volume spike and 5 mil shares+, looking back 10 days prior<< >>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.