nm3tz
3 posts
msg #161945
- Ignore nm3tz |
8/18/2025 8:56:35 PM
This is working perfectly for me for current point in time screening, but I'm curious if I can scan for all historical data points.
For example,
Show stocks that have gapped up by 50% over the last 10 year period for example, and not just "current day"
|
xarlor
613 posts
msg #161948
- Ignore xarlor |
8/21/2025 8:48:31 AM
When you say "gapped" up by 50% over the last 10 year period" do you mean:
Stocks that have at least one day where it gapped up 50% within the last 10 years
or
Stocks that have risen 50% or more over the last 10 years?
|
nm3tz
3 posts
msg #161950
- Ignore nm3tz |
8/23/2025 6:43:14 PM
The first one,
Stocks that have at least one day where it gapped up 50% within the last 10 years
|
xarlor
613 posts
msg #161954
- Ignore xarlor |
8/25/2025 1:35:00 PM
As usual, we have to work around SF limitations. In this case, the limitation is the "count" command can only go back 252 days (1 year of trading days). So we trick SF to work for us by looking at each year separately
You will need the Advanced subscription due to the amount of "set" statements.
Summary: There were 2,956 tickers that had a 50% gap up in the last 10 years.
I sorted by those that had the most 50-gap days to the least. Unsurprisingly, most of those in the top are micro-penny tickers. You may want to include a price filter to get more pertinent results.
|
nm3tz
3 posts
msg #161956
- Ignore nm3tz |
8/25/2025 10:08:01 PM
Truly appreciate the response and the examples, thank you!
|