- 10% Paid to OzGrid?
I made a short YouTube video showing exactly what I want, which may help, see below -
** I am looking for VBA code to find stock codes where price has dipped lower, then recovered most, or all, of the lost value - within 10 trading days.
Starting at the first entry at top of the ASX List (which may vary in length).
Copy the first code on the ASX List, PASTE it into cell A2 (this should retrieve the data for that code and paste it into this worksheet).
IF there is a low within the last 10 trading days, that has traded below the previous close by the amount of the Change or greater (9%),
AND, where price has since recovered to within the amount of the Recovery or greater (1%).
(if this criteria is met),THEN print the code under the header 'Targets', starting at cell L2, and building a list of codes that meet this criteria.
THEN move to the next code on the ASX List
continue until all the codes in the ASX List have been tested to meet the criteria,
THEN show a Message Box to say that "The task is now complete".