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
587 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:
|
snappyfrog
731 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?
|