I need help creating this tool please

Let's make sure I understand the request before I attempt a solution. You want to see a list of stocks that have drop at least 0.5% and no more than 3% from.... and here is where I am getting tripped up..... from the current price. Seems we are missing the part that the current price is being compared to. Let's say one of those stocks has dropped 1%. What value was the starting point for that drop?

The 1% drop is the current price. So it must have dropped 1% from the:

1. previous day's close
2. current day's open
3. current day's high
4. something else entirely?

Once we get the two values you want to compare then we can build a solution. Once we do that, we'll be updating the title of your question because "I need help creating this tool please", does nothing to explain to the rest of our viewers what you are requesting. Imagine if everyone used a subject line like that? The Q&A forum would be completely unusable, unsearchable and without form and structure.