Historical Stock Data Analysis

Attached is output from a stock trading program for years 2010 - 2017. One tab has all the output with buy signals. The second tab has suggested picks. I am seeking an experienced analyst to perform a year to year comparison and analysis. Define patterns that will produce year to year consistent positive annualized returns. Should be able to work independently with minimum supervision. Experienced with Ms excel and VB Macros. Experience and understanding of US stock market dynamics and technical analysis is a big plus. Assignment must be completed in not more than two weeks. This includes testing of developed methodology using other dates. Required: 1. Define three methodologies to analyze the output in "year", "yearbuys" or both tabs. 2. Provide your results in tables. 2. Provide pros and cons of each method. 3. Define criteria for method which provides the highest and consistent year over year returns.