Posts: 881
Joined: 2/18/2009
User Profile Hello everyone
Trying to build a scan where the stock has dropped by X % in the last year and currently it has not drop further in the last week (but also did not rise by more than 10%)
Any ideas on how to build this scan?
Thanks
Posts: 25
Joined: 6/9/2024
Location: South Australia
User Profile Hey there Duxx,
Here’s how you could structure the formula:
Scan Criteria:
Stock Dropped by X (in this example its 20%) in the Last Year: Look at the closing price over the past year and ensure that the stock dropped by more than or equal to 20%.
Current Status (Last Week): The stock should not have dropped further in the last week, but it also did not rise by more than 10%.
1. Click on 'Add Scan' to create a new scan.
2. In the 'Scan Type' dropdown, select 'Technical'.
4. Enter a name for your scan in the 'Name' field, such as '20% Drop Last Year with No Further Dips'.
5. In the 'Conditions' section, add a condition that checks if the stock has dropped by at least 20% and not dropped further in the last week (or rose by more than 10%).
((Close / Close(-365) - 1) * 100 <= -20)
AND ((Close / Close(-7) - 1) * 100 >= 0
AND (Close / Close(-7) - 1) * 100 <= 10)
6. Save your scan and run it to get a list of stocks that meet your criteria.
Give this a go and let me know if that is what you are hoping to achieve.
Please note: This formula does not account for the possibility that the stock price may have risen or fallen by more than the set criteria over either of the periods of 1 year (at least -20%) or the past week (0 to 10%).
Cheers Etherist